For Details: Visit: htt://www.bharaticonsultancy.in
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.
SO THATS IT.....