Self Loop in Start Routine

[former_member206475]

Dear Users,

I have a Cube with data. There is a new date field added to cube. This date field get value from a DSO based on order number as key.

I have to populate this new date field in cube with the date value coming from DSO. Therefore i want update existing data in cube to have this new date field populated without changing any other data or appending new data.

Can you please suggest what logic i can use? Will a self loop help? and logic?

[raymond_giuseppi]

Your translation from 'document number' to 'order' was somewhat misleading, should I suppose the infoobject for doc_number doesn't carry any attributes?

Are you getting a time-out? Select the whole required data from youd DSO : replace first SELECT with some FOR ALL ENTRIES IN source_package in a sorted internal table, then LOOP AT source_package performing some READ TABLE to update requireed field.

For 'legacy' data in the Infocube (no longer able to reload it correctly from source system?) you could consider defining some kind of 'once only' transformation from full cube to itself, execute and remove previous requests from cube.

Regards,
Raymond