Add Double Column Support

Double column support allows you to associate two columns. One column provides the display and description values such as the description of an item. The second column provides a descriptor ID or code column.

For example, you can use the actual column to provide the project list, and hide the ID column associated with the first column, as in Clinic and Clinic ID. Only the Clinic description is displayed to the user.

Using double columns can help improve performance because filtering is done on the ID column, which is numeric and indexed.

Using double columns helps satisfy Essbase's uniqueness requirements.

When multilingual columns are based on a lookup function, you can specify the non-translated lookup key column as the descriptor column of the translated column. You can use double column support to defining language-independent filters. For example, in analyses users see the display column, but the query filters on the hidden descriptor ID column.

See Support Multilingual Data.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
4. In the Logical Layer pane, browse for the table with the logical column you want to use as a double column.
5. In the logical table, click the Columns tab.
6. In the column table, click the column to highlight it, and then click Detail view to view its properties.
7. In the logical column's General properties, click the Descriptor Column field and select the column you want to use.
8. Click Save.