DSO tables active data table and change log table

[#1]

Active data table under DSO(/BIC/A<ODSNAME>00): does it contain just the latest active record or also the historical data?

Change log table Under DSO: does this table contain only the historical info only, or the active record is also available within this table?

Thanks a lot for the helpful info.

[Former Member]

Hi

Active table contains all the data based the key fields (Historical and latest). The data is depends on the aggregation you selected(Over write or Additive).

If you select aggregation as 'Overwrite' then you will unique records for each key field value with key figure values overwritten.

If you select aggregation as 'additive' then you will have unique records for each key field value with key figures values additive.

You can check whether key figures are overwritten or additive in transformation.

Change log table also contains historical and current data based on 0recordmode however you will not have aggregations here.

Check out the below one how change log and active table contains data.

http://explore-sapbw.blogspot.in/2012/04/how-does-dso-maintains-delta-records-in.html

Regards,

Venkatesh