ODS report and Update Rules

[Former Member]

I have an update rule to an ODS. In the ODS I have added some data fields, which are not part of the communication structure of the InfoSource which is the DataSource for the Update Rule. I have placed a routine behind these fields in the Update Rules which works and gets the values from a P table. The InfoPackage that is loading to the ODS is a delta load. In order for me to include the values for the new fields is the process as follows

1) Activate Update Rules

2) Create an InfoPackage to carry out a Full Repair Load (just once, does not need to be scheduled since in future the Update rule will handle?)

3) Let the Delta Load Package which is part of a Process Chain thereafter continue its load process as normal

Thanks

[Former Member · Accepted solution]

You may get inconsistent data, if the following happens in the future:

Data in the P table is changed, but at least one of the corresponding transactional records that are in the ODS object are not changed.

In that case the transactional records are not posted to BW in delta mode and the look-up on the P table is not performed.

You'll have to introduce a mechanism for repairing the data in the ODS on a regular basis (not necessarily full updates from the source system...)

Hope this helps!

Regards,

Christian

[Former Member]

Hi Niten!

Your procedure is correct (included the creation of a new infopackage in order to do not modify the already existing IP used to manage delta in PC)...anyway, I think you have not only to reactivate your update rules (after having inserted the new routines for your added fields), but also set in no update all the fields except key fields and new fields ! Then, after your full repair request, you can reset the update rules as usual...

Hope it helps!

Bye,

Roberto