Ranking Measures

[bloopaman]

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

[AussiePete2011]

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