A real example ...

[Former Member]

Hi all-

Can some givel me few real time examples (Just a discription will be enough) for following:

1. Start routine for transfer/update rules.

2. Writing a routine for a transfer/update rule.

Thanks-

[RenjithKumar]

Hi

A basic example for learning purpose .

Learn using simple flat file extarction

<b>Transfer Routine</b>

Just Create Some char , Say 11 info objects as Key figures ( F1..F11) , for 10 Key Fig you load data from Flat file .F11 you have to add 10 KF . Create info Cube with Char ,Key fig ( F1..F11)

The 11 th key fig in Transfer rule you create Routine Now if you want 11 th field to have sum of all 10 fields .Select all 11 fields other wise u get error in routine .

if you filed name is in this order F1 .... F10 .. F11

In the routine write this code

<b>RESULT = TRAN_STRUCTURE-/BIC/F1 + TRAN_STRUCTURE- /BIC/F2 + .... + TRAN_STRUCTURE-/BIC/F10 .</b>

Now create update rule , Schedule and see , You cube will F11 will have sum of f1..f10.

[former_member197610]

Over here we write our routines in the start routines in the update rules or in the transfer structure (you can choose between writing them in the start routines or directly behind the different characteristics. In the transfer structure you just click on the yellow triangle behind a characteristic and choose "routine". In the update rules you can choose "start routine" or click on the triangle with the green square behind an individual characteristic. Usually we only use start routine when it does not concern one single characteristic (for example when you have to read the same table for 4 characteristics).

To convert to Uppercase (transfer structure)

To convert Values out of a third party tool with different keys into the same keys as our SAP System uses (transfer structure)

To select only a part of the data for from an infosource updating the InfoCube (Start Routine) etc

[Former Member]

Hi Suresh-

Thanks for your response, BUT I am looking for a real example. I am ok with the definition and is implementation. I just want to practice it, so can you give me an example for start routine and routine for transfer/update rule. (Like, on any data source and any field)

Can some one give me a real implementation example-

thanks-