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
1. In the Data Sources list, select the column for which you want to create a
source level.
2. 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.
3. 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.
Add Manual Levels to a Dimension
Manual levels provide a means of grouping categories from various source levels
under a new, special category, or allow for intermediate groupings where there are
too many child categories to be easily seen in the OLAP reporting components.
Because categories in manual levels typically connect to source categories in a
lower level, new source categories that are not linked to a parent manual category
may appear during the generation process. You can set up a temporary placeholder
category in the manual level, where these new orphan categories can be placed by
default.
You cannot use manual levels for subsets in your reporting component.
Before you begin
Tip: If you are building the same dimension in several models, you can create a
spreadsheet to hold your manual categories and their associated source categories
and use this spreadsheet as the data source for each model.
Procedure
1. Open the Categories diagram for the dimension in which you want to create a
manual level by selecting the dimension on the Dimension Map and from the
View menu, clicking Categories.
2. At the top of the diagram, position the pointer over the right side of an existing
level.
The pointer changes to a crosshair.
3. Drag the crosshair to a position between two levels and release the mouse
button.
Cognos Transformer creates a new manual level and opens its property sheet.
4. In the Level name box, type a name for the new manual level and click OK.
62 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Need help?
General