Skip to Content
author's profile photo Former Member
Former Member

Key Figure Aggregation for SAP BW Universe

I am working on creating a QAAWS on top of a universe which is built on a BW query. I am having problems with aggregation on the QAAWS side. It is my understanding that webi and deski aggregate the data on the client side, and that is why my webi reports tie back to my original BW query. However, it is also my understanding that QAAWS does not perform aggregation and thus why my QAAWS values are not matching my original BW query.

Therefore, I would like someone's recommendation on how to proceed. My best guess is that I need to write some sort of SUM or AGGREGATE statement in my universe key figures to force them to aggregate on the universe side. However, when I attempt this I get MDX errors. If someone could please recommend how to proceed to get the proper aggregated values in QAAWS, I will be very happy. If it does include MDX, please post the correct MDX syntax to use.

Thank you in advance!

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    Posted on Aug 17, 2010 at 11:22 PM

    Hi,

    the aggregation should happen on the backend. if it is a standard summary you can leave it as a SUM in the Universe. in case you are using an exception aggregation then you configure the keyfigure in the universe as a database delegated keyfigure.

    ingo

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 09, 2010 at 06:43 PM

    Do I have this question posted in the wrong area? Anyone?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Try to set the aggregation type for your key figures in your universe to "Delegate to database". This way the aggregationb will take place in SAP BW and the aggregated results will be delivered directly to BOBJ.

      Regards,

      Stratos

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2010 at 06:29 PM

    Hi Allison,

    It would be better to make this Sum in the BW query and then import to BO.

    Check if this works.

    Regards,

    Santosh

    Add comment
    10|10000 characters needed characters exceeded