Date Hierarchy comparison between transformer cubes.

[vincydza@gmail.com]

Hi,

I have two cubes created in Cognos Transformer

1. Sales Analysis Cube
2. Sales BI cube.

The cubes are created and published in Content store. However when reports are created based on these cubes the levels for date hierarchy are not identical.

In the Sales Analysis cube Year/Quarter/Month/Week and Day show as Levels however in the Sales BI cube Year/Quarter/Month & Week show as parent child.

How can the date dimension in the Sales BI cube be configured to be identical to the Date Dimension in Sales Analysis Cube.

See attached document for comparison of date dimension between two cubes

Please advise

Vincent