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
2. Insert Half Year level above Quarter
3. Generate categories
4. Click Show Diagram. You will see that from Year level, the data directly links to Quarter level
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.
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