delta

[Former Member]

dear Gurus,

I need your help to clarify ODS delta concept.

The scenario:

1. To handle delta from source system , I am loading into ODS by init'g delta on ODS 1st. From here, the changes goes into the cube and aggregation will reflect the changes.

Whats unclear to me is, do I do another init delta from ODS to cube or full load?

Hope to get your advice.

best regards

Suzie

[Former Member · Accepted solution]

You do an Init and then deltas from ODS to cube. But if you receive Deltas into the ODS make sure that Add/Overwrite is set correctly.

Best regards

Dirk

[Former Member · Accepted solution]

Dear Dirk,

Do you mean no need to load delta into ODS from source system ?

From your 2nd statement, seems that it is possible to delta init from R/3 directly into the ODS.

In practice, when is it suitable to load delta (by init delta) into ODS directly from R/3, if suitable at all ?

I mean, I am just a little unclear about ODS. Seems like I can reflect delta in 2 ways:

1. Reflect delta in a cube using delta loading from ODS which receives Full Load in overwrite mode from R/3.

2. Reflect delta in ODS alone, assuming simple direct BEx reporting on ODS is only required, by loading delta from R/3 using delta init on the ODS set to Add mode? Is it for this case, it has to be Add mode only? Overwrite mode would not show the delta which is stored in the change log?

I'm still puzzled.

Regards

Suzie

sz_fernando@yahoo.co.uk

[Former Member · Accepted solution]

Hi Suzie,

You can do delta init for both ODS and InfoCube directly from R/3 system.

Again, it is not compulsory to load delta into ODS from source system first and then into InfoCube.

It works in this way..

Note : Delta records means all changed records as well as new records

In ODS, if you set to overwrite option

when you load changed records, it will overwrite the existing record present in it with the changed one.

for eg; if you have record with keyfigure amount 500 for a doc no 10012,

then for this record, assume that, amount keyfigure 500 is changed to 600 in the r/3. So when you sent this record to ODS it will overwrite the old one. i.e after you do delta. you will have only 1 doc with doc no 10012 with amount 600.

If you set to Add option. it will add a another record with difference...

for above eg.

When you load changed record, it will add another record with amount value 100 (600-500) with doc no 10012.

You can see all these in Change log table.

This concept will be same even when you load from ODS to InfoCube as infocube is always set to additive..

Hope you are clear now

Thanks

Vj

[Former Member]

Hi Suzie

If your datasource supports delta you dont have to use an ODS in between the cube and R/3. The extractor itself is sending you the changed records, so its just waste of process in the system setting up an ODS.

I would suggest you to remove the ODS and map the cube to the datasource itself since i can handle delta.

Thanks

Chris

[Former Member]

Thanks Dirk, Vijay and Chris. Points all round.