on 10-15-2008 2:10 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.