Skip to Content
avatar image
Former Member

Sub Total of UOM used

Hi Gurus,

We have a Report req where we need the report layout as below:

Cost Element Value in reporting Currency Qty Unit of measure Vendor Doc no Date

Our first Issue is how to achieve this sequence of fieldsin BI as it has key figs(like quantity) in between and then again characteristics(like Unit of measure).

secondly in our data we have different 'unit of measure' for one cost center and thus we need sumary of number of each 'unit of measure' for one particular Cost center and then consolidated sumary for all the cost center.

Could anyone guide me to achieve this req

Thanks

Edited by: Deepika Jain on Oct 15, 2008 3:25 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 16, 2008 at 09:32 AM

    To point out the obvious, UOM is usually an attribute of the key figure (and so it is not possible to change the order of the columns to add it to the master data attributes of cost centre).

    However, it sounds as though your data is such that UOM is also an attribute of cost centre directly (in business terms). If that is so, you need to add UOM as an attribute of cost centre, and make sure the data is loaded as such.

    THEN, UOM can be reported as an attribute of cost centre, with sub-totalling.

    Points?

    Patrick

    Add comment
    10|10000 characters needed characters exceeded

    • Well, for that cost centre you will have a sub-total for each UOM, with an overall sub-total for that cost centre. If that doesnt look quite right, check out switching one off and the other on til you got what you want! (its always difficult explaining just what you will get without actually doing it).

      Points?

      Patrick