Do a Top 10 after drill-down?

[karthik.kadambi]

Hello All,

I have a scenario where I'm doing a very straightforward method of doing a Top 10 of a crosstab member row using order() and subset(). But when I do a drill-down it loses the Top 10 functionality and brings back all members belonging to the level beneath.

Here's how I tried to solve -

In the Drill Behavior property window, I've tried the 'Replace Expression' option which takes the currentMember of the item that I'm trying to drill down and do a Top 10 using MDX. It sorta works when I have selected individual level members in the Tree Prompt selection.

I'm having a problem when I do a Product(All) selection in the Tree Prompt. Even though I'm bringing the descendants of the All level on to the Report, a drill-down on individual members gives a currentMember as the All level and not the actual member that's being drill-down. The All level is important to have as it's easier for the Business to select.
I can remove the All level in Tree Prompt, but a feature that doesn't exist within Tree Prompt is the 'Select All' link, which would have helped my case.

[skeith99]

Have you tried using the TopRank function?

[skeith99]

Karthik,   I found an example in the Cognos Tips and Techniques section.

http://www.ibm.com/developerworks/data/library/cognos/page104.html

The trick is to use Named Sets and setting the drill down behavior correctly.  I was able to create the report functionality using the example in the link.

Let me know how it goes.

Scott