Cognos Powerplay Transformer Cubes - Time Dimension - Date - Week - Fundamental Tutorial - Part-4-of-30

For Details: Visit: htt://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Creating a Cognos Time Dimension - Date and Week Level:

This is second part of creating Time Dimensions. Please watch the previous video to create a Time Dimension.


1- Open a Cognos Powerplay Transformer model.
2- Right click the Time Dimension and click on Insert Level.
3- Set Name as Week. Select the source as Date and Check the Unique Level selection box.
4- Click on the "Time" Tab. Select the Date Function as Week. You can see the Time Level Ranking automatically Set to 40.

By Default Cognos sets Time Level Ranking for
Year --> 10,
Quarter -->20
Month -->30
Week --> 40 and
Date --> 50

5- Click on OK and you can see the week level getting created.
6- Similarly Create another level for Date
7- Generate Categories and see Time Heirarchy.
8- Clicking on Show Diagram, now you will find the Year --> Quarter --> Month --> Week--> Date Levels.


SO THATS IT.....

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

IBM Cognos Powercube Basic free Tutorial for Beginners,

IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners, 

Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners, 

Visit blog for detailed steps.

http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy 

cell: +91-8082112148

email:  info@bharaticonsultancy.in

bharati.dwconsultancy@gmail.com 

website: http://bharaticonsultancy.in/