Is possible to use member expansion in a combined POV?

[Jacky_C]

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.

[aformenti · Accepted solution]

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?