cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregation

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I would suggest you try out variable with replacementpath

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

Heike

Former Member
0 Kudos

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