Skip to Content
0
Former Member
Mar 10, 2009 at 11:02 AM

Problem while executing planning function

11 Views

Hi All,

I have created an input ready query which takes input for a key figure growth percentage and applies it to another key figure volume to get the new volume. For this calculation I have written a FOX formula:

Initially all the records have growth per as zero. When I enter the value for one DU and transfer it, it is calculating the new volume, but if I enter the per for a new record, it is calculating for this record and also recalculating the volume based on already entered growth percentage for the previous DU. PFB the example:

Scenario 1:

User enters the value for the first time

Season Brand DU Growth percentage Volume New vol

SS09 ADIDAS TENNIS 10% 100 110

SS09 ADIDAS KIDS 0% 500 500

Now he clicks the u2018TRANSFERu2019 button to which the planning function is assigned for performing the calculation. The volume changes to u2018110u2019.

Scenario 2:

User enters the value for next DU.

Season Brand DU Growth percentage Volume New vol

SS09 ADIDAS TENNIS 10% 100 121

SS09 ADIDAS KIDS 10% 500 550

So how can i avoid this problem of recalculating. Also if this data is saved ino the cube and the report is executed for the next time and if it picks up the growth percentages and recalculates again, it will be wrong planning.

Request your inputs as how to solve/avoid this problem.