Thursday, 17 March 2016

Create Half Year Level

When Cognos Transformer generates the Time Dimension, it does not have a Half Year Level. To add a half year level in your cube follow the following steps:
1. Generate the Time Dimension
2. Insert Half Year level above Quarter
half_year
3. Generate categories
4. Click Show Diagram. You will see that from Year level, the data directly links to Quarter level
time_categories
5. Click on a Year and drag and drop the line to Half Year column. Fill up the category information with Half year label and code.
6.Link the associated Quarters with the Half Year value by clicking on the Half Year value and dragging and dropping the line to the Quarter value.
half_to_quarter
Keep in mind that if you do a full clean house, the Half Year member you created will be erased and you have to add them again manually.

No comments:

Post a Comment