Create a Text Column
How do I create a text column which shows up a dimension in the discover?
I am also curious on different methods that can be used to achieve this.
Use Case: I want to use these text columns in the matrix grid because it's easier for me to format, align and maintain consistency.
Thanks,
Rajesh
2 replies
-
Hi ,
Any text column in the underlying data tables will show up as a dimension / hierarchy in your model provided it is identified as such (i.e. first checkbox is checked in the model definition).
If you want to create a new column, you can do this either by creating the calculation explicitly in the Model Data Flow, if it has one (calculated columns), virtually in the Model Definition (Virtual Calculations), or dynamically in Discover by right clicking on the hierarchy (for simple calculations, like the first character or combining columns) or Formulate (Custom Columns) for more complex multi column calculations.
You may also want to investigate a text column defined as a Measure using Text Aggregation.
Hope that helps.
Ian