Skip to Content
Former Member
Jun 16, 2009 at 02:29 PM

Controlling extract - some transactions not picked up


Hi all,

Hope you can help on an issue i am experiencing with our Controlling cube: 0COOM_C02 (Cost allocations) - Delta

The data flow for the cube is via the following DSO's

0CO_OM_CCA_9 (Delta)

0CO_OM_OPA_6 (Delta)

0CO_OM_CCA_1 (Full)

0CO_OM_WBS_1 (Full)

0CO_OM_WBS_6 (Delta)

I have done INITs, followed by Delta loads (where appropriate) into DSO, then into the cube. Data loads go through without any errors on a daily basis. However, we have found during the course of the month some transactions are not being transferred into BI (DSO or Cube). If i do a complete reload of this data (i.e. do INITs again) the 'missing' trasactions are pulled through to BI.

The type of data which seem to be causing this is where the revenue is recognised in one period but the transaction is done in another period (?) although i am not 100% sure this is the cause. Has anyone ever come across anything similar?

Thanks in advance.