On my current project we are trying to run a query based on an nav. attribute of an attribute. The reason for this is due to the master data relationships changing, which doesn't allow us to use both specific dimensions in a cube.
Our current business process allows the reassignment of a contract object to a different business partner. Data is loaded into a cube that contains both business partner and contract object as dimensions. The problem lies when the relationship of CO to BP is changed. The master data will be updated with the new change, however when reporting off the data in the cube, the integrity of the data will be compromised. Is there a way to remodel this or to execute some type of realignment of the attributes to be able to accomodate the master data relationship change?
Thanks in advance!