Question:
Hi All
I have cube for goods rests (in qnty and money). Rests are splited to rows in accordance to SAP stores.
Real numeral rest for good is stored in row for store = 1.
Cost rest for good is calculated as:
(numeral rest for store = 1) * SUM(cost rest for all stores) / SUM(numeral rest for all stores).
I'v tried to do this in BEx by RKF(numeral rest) and CKF(cost rest) with calculation totals as sum. It works well only if goods is unwrap in query. In other case total for cost rest is wrong.
We are using BW 3.0B.
How to do it right Thanks in advance..
Answer:
Depending where you created you CKF/RKF (global : created on the left part of the query designer, within the provider itself, local : created inside the query itself), you can change the sum calculation (before or after aggregation).
Right click on the figures, choose Properties, and at the bottom of the window, you'll get 'Enhance'. There, try to modify the calculation.
It seems weird, but for other purposes, I did, and it worked fine !
Tell us ...
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
Thank for response, lthibert
I made it global. For example, I use 2 KF: QNTY and SUM and 1 CH STORE. Numeral rest I define as RKF on QNTY, resticted on STORE=1.
Cost rest i define as CKF by formula "Numeral rest"*SUM/QNTY. In this case I have only 1 type of aggregation - after. From 1'st side it is true, because I must divide sum by sum, but from 2'nd side it is wrong, because I must sum up only for current good. I can't limit level of aggregation for this CKF.
How to do it another way?