Re: Retrieving values from a cousin in the heirarchy
jim.little.2005_at_gmail.com
Date: 01/27/05
- Next message: Ohjoo Kwon: "Re: Retrieving values from a cousin in the heirarchy"
- Previous message: jim.little.2005_at_gmail.com: "Re: Retrieving values from a cousin in the heirarchy"
- In reply to: jim.little.2005_at_gmail.com: "Re: Retrieving values from a cousin in the heirarchy"
- Next in thread: Ohjoo Kwon: "Re: Retrieving values from a cousin in the heirarchy"
- Messages sorted by: [ date ] [ thread ]
Date: 26 Jan 2005 20:56:16 -0800
i got it finally after banging away at it. the problem was how do i
jump from the Site dimension (schools) to the measure dimension
(Current API). this brings me the value i am looking for:
max({Ancestor([DistrictSite].CurrentMember.Parent,
1).FirstChild.NextMember.NextMember.LastChild}, Measures.[Current API])
i use max() purely to get the measure, since there is only one value.
so i get to the node i want, then say "give me the max() of the
measure.[Current API]" and it will return 755.
thanks for the help. if you have any further comments, like any
improvements to my kludgy syntax, i am all ears.
- Next message: Ohjoo Kwon: "Re: Retrieving values from a cousin in the heirarchy"
- Previous message: jim.little.2005_at_gmail.com: "Re: Retrieving values from a cousin in the heirarchy"
- In reply to: jim.little.2005_at_gmail.com: "Re: Retrieving values from a cousin in the heirarchy"
- Next in thread: Ohjoo Kwon: "Re: Retrieving values from a cousin in the heirarchy"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|