If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos rank olap

Started by cognos05, 30 Aug 2020 03:37:29 PM

Previous topic - Next topic

cognos05

Hi ,

I got thsi syntax froma prior post .

rank( [Qty] DESC tuple [2020] within set  [Territory])

this ranks my teritories on rows for 2020 by qty

say if i want to rank on multiple dimensions , I was not able to add some additional elements to tuple

like


rank( [Qty] DESC tuple( [2020] ,[Product1]) within set  [Territory])

cant we add more members to tuple for the purpose , how would you handles this .

Thanks,