cancel
Showing results for 
Search instead for 
Did you mean: 

ODS to Cube Load...Urgent...Please Help!!!

Former Member
0 Kudos

Hi,

Consider the following architecture. We have SAP R/3 connected to an BW/SEM Production System and we are running the BCS consolidation module on this system. For consolidation purposes we have the following architecture in place. There is a daily delta update from R/3 to the ODS and the CUBE.

SAP R/3 -


0FIGL_O07 (ODS) -


ZBW_BCS (InfoCube)

We have been having numerous problems with the daily delta update that runs from R/3 to the ODS and the subsequent data target (the infocube).

Currently the delta has not run for 1 month. Usually the no. of records that are transferred are about 600,000. Today 22 million records were updated to the ODS but the load from the ODS to the cube failed.

The error message was:-

Delta update for 0FIGL_O07 is invalidated

Message no. RSBM113

Diagnosis

The delta update for the InfoCube 0FIGL_O07 is invalidated. The can be due to one of the following:

1. A request, which was already retrieved from the target system, was deleted from the InfoCube.

2. A request, which was not yet retrieved from the target system, was compressed in the InfoCube.

Procedure

Initialize your delta update again.

My questions are:-

1.) Do I have to re-initialize the ODS object and Cube ?

2.) If I delete all the data in the cube including the initialization request and select Update ODS contents in data target (Full update) will this work ?

3.) What could be the problem for this ?

Thanks in advance

Regards,

Dominic

ps; Please note that if the update is successful usually there is a green tick (correct sign) next to the request. There is no such sign for any request in the ODS at present.

Message was edited by: Dominic Goonawardena

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Dominic,

If you do a reinit without data transfer you do not need to delete the data from the cube.

Data needs to be deleted only if you want a fresh init again.

Hope I have made things clear.

Bye

Dinesh

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Dominic,

Once the initialization request gets loaded then the cube and the ODS data would be in sync.

Now whenever the ODS gets updated you can run a delta for the Cube.

Hope I have made things clear.

Bye

Dinesh

Former Member
0 Kudos

Thanks Dinesh. I will repost after the first delta runs in a day or so.

Thanks to everyone who helped.

I have given out points to all. If not please let me know.

Former Member
0 Kudos

Hi Dominic,

Here we have two cases. If your ODS is properly updated then your problem is very easy to take care.

1. Delete the contents of Infocube

2. Delete the initializaiton options

3. Re Initialize data from ODS to cube

If in case your ODS is not updated then you will have to start from scratch. Initialized ODS first and then subsequently infocube

Cheers,

Baljit Singh

Former Member
0 Kudos

Hi,

As per instruction this is what I have done...

1.) I deleted the data in the InfoCube.

2.) I deleted the initialization request.

3.) I then scheduled an immediate initialization request which is running now.

What do I do next ??

Regards,

Dominic

Former Member
0 Kudos

Hi,

u have to re initialize the delta, if u r using the delta upload..

u can use full upload also as the data in the ods & cube is already deleted..later u can convert it into delta upload by doing the repair full request with

RSSM_SET_REPAIR_FULL_FLAG.

Regards-

Siddhu

Former Member
0 Kudos

Hi Dominic,

You can do a <b>Init without data transfer load</b> from the ODS to the cube. Then do the delta load. Hopefully things should be fine.

Bye

Dinesh

Former Member
0 Kudos

Thanks Dinesh,

Just to sum up what you said.

1.) I delete all the data from the cube.

2.) I delete the init request from the ODS to the cube.

3.) I re-initialize the request from the ODS to the Cube.

4.) I then say update ODS in Data Target and click Full Update ??

Is that correct ??

Regards,

Dominic

Former Member
0 Kudos

Hi Dinesh,

Now I face similar problem like Dominic has. When i tried to "do a Init without data transfer load". It said i should delete the previous init update in that cube Is that OK?

Thanks alot,

Aswin