Skip to Content
0
Jan 10, 2011 at 02:32 PM

Filter for one hierarchy and expanding for another one?

30 Views

Hi to all,

We've a dimension A with 2 different hierarchies (call them as usual PARENTH1 and PARENTH2).

What I've been asked by the users is a little interface, where they can:

- filter for one parent of the first hierarchy

- expand for the parents of the second hierarchy, who share the same base members.

Initially I had hoped that imposing the value desired of the parenth1 in the PageKeyRange, and expanding with a filter like HIR="H2" and HLEVEL="2" would work, but it doesn't work (I get ALL the parents at level 2 of the second hierarchy, not the parents who shares the same basemembers).

Is it possible to model this with an evDRE? If so how? Unfortunately, I cannot make a single hierarchy 😔 (this parents aren't in a 1-N relationship between them, unfortunately).

Thank you

Daniele