Source levels obtain values for their categories
from columns in the Data Sources list. You can add source levels to
a dimension either on the Dimension Map or in the Categories diagram.
Suppose
the Region dimension of your sales model has three levels: Region,
Country or Region, and Branch Name. You add sales representatives
to the Region dimension by selecting the Sales Rep column from the Data
Sources list and dragging it to the spot indicated in
the following image.
Tip: You can create a default time dimension with
Year, Quarter and Month levels by setting the Data class on
the General tab of the Column property
sheet to Date and dragging the column to the Dimension
Map.
Procedure
- In the Data Sources list, select
the column for which you want to create a source level.
- Drag the selected column to the appropriate location on
either the Dimension Map or an existing level
in the Categories diagram.
On
the Dimension Map, Cognos®
Transformer shows a small outlined
box where it will create the new level.
On the Categories diagram, Cognos
Transformer inserts the
new level to the left of the level on which you drop the source column.
- Open the Level property sheet to
set or modify the level properties and click OK.
Note: Source levels can also be added by selecting
an existing level on the Dimension Map or Categories diagram,
clicking Insert Level from the Edit menu,
and specifying the Associations for the new
level.
