Skip to Content
0
Former Member
Jan 10, 2012 at 09:51 AM

Delta between DSO and Cube

339 Views

Hi All,

I have been working on a scenario where in we have to realign org structure information of some sales orders , now we have existing sales orders data in DSO , which feeds to a cube . As part of the realignment some master data attributes, more specifically Customer Master attributes, will be changed in R3 for those Sales Orders.

These attributes are part of the transaction data load which is happening to the DSO from the source, now since this transaction load is taking time, to speed up the process of realignment in BW I have used a routine to lookup the masterdata attributes from 0CUSTOMER in BW.

so before BW pulls the realigned data ( Sales Orders ) from R3, I will run a self loop in the DSO where in it will do a lookup in the 0CUSTOMER master data in BW to get the updated customer attributes (ofcourse the 0CUSTOMER load will happen before we do any realignment of the source data) .

Once the self loop transformation is completed and the sales orders are updated with the updated customer attributes, I will load the data to the cubes. (delta load)

Now once the sales order realignment is finished in R3 , I will pull the same set of data in the DSO .

Now the question is, is it necessary that I do a reinit of the cube before I load the second set of data to the cube?

I guess it is not necessary.

Please share your thoughts.