Query on MDX function in OLAP

[mikesatriaevo]

Hi SAS Expert,

I would like to create a calculated member in SAS OLAP to perform ranking. Following is the desired result as attached (MDX.jpg)

Mis Month	Category	Sales Amt	Ranking
Apr-13	Grocery	9999	1
Apr-13	Electronic	5000	2
May-13	Grocery	6213	2
May-13	Beverage	2012	3
May-13	Electronic	8782	1
Jun-13	Beverage	5000	1

I found a similar solution at http://social.msdn.microsoft.com/Forums/sqlserver/en-US/050a18f3-dac6-4e3a-bf00-d92319b88714/mdx-ran...

But it is using Microsoft platform and the syntax/ function is not available in SAS, i.e. nonempty function is not available

Can you please advise how to achieve this in SAS mdx?

Thank you.

Regards,

Mike

[RichardinOz]

Have you investigated Proc Rank?  It is designed to do this job for you.

Richard