Skip to Content
author's profile photo
Former Member

Aggregation

Hello,

I need to do the following thing on query level

Calculate on material level like

(Key figure1/key figure2) * key figure 3

and show on material group level the sum of materials , no the (sum Key figure1/sum key figure2) * sum key figure 3

I MUST DO IT ON BEX LEVEL NOT ON CUBE LEVEL

THANKS

PLEASE DONT OFFER THE "BEFORE AGGREGATION". AT FIRST , I DONT SEE IN IN BW 3.1. SECOND , THIS BULLSHETIMG FUNCTIONALITY NEVER WORKED!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 07, 2005 at 03:38 AM

    Hi,

    I hope, the Formula Collision property will help you. For further information take alook on the help.

    http://help.sap.com/saphelp_bw32/helpdata/en/d2/02223c5f00612be10000000a11402f/frameset.htm

    With rgds,

    Anil Kumar Sharma .P

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 07, 2005 at 09:09 AM

    Hi,

    I would suggest you try out variable with replacementpath

    http://help.sap.com/saphelp_nw04/helpdata/en/ca/5f9ac61a205a459d0e7ef313d10321/frameset.htm

    Heike

    Add comment
    10|10000 characters needed characters exceeded