Skip to Content
Former Member
Apr 12, 2005 at 08:45 PM

Update cube with history data based on master data changes in ODS


Hello BW guru's,

I have a custom cube with one update rule, that gets uploaded with transactional data from an ODS1. In the update rule I have objects with routines that update those with master data from another ODS2.

If something is changing in the ODS2 (the master data ODS) I want to be able to apply the changes in ODS1 to the historical transactional data, that has already been loaded into the cube. The transactional data did not change only the master data. All my data is time independent for better performance.

Anybody knows how I could implement those updates, maybe some coding in the start routine....or...every suggestion would be greatly appreciated.