cancel
Showing results for 
Search instead for 
Did you mean: 

Delta records concept in InfocubeCube

Former Member
0 Kudos

Dear SDNer,

I have searched in the forum for beolw concept but i didn't get the proper answer in the forum.

Can anyone one give the adequate explanation for the below scenario.

Scenario : Data loading from DSO to Cube

DSO Data: Yesterday i have loaded the data to the DSO

Customer Calday Status Quantity

1011 yesterday Open 10

the above data is in DSO, i have loaded the data to Infocube.

Cube Data: Yestraday i have loaded the data from the Cube to Cube

Customer Calday Status Quantity

1011 yesterday Open 10

DSO Data: Today i have loaded the data to the DSO

Customer Calday Status Quantity

1011 yesterday Open 10

1011 Today Closed 15

Cube Data: Today i have loaded the data to Cube from DSO.

Customer Calday Status Quantity

1011 Today Closed 15

Final data in the Cube with Quantity 15.

Can any one explain how the delta concept works in Cube by deleting the first record and inserting the new status record.

Please give me some light on this, i have seen some articles on Datasource to DSO/Cube but not DSO to Cube.

Regards,

Satya

Edited by: satya prasad on Feb 8, 2012 7:31 AM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

DTp takes data from change log table of DSo..check in ROOSOURCE table, you delta will be AIE/AIM:After Image Delta Process...

that is why last delta is getting updated to cube...

Former Member
0 Kudos

Satya,

Delta in cubes are in additive in nature though in DSO it can be Additive and overwritten.

As you are talking about Infocubes, the KFs should add. Can you elaborate the issue somewhat more with KFs and all so as to get a better understanding.

you can check the following docs for the delta concept for cubes and DSO and if have any issue write back to me.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5080c337-81e5-2c10-97af-8929424f3...

http://www.trinay.com/SAP%20BW%20Extraction.pdf

Rds,

AM

Former Member
0 Kudos

Hi Satya,

Could you please provide some more information..

1. what are the key fields in your DSO and cube.

2. what is total value of the key figure.. is that 15 or 25.

Regards

Preethi

Former Member
0 Kudos

Dear SDners,

Thanks for your response,

The Keyfields in the DSO and Cube is Customer, calday and status.

Please let me know if u want any information.

Regards,

Satya

Former Member
0 Kudos

Hi Satya,

Please check the active table of change log with customer 1011.

you will have only record with customer 1011. check the key fields of your DSO(is it only 1011(customer) or customer, calday and status).

whats is your data source name, check the delta process of your DSO(your can check in ROOSOURCE)

check the change log table of DSO, delta DTP will always pick data from change log table.

Regards,

Venkatesh