Skip to Content
avatar image
Former Member

BEx report on DSO: do not aggregate values

Experts,

how to set DSO (or BEx query) to not aggregate on BEx report values for one field? I do not want to drag to the report all fields to differentiate records (in my case I need about 6 fields to see the difference between records). I would like to have report with only two characteristics: WBS Element, ZTYPPL.

Thank you in advance for any help.

DSO.jpg (41.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Dec 31, 2014 at 04:15 AM

    Hi Mateusz,

    As others have stated, this is standard behaviour. You can work around this by adding to the rows all the key fields of the DSO. If you don't want them to be shown to the user, you can hide them.

    Regards,

    Suhas

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 11:21 AM

    Hi

    As I understand this is inherent property of OLAP which will sum the key figure values relating characteristics (identical keys) available in query rows.

    I believe you have to use a column in query which distinguish the records to avoid summation of key figures.

    Ashish

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 11:23 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2014 at 06:38 AM

    Hi Mateusz,

    What is the character that is the differentiation of the record...which shud give you value 1.

    WBS Element, ZTYPPL have similar values.....the third Char which differentiates...Add in the Rows and Hide it to show the Values of it.


    regards


    SVU

    Add comment
    10|10000 characters needed characters exceeded