Skip to Content
avatar image
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

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    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

  • avatar image
    Former Member
    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

  • avatar image
    Former Member
    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