Hello community,
We have a report in Excel format which holds a crosstab with multiple hierarchies on the left-hand axis. Here is an example, (Year, Month, Day are the hierarchies):
Mesure1
Year1 Month1 Day1 data1
Day2 data2
Month2 Day3 data3
Day4 data4
Year2 Month3 Day5 data5
Day6 data6
Month4 Day7 data7
Day8 data8
In the Excel sheet we wish to display the categories unmerged, so that every row would display the year and month.
Any hints of how to achieve that in Cognos 11.1.7?
Many thanks.
------------------------------
Ori
------------------------------
#CognosAnalyticswithWatson