Skip to Content
0

Sum calculations in Bex

Nov 17, 2016 at 01:39 PM

67

avatar image
Former Member

We have a scenario in which we need to sum up the sales quantity for a particular material, date then to use this sum in all sales order line items:

for example: Material: ABC; Date: 01.11.2016

Sales Order Material Qty Sum(Qty) on 01.11.2016

1001 ABC 10 30

1002 ABC 10 30

1003 ABC 10 30

My question here would be how we can calculate the sum of quantity for material, date combination and to display the same at each line item

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Bernhard Eigelsreiter
Nov 17, 2016 at 03:40 PM
0

Hi ,

You should be able to do so using the constant selection feature (define constant selection over Sales Order in the corresponding keyfigure).

You may check the following KBA that provided such an example:

1951436 - How to use feature 'Constant Selection' instead of functions such as SUMCT or %CT


BR Bernhard
Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Nov 18, 2016 at 01:59 AM
0

Hi,

Can you post a sample query output?

Thank you.

Loed

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 18, 2016 at 05:54 AM
0

Thanks Bernhard Eigelsreiter for your answer.

I actually want to avoid constant selection due to performance reasons. It would be good if we can achieve this in some other way or also if there any new ways in BW on HANA.

Share
10 |10000 characters needed characters left characters exceeded
Bernhard Eigelsreiter
Nov 18, 2016 at 07:34 AM
0

Hi Sameer,

The constant selection is evaluated in an seperate read request that usually only reads the aggregated data. So it is already optimized for HANA access. I am not sure for what new ways in BW on HANA you are looking for. By what rate is performance descreasing once you use the constant selection feature in your scenario?

BR Bernhard

Share
10 |10000 characters needed characters left characters exceeded