Sum calculations in Bex

[sameer_mehta]

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.

[BernhardE]

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

[sameer_mehta]

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.

[Loed]

Hi,

Can you post a sample query output?

Thank you.

Loed

[BernhardE]

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