Skip to Content
0
Former Member
Jul 01, 2016 at 08:07 AM

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

24 Views

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.