How to get the nber of POs at the item level?

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi - thanks for your reply. It works perfectly.

Points awarded.

Could you explain me the "behind the scene" reason why it works. I have difficulty to figure out.

Thank in advance.

chris

[Former Member]

Hi

Check whether counter infoobject Number of items is availbale in MCEKPO ,if so just drag into left side and do this enhancement for 2LIS_02_ITM.

Create a number of item field in the cube and update with value 1 referring the Item number

In query it may reduce query runtime performance

This will just update 1 for every instance of item and you can aggregate them in your query whatever level you require

Regards

N Ganesh