Re: MDX - Rank function

#1

Here's a sample Adventure Works query to try:

Quote:

With Member [Measures].[SiblingRank] as

Rank(StrToSet("Axis(1)").Item(0).Item(0).Dimension .CurrentMember,
Intersect(StrToSet("Axis(1)").Item(0).Item(0).Dime nsion.CurrentMember.Si
blings,
StrToSet("Axis(1)")))

select {[Measures].[Order Quantity], [Measures].[SiblingRank]} on 0,
DrillDownLevel([Geography].[Geography].[Country].Members) on 1
from [Adventure Works]

Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: MDX - Rank function

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: MDX - Rank function - 02-16-2006 , 09:34 PM