You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!