If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Time Dim Hierarchies

Started by cognos05, 05 Feb 2018 11:07:37 AM

Previous topic - Next topic

cognos05

Hi ,

I am using cognos transformer to create my time dim hierarchies and I have it based in Fiscal year and calender year and then drill down to months as lowest level .

My question is I have

A Hierarchy which shows FYTD Grouped and another hierarchy which shows MTD Grouped

User wants both to be combined under a single element so that when using analysis studio they can see data with respect to both hierarchies .

Remember in anlysis studio you cant drag more than one hierarchy in to the columns.

If its a report studio report I could write finctions based on a month to get the required data from lowest level .

I was able to create an new element and drag and drop the already created hierarchies under them .

I wanted to knwo if this is okay to do  and If I need to have FYTD alone as a seperate hierarchy , then I have to duplicate the code .

Thanks,