How to get two different dimension members in columns changing alternatively based on two parameters

STDN1610
New Contributor

Hi Team,

 

I am building a cube view with account in rows. In columns i need entity and UD2 dimension members but the columns  names should change as entity members and UD2 members based on choosing the parameters. I have tried  Primary dimension type as entity  and nested member expansion primary dimension type as UD2 but i am unable to achieve my requirement, can anyone please suggest .

 

Let me know if any questions.

 

Thanks in Advance.

1 REPLY 1

db_pdx
Contributor III

Hi STDN1610: what you've listed sounds correct "...primary dimension type as entity and nested member expansion... as UD2"

Can you share what your member expansion currently looks like?  Else, a generic parameter example would be:

E#|!YourEntityParameter!|

-db