Print Page - Dimensional Model: Top 10 + Others in Cognos 10.1

Title: Dimensional Model: Top 10 + Others in Cognos 10.1
Post by: sujitgouda on 18 Jun 2014 10:50:44 AM

Guru's,

I have a relational package; I have to find Top 10 Firms + Others and show them in a list.
It works fine for with a single measure, is it possible for the others to get calculated against all measure and display the same in a single row in list.

Right now I am getting same values for all the rows,

Firm Name   Daily   MTD   YTD
Firm1     10   20   30
Firm2     10   20   30
Firm3     10   20   30
Others     70   70   70
Total     XXXX   XXX   XXXX

I need something like this

Firm Name   Daily   MTD   YTD
Firm1     10   20   30
Firm2     10   20   30
Firm3     10   20   30
Others     70   40   10
Total     XXX   XXX   XXX

Thanks.
Sujit

Title: Re: Dimensional Model: Top 10 + Others in Cognos 10.1
Post by: sujitgouda on 18 Jun 2014 08:37:06 PM

Finally got the solution for this.

Steps:

Top 10 Field: topCount ([Firm Name], 10, [Daily])

Other: aggregate(currentMeasure within set except([Firm Name], [Top 10 Firm]))

Firms to be displayed: union([Top 10 Field],[Other])

Title: Re: Dimensional Model: Top 10 + Others in Cognos 10.1
Post by: MDXpressor on 20 Jun 2014 05:15:33 PM

brilliant and elegant. way2go neb2cog! wouldn't have done it any other way myself.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sujitgouda on 18 Jun 2014 10:50:44 AM