Measure to Dimension

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

  • Hi,

     

    Try this in a beast mode:

     

    Concat(Your_Field_Name,'')

     

    Hope this helps.

     

  • 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?

  • 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.