on 11-26-2007 1:55 PM
Hi all,
I am running BI 7 and SRM 5.5. I am using the standard PO History cube.
I have a report where I filter on items values only (no header) since I want to report by - let's say - product category.
In my char part, I will have: Date | product category
In the KF part, I have: Ordered Amount | Nber of POs
In the flow, PO amount is stored at the item level while the nber of POs is stored at the header level. By running the report, I get the ordered amount information but 0 for the nber of POs.
How could I get the "Nber of POs" information in my case? Maybe it is not that easy (looking the following example).
PO1 - Item 10 - Product Category A
PO1 - Item 20 - Product Category B
PO1 - Item 30 - Product Category C
PO2 - Item 10 - Product Category D
PO2 - Item 20 - Product Category A
PO2 - Item 30 - Product Category A
Here I would be happy to have:
Date | Product Category A | Amount | 2 (PO1-PC A + PO2-PC A)
(but how BI knows that we are dealing with 2 POs?)
Thanks in advance - chris
Hi Chris.
You can do this by adding a formula that just contains 1 as a counter. Then go to the aggregations tab for the formula and choose exception aggregation = total and ref. char. = PO.
Hope it helps (assign points if helpfull!).
BR
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.