Measure to Dimension

user09861
user09861
in Archive

I have an ID column that is an integer and getting categorized as a Measure in Analyzer - how do I convert that field to a Dimension? 

Thanks!

Comments

  • RGranada
    RGranada Contributor

    Hi,

     

    Try this in a beast mode:

     

    Concat(Your_Field_Name,'')

     

    Hope this helps.

     

    Ricardo Granada 

    [email protected]

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • user09861
    user09861

    Will that still leave the field available in both Measure and the beast mode calc in Dimension? That seems like it would be confusing to an end user to have it appear in both sections?

  • RGranada
    RGranada Contributor

    Yes it will, in order to hide the original field, you will need to use a dataflow, and select just the fields you need to expose to the end user and the same formula to convert the field, something like :

     

    Select field1, field2, fieldx, concat(field10, '') from your_table_name

     

    Hope this helps. 

    Ricardo Granada 

    [email protected]

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.

Categories