Quickviews and the Consolidation dimension
Is there a way to drill through the entity hierarchy in a Quickview that shows the total of Top in the Consolidation dimension? I have users asking me if this is possible.
In the example above 87M is the total amount of the child entities including eliminations showing in the second Quickview but no total. The first Quickview is at local before eliminations therefore doesn't addup to the total of 87M. I've tried to use CAD but get the same numbers as local.
Hi Scott: I'm a big fan of the Origin (O#) dimension for analyzing anything related to eliminations. Here is a member filter you might try adding to your columns to see if it satisfies your user's request:
O#BeforeElim, O#Elimination, O#Top,
O#DirectElim, O#IndirectElimThe other option if they want to follow the consolidation logic is putting all the Consolidation (C#) members into the column and then use an E#Entity.Tree on the row:
C#Local, C#Translated, C#OwnerPreAdj, C#Share, C#Elimination, C#OwnerPostAdj, C#Top
Cheers, -db
edit: typo, and additional option
