Forum Discussion

ScottCharles's avatar
ScottCharles
New Contributor II
2 months ago

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 a...
Excel Add In
  • db_pdx's avatar
    db_pdx
    2 months ago

    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#IndirectElim

    The 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

db_pdx's avatar
db_pdx
Valued Contributor
2 months ago

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#IndirectElim

The 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