Designer Guide

Back Next

Step 2. Add Levels to the Dimension

After you create the dimension, add the needed levels. Levels hold the properties necessary to create target tables.

To add a level to a dimension:

In the Dimension Editor, select Levels and click Add Level.

Enter a name and description for the level.

The Level name must be unique within the dimension.

Click Level Properties.

Click the Import from Source Fields button.

The name of a level property must be unique within the dimension.

Select a source table from which you want to copy columns to the level.

The columns display in the Source Fields section.

Select the columns you want to add to the level.

Click the Copy Columns button to add source columns to the level.

Click the Add Columns button to add a new column to the level.

Click OK after you add all the columns.

The Dimension Editor displays the new level.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.