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,