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

Error while creating multiple alternate hierarchies in ASO Cube

Summary:

We are getting error "Shared members or their shared ancestors can only appear once in a stored hierarchy. Remove duplication or use multiple hierarchy."

while creating an ASO cube on top of BSO cube which has multiple alternate hierarchies in Account Dimension.

In a Free form application initially started as BSO cube, Account dimension has on base Chart of Accounts and multiple Alternate hierarchies to depict different accounting trees. All alternate hierarchies are shared members from the CoA tree. Now we are trying to add an ASO cube on top of this, but when refreshing database we are getting the error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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