Skip to Content
author's profile photo Former Member
Former Member

ODS report and Update Rules

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 07:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 07:30 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.