Add Columns

You can create columns to provide additional data elements or calculations.You can add derived and physical columns.

1. On the Add Column page, select Add Derived Column, and complete these steps:
   1. In Create Column, enter a display name.
   2. Under Data Elements, search for a data element from the physical table of the selected dimension table.
   3. From the search results, double-click the data element to place it in the text pane.
   4. Under Functions, search for a function to construct a column using expressions. For example, search for functions like "substring" or "concatenate" to construct new expression-based columns. From the search results, double-click the applicable result to add it to the central text pane.
   5. Click Validate, and then click Save.
2. On the Add Column page, select Add Physical Column, and complete these steps:
   1. In Select Physical Column, select the columns and click OK.
   2. On the Add Columns page, for the physical columns, select the Display check box to expose the columns, and click the Logical Level icon to set the required level.
   3. In Set Logical Level, select the dimension, select the level of the dimension hierarchy, and then click OK.