Need Suggestion to Apply Local Formula in BEx Query

[former_member730008]

Dear Experts,

Please suggest

Regards,

PJ

[Loed · Accepted solution]

Hi,

You need a NESTED exception aggregation with this one..Try to play with it..

Let's call the attention of , he's an expert with exception aggregation thing..

I still can't understand how NESTED exception aggregation works, but it does solve my problem by just playing with it..

Anyway, try this, create the formulas below:

KF_1 = QTY / COUNT with exception aggregation SUM reference characteristic is ORDER

KF_2 = insert KF_1 with exception aggregation SUM reference characteristic is CONFIRMATION

Regards,

Loed

[former_member730008 · Accepted solution]

@Nanda/ Loed , thank you for quick response. Expected result I can see on report .

@ Loed, small change in logic

1. KPI1 -  COUNT with exception aggregation SUM reference characteristic is Confirmation

2.  KPI2  -   Qty/ KPI1(Standard Aggregation)

3. KPI3 -   insert KF_1 with exception aggregation SUM reference characteristic is Order

Find the attached screenshot for reference

It would be good if some one can explains how its works at backend and also helps others .

Regards,

Praveen Jelli

[Loed · Accepted solution]

Hi,

Good that it solved your problem..

With your scenario, I can explain it since you only have 1 exception aggregation..

Since you have this data..

1. Count of Confirmation -  COUNT with exception aggregation SUM reference characteristic is Confirmation

2.  KPI1  -   Qty/ Count of Confirmation (Standard Aggregation)

3. KPI2 -   insert KPI1 with exception aggregation SUM reference characteristic is Order

What your KPI2 does was compute the values as if ORDER is the only CHAR object in layout..So you have something like this:

Afterwards, KPI2 just SUM the values based on the layout given in your query..

Hope you understand my explanation..

By the way, just a trivia, EXCEPTION AGGREGATION works like CALCULATION BEFORE AGGREGATION before in 3.x..

Regards,

Loed