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.
Tagged:
0