I want to find the top level member two members before the parent of the
member parent. Is this possible.

Eg. Top level had 3 parents D, E and F
Member K is a child of member F and is on level 5.
I want to get the member D which I know is on the same level of member F
but two members back from the parent F.

Any assistance will be greatfully accepted.

use the Ancestor function

Ancestor(dimension.currentmember, <target level>)

Ancestor(dimension.currentmember, 0) return the parent member at the first
level of the dimension.


"henry" <henry (AT) spamnot (DOT) com> a écrit dans le message de news:
%23Z0E7363EHA.2540 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Jeje's suggestion will return you member F. The following will return you
member 'D'
Ancestor(<K>, 0).lag(2)

cheers
Jamie
http://blogs.conchango.com/jamiethomson

"Jéjé" wrote:

well...
returning a particular member don't need this type of function
maybe I dont understand clearly what is requiered

if you need allways the member "D" then use its uniquename
dimension.[Member D]

if you need a sibling member of your parent member, then the formula
describe by Jamie is good.


"Jamie Thomson" <jamie.thomson (AT) donotspam (DOT) conchango.com> a écrit dans le
message de news: DD4C71B8-2E07-4597-9C80-ED87625A517B...soft (DOT) com...

Good point. Perhaps its a time hierachy and Henry is interested in comparing
to 2 year's ago or something.

I agree though...it does seem to be a strange requirement!

cheers
Jamie
http://blogs.conchango.com/jamiethomson

"Jéjé" wrote: