Skip to Content
avatar image
Former Member

Sum calculations in Bex

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 17, 2016 at 03:40 PM

    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
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 01:59 AM

    Hi,

    Can you post a sample query output?

    Thank you.

    Loed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2016 at 05:54 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 07:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded