start routine example

[Former Member]

hi experts ,

i am loading data from one cube1 to another cube2  and created the transormation.

cube 1                                                    cube2

dim:id                                                 dim:id

keyfig:salary,hike                                keyfig:salary,hike,result.

i have created the transormation between these

my requirement is i need to load the data which is the sum of salary and hike from cube1 to     result (keyfig) in cube2 by the start routine mechanism and end routine mechanism,please tell me how to achieve this  including the code seperately for start and end routine.

thanks in advance.

[vinay_lohakare5]

Hi,

Add the new Keyfigure which will store the sum in the target Cube.

In the transformation map the KF Salary and Hike to the newly created KF.

Use the addition function to add the KF, no need of any routine.

Thanks,

Vinay

[Former Member]

hi vinay,my requirement is to execute it with start routine or end routine

[Former Member]

hi vinay,my requirement is to execute it with start routine or end routine

[vinay_lohakare5]

Hi,

Add the new Keyfigure which will store the sum in the target Cube.

In the transformation map the KF Salary and Hike to the newly created KF.

Select the routin.

Routine:

Result = Salary + Hike.

Thanks,

Vinay

[Former Member]

ya thanks vinay,what you told was in field routine,i want to execute it through start routine