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