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

Characteristic changes without key figues changes are not recorded in ODS?


for a non-SAP source system we've modeled an ODS with:

- a single key figure,

- a key consisting of a document_id and a time reference and

- an additional characteristic "status of the key figure".

Due to the processing of the source system it may happen that the

<i>value of the characteristic "status" changes without a change of the key figure value</i>.

If that happens this <u>change is not processed to the active data of the ODS</u>!

As 0RECORDMODE we are using "After Image".

Any change of the key figure value AND the value of the characteristic "status", however, is recorded quite nicely.

Basically, we always want to have the latest value of the characteristic "status" in the ODS.

At the moment we are quite unsure, if

- this is not possible with an ODS at all (since the key figure value does not change) or

- we are using a wrong record mode or

- we need to change our model ...

Any help or suggestion would be much appreciated!


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2005 at 06:43 PM


    In your ODS, while defining the update rules for the STATUS OBJECT, use "OVERWRITE" option for it. This will ensure you will see latest version of it. It doesnt matter that the Key figure doesnt change. The existing data will be overwritten in STATUS OBJECT.


    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.