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

dimension import and ordering of members causing cube refresh error

Summary:


Content (please ensure you mask any confidential information):

In my application I have two entity hierarchies which are ordered as follows

ENTITY:

  • Main hierarchy (stored members)
  • Shared hierarchy (shared members from main hierarchy)

The main hierarchy appears before the shared one.

When I import the dimension members from EDMCS, the ordering shifts on import and the shared hierarchy moves into a position above the main hierarchy as follows

ENTITY:

  • Shared hierarchy (shared members from main hierarchy)
  • Main hierarchy (stored members)

This results in a cube refresh error which states that shared members cannot appear before base members. I have to then manually move the shared node back to a position after the main hierarchy node and then refresh the cube to fix the error.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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