Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
how can i find ordinal position of a member in some attribute

Answered how can i find ordinal position of a member in some attribute

  • Tuesday, January 01, 2013 11:46 AM
     
     
    Sign In to Vote
    0

    Hi

    Say i have a month attribute containing members of 10 years (that is total of 120 months)

    Is there some mdx function i can call to get the ordinal position of every month (that is some value between 1-120)?

    Thanks alot!

     

All Replies

  • Tuesday, January 01, 2013 2:53 PM
     
     Answered
    Sign In to Vote
    1

    Hi reapeleg ,

    Because your month Att have the same level in the hierarchy, you need to use the rank function .

    With set MyMonths as {[Dim Date].[Months].members}

     member a as MyMonths, Rank([Dim Date].[Months].currentmember, MyMonths)

    Select MyMonths on 1, a on 0 From [MyCube]

    Hope it helps :)

    Regards, David .

    • Marked As Answer by reapeleg Tuesday, January 01, 2013 3:09 PM
    •  
     
  • Tuesday, January 01, 2013 3:11 PM
     
     
    Sign In to Vote
    0

    It sure does!

    But isn't there a MDX function which returns this rank(index)??

    Thats odd...

    Thanks again!

    Rea

     
  • Tuesday, January 01, 2013 3:19 PM
     
     
    Sign In to Vote
    0

    Happy to help .. :)

    kind of... the Rank need the value and the set wich by gives him his index .

    Regards, David .