cancel
Showing results for 
Search instead for 
Did you mean: 

% Rebate Calculations

Former Member
0 Kudos

We have a key figure which is defined as "Number: DEC - Counter or Amount field with comma and sign" in RSA1. Aggregation is set as Sum and exception aggregation is set as summation as well. We use this key figure to store % of rebate for each transactional record in the cube. The report has profit center hierarchy and this key figure is showing up cumulative in the results display, which is erraneous.

For e.g., A country has 3 regions and each region has 3 profit centers. So P1 to P3 belong to Region 1 etc.. The trasactional data is

Profit Center***Sales***Rebate

P1***100***9%

P1***25***3%

P1***2000***9%

P2***150***4%

P5***78***2%

P6***200***6%

In the report we see

Profit Center***Sales**Rebate***NetSales

Country***2553**33%***1710.51

Region1***2275**25%***1706.25

P1***2125**21%***1678.75

P2***150**4%***144

Region2***278**8%***255.76

P5***78**2%***76.44

P6***200**6%***188

Obviously the above results are wrong. Do I have to do the "net sales" calculations in the cube level itself?? Is there any other way? Instead of summation I could use "average" in the exception aggregation, but the average rebate is not accurate either. How do we change the settings of the rebate key figure so that we get accurate results at each level of the hierarchy? The settings should enable me to calculate net sales record by record and then cumulate. I couldn't access the metadata repository as it was disabled in our system to look up any existing % rebate key figures. Can somebody please give some pointers in this regard? I really appreciate your help.

Sameer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You should calculate your net sales in the update rule to avoid wrong results, because a relative key figure (%) can't be calculated by sum and even an average aggregation will return wrong values.

Ashwin
Active Contributor
0 Kudos

Hi!

i am not quite clear about the sitation..can you inform for which key figure did you make the agregation settings. I think it should not be made for the rebate percentage. and you have to change the agregation settings for the calculate keyfigure netsales.

with regards

ashwin