Skip to main content
J
Jacky_C
June 14, 2024
Solved

Is possible to use member expansion in a combined POV?

  • June 14, 2024
  • 1 reply
  • 0 views

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.

Jacky_C_0-1718364353541.png

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.

Best answer by aformenti

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? 

1 reply

A
aformentiAnswer
June 14, 2024

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? 

Terms & ConditionsAccessibility statement