Skip Headers
Previous
Previous
 
Next
Next

Data Transformations During a Load

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.