Display Dimension Properties along with Dimension

AvnishGoel
AvnishGoel
in Modeling

I am intending to display the properties of the dimension in a grid along with the dimension. If I add properties as line item then each line item is repeated across all the dimension elements, as the properties are tied to dimension members and they should not be repeating across dimensions. Below is the screen shot.. In this example my line item should be only amount and somehow I should be in position to display the dimension properties along with dimension. Happy to be on call as well. Need assistance.

Dimension (X)Dimension(X) Property 1Dimension (X) Proprtery 2 JanFeb Mar
10050111001CC_10050Amount_USDAmount100,000100,000100,000
10100111002CC_10100Amount_USDAmount000
10050112006CC_10050Amount_USDAmount500500500
10050211001CC_10050Amount_USDAmount200,000200,000200,000
Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @AvnishGoel 

     

    Please don't use properties as I don't believe they work the way you think it should work meaning they will automatically be rendered in a module because they are a property.  It is best to store them in a SYS module so you aren't double counting them from a cell perspective (properties add to cell count as well).  

     

    In your example, you should have a list which is Dimension X then create two modules:

    • the first one will be transactional module which is dimensionalized by Dimension X and Time with the only line item being Amount.  This is where you will load your transactional data
    • the second module will be a SYS module which is only dimensionalized by Dimension X, no time.  In here, you can have two line items, list formatted.  The first being CC and the other Currency.

    From a reporting perspective, create a 3rd module which is dimensionalized by CC, Currency, and Time with a line item named Amount.  The formula for Amount will be: Name of Trans module.Amount[SUM:SYS Module.Cost Center Line item, SUM: SYS Module.Currency line item].  Then you can pivot the module the way you would like.

     

    Hope this helps,

     

    Rob

Answers

  • AvnishGoel
    AvnishGoel
    @rob_marshall
    Appreciate your quick reply. Your solution works. I really wish there is some way to use properties. We are un-necessary creating additional dimensions where there is no need.

Categories