Thursday, April 11, 2013

Creating a Cognos Time Dimension

For Details: Visit:

Creating a Cognos Time Dimension:
1- Open a Cognos Powerplay Transformer model.
2- Right click the Dimension Map- area, and click on Insert Dimension.
3- Give a name to this Dimension and then select the Dimension type as Time.
4- Click on the "Time" Tab. Select the date column, on which this dimension will be based on.
5- Click on OK and You can see a Time Dimension getting created.
6- Generate Categories and see Time Heirarchy.
7- Clicking on Show Diagram, you will find the Year --> Quarter --> Month Levels.
8- Watch out in the Next video - steps to create Week and Date levels.


No comments:

Post a Comment