Skip to Content
0
Former Member
Apr 21, 2009 at 07:02 AM

Missing records in SAP BI InfoCube

28 Views

Hi,

Data is loaded from DSO "Actual cost data/OD_CCA9" to Cube "RPM Generic: PS data/ICRPSGCB". Data in both DSO and Cube is updated by delta load. OD_CCA9 sourced by 0CO_OM_CCA_9

(Cost Centers: Actual Costs Using Delta Extraction).

I notice differences in Amount between Active and Change Log table and further to InfoCube. See below examples:

Tables in OD_CCA9:

Active table: /BIC/AOD_CCA900

Change log table: /BIC/B0000144000

1. example: Cost Center: 1678 - Costelement: 54101000

Active table: Amount: - 5.647.821

Change Log table: Amount: - 5.986.700 (miss update of rec. DKK. 6.500 + DKK. 332.379 from active table)

ICRPSGCB: Amount: - 5.654.521 (miss update of rec. DKK. 6.700 from OD_CCA9)

2. example: Cost Center: 1678 - Costelement: 61101049

Active table: Amount: 5.866,17

Change Log table: Amount: 1.168,03 (miss update of rec. DKK. 4.698,14 from active table)

ICRPSGCB: Amount:5.866,17

To my knowledge the change log table should contains equal or larger number of records than the active table - quick check:

Change Log: 688.861 rec.

Active table: 96.813.904 rec.

.. and acculated sum of the different key figures in change log table should be equal to similar key figures in active table.

Above examples no. 1 and 2 displaying no reconciliation.

Are anybody able to give me input how differences between DSO and Cube can be solved, and the comparatively few records in change log table. DSO is sourcing other BI solutions, and from end-users I've not received any complains of reconciliation deviations.

Kindly regards

Thorsten Jensen