Print Page - Urgent Help : Rank On Nexted Rows OLAP Source

Title: Urgent Help : Rank On Nexted Rows OLAP Source
Post by: Cognos KW on 09 May 2012 08:59:36 PM

Hi Gurus,

I am uusing cube as the source for creating report studio report. I have a requirement in which I need to show rank for the nested rows

P_Group | Product | Amount Rank
___________________________________________
Product A | Product AA | 20 1
| Product AB | 10 2
Product B | Product BA | 45 1
| Product BB | 35 2
| Product BC | 25 3

I have tried rank function : rank (Amount within set P_Group) which shows blank and also tried rank (amount within set Product) which shows rank for all the products in a sequence without taking in considration P_Group. Can some one please guide me the right approch to this.

Urgent help needed.

Thanks in advance.

Title: Re: Urgent Help : Rank On Nexted Rows OLAP Source
Post by: HalfBloodPrince on 09 May 2012 11:46:51 PM

Not Sure abt wil this work in cube But give a try and let me know.

Group P_Group
Sort amount Descending
Create calculation Rank as running-count (1 for [P_Group] )

Title: Re: Urgent Help : Rank On Nexted Rows OLAP Source
Post by: Cognos KW on 12 May 2012 04:40:28 AM

Thanks for the report.

Its not working.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Cognos KW on 09 May 2012 08:59:36 PM