Reporting BEX level Query

[Former Member]

Hello, I posted this in a different forum which is wrong. sorry. i can't see my question there any way. this is my question. I built a SD report which has both Header and item level information. Report is running fine. a new requirement came and they want to see how many sales orders were processed in a given period of time (Variable) as well as the number of line items were processed in a given period of time. how can i accomplish it at the reporting level?

thanks.

[former_member182470 · Accepted solution]

Just create a summary level report by keeping the Header Infoobject in Rows pane. Keep item infoobject in drill down. Hence you can accomplish both requirements at a same time.

[Former Member · Accepted solution]

but then how would i do the count?

[former_member182470 · Accepted solution]

You can keep Sales Order and Item in rows and keep Amount in columns. I think you are saying about Item count. You can create a new CKF and apply execption aggregation as Counter of all detailed Values which are not null or zero with ref char as Item no.

If your count is not appearing correctly then , apply nested exception aggregation for above created CKF and apply again execption aggregation on Sales Order withTOTAL

[Former Member · Accepted solution]

Suman, thanks but it is not working. what do you mean by nested exception aggregation?

[former_member182470 · Accepted solution]

Can you share sample data on how counts should appear?

[Former Member · Accepted solution]

It does not matter. i can place it in any formula.

[former_member182470 · Accepted solution]

If that is the case you must play with execption aggregations of Counters and apply again exception aggregation on a new CKF(which created above) with TOTAL. This is the concept of nested..Play with them until you get your desired result..

[anshu_lilhori]

You are saying that you need to get the no.of sales document in a given period of time.please clarify also give more details on layout and variable screen input.

Regards,

AL

[Former Member]

Thanks for your feedback. so this is a report:

Sales Order(Header) Sales Order (Item) Amount
A                                      1                  $100
A                                      2                  $10
A                                      3                  $20
B                                      1                  $50

here I have 2 sales order Header and 4 Line items. and this is what I should show on the report.

Thanks.

[anshu_lilhori]

Make a new formula--Put 1 inside it--Hit the aggregation tab--Exception aggregation as count of all values that are not equal to zero.--Reference characteristic as sales order.

To get the count of item--Make a new formula--Put the formula created in above step--Hit the aggregation tab--Exception aggregation as count of all values that are not equal to zero.--Reference characteristic as sales order item

This will give you unique count of sales order and item respectively.

Regards,

AL

[Former Member]

AL, I tried that but not working. It is placing '1' on every row for Header, which is right because Sales Order Header and Item number appears on every row.

[anshu_lilhori]

See with the current layout if you switch on the results then it should show 2 for sales order count and 4 for item.

If you remove sales item from drill down then also the result will remain same.

Reason you have 2 sales orders and against that 4 items.

In case you need something other than this then please share the layout.

Note:The approach i mentioned in my last reply to get the count of item --In that we have used the concept of Nested Exception aggregation only.

Aggregation over aggregation is called Nested Exception aggregation.

Regards,

AL