Home > About Dimensional Database ... > About Cube Dimensions > Data Transformations During...
![]() Previous |
![]() Next |
By default, OLAP converts non-text dimension keys to text when loading them into a cube dimension.
OLAP also adds the level name as a prefix to the relational key when forming the member name. See "Dimension Members Must Be Unique". You can change this default transformation on the Storage panel of the Create/Edit Cube Dimension dialog box.
You can also use expressions when mapping dimensions. This capability enables you to create the top level of a dimension without having a source column in the dimension table.