How to load data from a ODS to CUBE Request ID - by - Request ID?

[Former Member]

<i>How to load data from a ODS to CUBE Request ID - by - Request ID?</i>

The problem is that... some requests had been eliminated of the cube and the delta control between the ODS and CUBE was lost. The flag "<b>data mart status of request</b>" of all the requests of the ODS had been blank.

Now it is necessary to load some requests from the ODS for the cube.

Notes:

- it is not possible to make a complete load selecting the data to be loaded;

- the PSA is not being used;

- considering the data volume it is impracticable to reload the cube completely.

Thanks in advance,

Wesley.

[Former Member]

Hi Wesley,

I think it's better for you to build a custom extractor on mchange-log table and then select what you need (there is request, packet number and record number as key)...but if you deleted datamart status you have your change-log table empty ???

If yes....

[somnathkumar]

You could look under the 'Reconstruction' tab of the infocube. Even if the requests were deleted from the cube, you might find them here. If yes, select the required request and reconstruct.

This will load the data back into the cube.

[Former Member]

Do a delta init on ODS to PSA with no data transfer.

Now, schedule the delta load from ODS to Cube with data transfer.

[Former Member]

Dear R B,

Considering the following:

-> the delta control was lost;

-> the data already are active in the ODS;

-> part of the data of the ODS already is in the cube.

The indicated procedure it only guarantees the load of the data that are in the ODS and that are not in the cube.

Tks,

Wesley.