DTP between DSO and same DSO

[Former Member]

Hi everyone

Is it possible to move data through a transformation from a DSO back to itself? We have a requirement to do this so we only have to update those records where the status is not yet complete - therefore optimising performance. For example, we would key the DSO on sales order document number and item number. That order item would move from OPEN to COMPLETE through various intermediate stages peculiar to our business process. We would want to update the status each night but cannot rely on the change of status causing a delta for the sales order item. Once it has reached COMPLETE we would no longer be interested in updating the status.

[Former Member]

The above information was very helpful

[Former Member]

Hi,

yes it is possible and is referred as loopback process.

The logic could be built in the transformation from the DSO to itself, like passing only the key fields (no data fields/data fields blank) when the status of the record is complete.

[Former Member]

Thanks for that Murali - we have now looked up loopback processes and they seem to relate to 3.5 whereas we are on 7.0. Are there any special considerations regarding deltas that you know of?

[Former Member]

You can surely have a transformation from a DSO to itself.

But you can have only 1 such transformation.

From your requirement what i understand is that the Sales Order item moves from an Open state to an Complete State.

We had a similar requirement where in we had to run 3 different DTP's on the same DSO, which would update the status of a Purchase Order.

So, we made use of Infosources in BI 7.0.

The infosource was made on the DSO & only the required fields were mapped, for ex. Doc Number, Item, Schedule Line, Status.

This saves us from loading the entire DSO data over and over again.

Create a transformation between the DSO and the infosource & create one back from infosource to DSO.

Use a single DTP & update the required fields in the DSO.

We used a Full Load.

Again, another infosource was created & the same steps have been followed.

So, the data in DSO is updated 3 times only for the required fields & not all the fields.

I have not tried a Delta in this case. So I may not help you on that.