How does invalid intersection work when use alternate hierarchy
Hello everyone,
I have more than 3 alternate hierarchies for the Account dimension.
Now my requirement is that I have to create an invalid intersection to prevent users from inputting for the alternate hierarchy 2.
I tried to create an invalid intersection and choose IDescendants(M_NET_SALES).
But when I used the ad hoc, I saw that :
I know the problem might be the second 4xxxx is [M_NET_SALES].4xxxx.
My question is: how can I use an invalid intersection for all base and shared members that I choose?
I searched the community and tried some ways, but it did not work properly.
Tagged:
0