Hello,
I am creating a view of a cube in planning analytics. I have a dimension for columns and another for rows. These two dimension have for great part the same members. I want to syncronize the members: I you select to display certain columns, than I want only the rows to be displayed with the same members .
I tried creating a dinamic set using MDX , but this seems only to work when when the dimension is in context, and it does not work with the dimension as column:
FILTER(TM1SUBSETALL([rowdimension].[rowdimension]) , ([rowdimension].[rowdimension].CURRENTMEMBER.NAME = [columndimension].[columndimension].CURRENTMEMBER.NAME))
Is it posible to achieve this in Planning annalytics?
Thanks for any help
Paid Advertisement:
