Skip to Content
0
Former Member
Jan 03, 2013 at 02:00 PM

change log confusion -- need expert advice

16 Views

hi experts

having gone through lot may threads but having a confusion in mind regarding the types of delta ie abr, after image and add how change log works for each of them while moving the delta to the cube i haeve a good understanding on after image before image and the record mode but would like to have some understanding further in the below queries

below are the questions

1)can someone from experts please explain how would change log and active table look like when the delta mode/type is abr and the keyfigure is set to additive mode in ods

2)how would change log look like when the same ods has keyfigure set to overwrite mode with delta as abr

3)how would change log and active table look like when delta type is after image in datasource and keyfigure is overwrite

4)how would change log and active table look like when delta type is add and the ods keyfigure is set to addition mode.

i have gone through various links and all the links explain of the after image before image with abr as delta type

please help, i understand the concept of change log but would like to understand it more thoroughly with each of the delta types

thanks