MS SQL Server OLAP - mdx hierachy trouble

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

mdx hierachy trouble

michael v

2005-11-23, 7:24 am

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.

Deepak Puri

2005-11-23, 8:24 pm

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:
[color=darkred]
ParallelPeriod([MyDim].Parent.Level,
1, [MyDim]. CurrentMember)[color
=darkred]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Sponsored Links