Skip to Content
0
Former Member
Nov 25, 2008 at 06:41 PM

Reload from ODS to cube - missing records

53 Views

Hello experts,

Here is my situation...

We needed to reload some cube data from ODS, so we deleted the requests from the cube(s) - 30 request id's.

In the ODS, we went in and unticked data mart status for the requests that we needed to reload and then updated from ODS to cube.

The status of the IP is green, yet we did not receive all the data in the cubes. We were expecting around 1,523,615 records to be transferred but only 889137 were.

When I look at the InfoPackage in the manage screen of the cube for the reload - on the details tab (under databasis (requests)), I can see all 30 of my request ids that should be selected from the ODS to be sent.

Here is the issue...

Even though the requests in the ODS were unticked for the 30 request id's, the ODS seems to only send a partial subset of the requests, around 12 of the 30 request ids that were selected (these 12 requests equal the amount 889,137 transferred to the cube), and after the reload it rechecks and flags all 30 of the requests as sent.

When I look at my data in the cube, I can definitely see that data is missing.

I have tried the reload twice with the same results. I have also verified that my requests exist in the change log of the ODS.

Is there any other reason that would cause this? Or anything else that I should check?

Any advice/information is appreciated.