Skip to Content
Former Member

# DSO-Design Query

Hello Experts,

Hello Experts,

Could you please help me with the design situation I am currently facing.

I have say, 4 (Calday,Comp code,Bus partner,Brand)characteristics 4 different key figures in different 4 source info providers.

Now, I have a requirement of to populate a DSO object which has some KF X, Y,Z which are to be calculated based on the A,B,C,D

Say X=A*B+c (On condition , For calday<1)

After calculating X, it has to be used in calculating Y (In Same targetDSO)

How this can be done.

Do I need to create an intermediate DSO so that I can keep all the KF from different Source info providers needed for the target DSO and then start using these KF to calculate the X, Y,Z.

Also, how I can use the calculation of X to use in Y.

Regards

##### Add a comment
10|10000 characters needed characters exceeded

### 3 Answers

• Best Answer
Former Member
Posted on Nov 15, 2011 at 06:40 AM

Hi,

You can do all the calculations in the start routine based on the source fields and the resulted calculation and update the results in an Internal table.

In field routine, you can write the routine to read internal table and assign the relevant field to the RESULT.

Regards,

Geeta

##### Add a comment
10|10000 characters needed characters exceeded
• Posted on Nov 15, 2011 at 06:22 AM

Hi Nivas,

YOu can use just one DSO and let the Calculation of X can happen in Start Routine/Transfer Routine and Calculation of Y (Where Y= XAB) can happen in End routine.

Rgds

SVU123

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member Former Member

Hi,

You have to create intermediate DSO to store A , B & C values. Create final dso from D kf source. Get the A, B , C values using look ups from the A, B, C DSOu2019s in transformation routine.

For this you need to define internal table and select statement in Start routine, where this internal table will be called in transformation routine. For X, Y & Z calculations write code in end routine.

Thanks

Riyez

• Former Member
Posted on Dec 14, 2011 at 09:12 PM

Thanks alot for replies.

I have used an Infosurce,a start routine, end routine,field routines to complete my data flow design.

I was able to populate the target fields to meet my requiremnts.

Regards

##### Add a comment
10|10000 characters needed characters exceeded

### Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.