Problem In creating link between info source to DSO(Urgent)

[Former Member]

Dear Experts,

I am facing an problem in creating an link between info source and DSO.My problem is: I am actually loading data from R/3 into two data sources 2lis_01_s951 and 2lis_01_s952 there is a need for me to calcualte revenue % i.e diving revenue by qty from different data sources so i created one Info Source for 2 data sources,So i am facing a problem in creating an link from Info Source to DSO.Is there any other way to solve this problem.

Points will be awarded.

Regards,

Shivu.

[Former Member · Accepted solution]

Shivu,

I’m suggesting either of the following 2 solutions. Both of them require some abap programming.

A. Permanently store calculation result in DSO :

A1) You’ll need to decide which of the 2 DSOs you want to store the result of the % calculation, then add a new infoobject for that purpose;

A2) Load ALL the data into the DSO that will NOT store the result of the % calculation; let’s call this DSO “DSO1”. The data records in this DSO will be retrieved later on when loading the other DSO;

A3) For the DSO that will store the result of the % calculation (let’s call this DSO “DSO2”), create a transformation rule (i.e. update rule) that will SELECT the related data record from DSO1 and carry out the calculation before storing the data record in DSO2 ( this can also be done in the Start Routine to loop through all the data records of a packet.)

B. Carry out the calculation at query time :

B1) Create a multiprovider (i.e. multicube or infoset) to combine your infocubes or DSOs together. Keep in mind that a multicube works as a union of the infoproviders, while an Infoset works as a join of the infoproviders.

B2) Create a formula in your query to calculate the %.

Hope this helps.

[Former Member · Accepted solution]

Thanks a lot Nancy.Points awarded.