Expanding column header error with JOIN MDX

[Wei Wang]

We use the “join” MDX in different places to do “asymmetric” selection of stacked dimensions. However, when we try to expand the stacked column header (when its C-level element with children elements), Apliqo returns an MDX error. Creating a similar view without using the “join” MDX on stacked dimension yields no error but it limits the flexibility in selecting combinations of elements between the stacked dimensions.

For example, I’ve replicated the issue in Apliqo_Demo:

join MDX is stored on “Version” dimension

“Period” dimension is blank in the MDX field

‌

View creates fine initially

‌

After trying to expand the “Year” element in the “Period” dimension, we experience the error, where there is an issue in generating the “Drilldownmember” expression

‌

[Scott Wiltshire]

Asymetric expand/collapse isn’t currently supported.

If you are setting columns or rows by MDX using cross-joins or explicit tuples by entering the MDX on the outer most stacked hierarchy while leaving MDX empty for the remaining hierarchies then you should disable drill down/up

[Ada Trajer]

Ticket closed as this option is not currently supported