All,
I need help with the world's most idiotic crosstab requested from my boss. I basically need to:
-Put a dimension on the rows of the crosstab
-List the top 5 highest measures in the nested rows of the crosstab
-Have a column for the rank of each measure (1-5), the value of that measure, and the % of that measures value within the dimension against ALL
I can use the measures like a dimension and use a a topCount, which gives me the nested rows and the value, but I cannot for the life of me figure out how to get any details about the measure which appears in the nested row.
~Bloopaman
Hi there
Here are a couple of docs that might provide some ideas
http://www.ibm.com/developerworks/data/library/cognos/page364.html
http://www.ibm.com/developerworks/data/library/cognos/page173.html
Assuming OLAP
http://www.ibm.com/developerworks/data/library/cognos/page128.html
Hope this helps
Cheers
Peter B