Forum Discussion

Jacky_C's avatar
Jacky_C
New Contributor III
7 months ago

Is possible to use member expansion in a combined POV?

Hi all,

Is it possible to apply .base/.children to the non-primary dimension in a member filter? For example, the below screenshot, I tried to apply the below member filter (A#101:U2#100.base), but it only returns the first member from the UD2 dimension.

I understand that I could put the U2 dimension to the next expansion level, but just want to explore another way to combine the script into one expansion level.

Thank you.

Cube View
  • aformenti's avatar
    aformenti
    7 months ago

    HI Jacky_C ,

    You can only create expansions on the Primary Dimension Type, in your example above Account. 

    Another option is to use an XFBR rule, and pass the desired filters as parameters into a single member expansion. Then through code create the desired output. Does that make sense? 

  • aformenti's avatar
    aformenti
    Contributor II
    7 months ago

    HI Jacky_C ,

    You can only create expansions on the Primary Dimension Type, in your example above Account. 

    Another option is to use an XFBR rule, and pass the desired filters as parameters into a single member expansion. Then through code create the desired output. Does that make sense?