Have a hierachical dimension with lets say 2 levels - this diemnsion has
children with the same names under each level and when standing on level 2
on a member I need to fetch something from the previous member on the same
member.

How do I do that...?

Hope it's understandable.

A more detailed example would make it clearer but, if every member at
level 1 has the same oredered set of children names, then maybe
ParallelPeriod will work:

1, [MyDim].CurrentMember)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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