Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 02:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 02:06 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.