Print Page - rank in dimensional reporting

Title: rank in dimensional reporting
Post by: cognos05 on 07 Jan 2020 08:28:51 AM

Hi guys,

I have a question related to using rank against a cube and i got the below code from other post .

rank(currentMeasure DESC tuple [Canada] WITHIN SET [ProductID])

Here instead of a single member [Cananda] , i have to use more than one country , say like [Singapore],[Canada],[US]

how the above expression can be replaced.

Thanks,

Title: Re: rank in dimensional reporting
Post by: Francis aka khayman on 07 Jan 2020 01:35:24 PM

this is just a shot in the dark. haven't done dimensional in a while. here goes nothing...

[rich ones] = set ([Singapore],[Canada],[US])

rank(currentMeasure DESC tuple [rich ones] WITHIN SET [ProductID])

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos05 on 07 Jan 2020 08:28:51 AM