Skip to Content
avatar image
Former Member

How to aggregate at Sap Bw Olap Universe

Hi Experts

Let me show u an Example of my table

Plant    Month    Qty

1002   Jan         10

1002   Feb          20

1002   Mar         30

I want to get aggregated qty on plant at universe  level like

plant        Qty

1002        60

I am trying to use aggregate function but i don't know how to use it ,Please help me on this issue. I want to show the aggregated value on plant ,can we write in Olap Universe using MDX functions .??😔

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 25, 2012 at 08:12 PM

    Check the document below. You can find everything you need about OLAP universes in this document. However, you should do all calculations and stuff in Bex instead of universe design.

    http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c8206203eb?QuickLink=index&overridelayout=true&46158014096884

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 19, 2012 at 05:42 AM

    Hi Experts

    Any Ideas....

    Add comment
    10|10000 characters needed characters exceeded