How to setup aggregation of a keyfigure in Bex Query for specific characteristics only

[Former Member]

How do I stop aggregation of keyfigures when the detail characteristic is removed from the query?

For e.g.

I have data as below:

-Project Project Invoice Number Bill No Proj Inv Amt

  P1      P1INV1                          B1      100

  P1      P1INV1                          B2      100

  P1      P1INV2                          B1      200

  P1      P1INV2                          B2      200

One invoice can have many bills associated to it. In the above case, if the user does not want to view the Bill No then the current output received from the Bex Query is :

Project Project Invoice Number Inv Amt

  P1      P1INV1                          200

  P1      P1INV2                          400

It should however show the values as 100 and 200 for the Invoices. I am able to achieve this in a Web Intelligence report on the query but using that is not an option.

Any ideas on how this can be achieved?

-Ashish K.

[former_member241863]

Hello Ashish Kothare,

Use Exception Aggregation in Bex Query,

Step 1 : Create New Formula and in Detail View add "Proj Inv Amt".

Step 2: Go to Aggregation Tab of Formula, In Exception Aggregation - select summation and in Ref Characteristics - Select "Bill No" and save it.

Hope this will resolve your issue.

Thanks

Pratyaksh Jeet