BW的Repair Full Request

repair full request 
Posted: Mar 13, 2006 6:26 PM

When to use repair full request???
Lemme pen down my scenario...
I was asked to test in Development box for Item and header in sales.....
Last delta was done at last year dec.....now can I make use of same Delta Infopackage for pulling 3 months of data...
I was told to do repair full request???? Should I do this by creating one more info package with full load...to pull 3 months of data....

I got many inputs from my friends...
Input 1: One says if there is delta Infopackage and to do full load we have to select Repair full request cos, it will not allow us to do full load after delta has been intialised...

Input 2: If there are full loads earlier and to initialise delta we need to select Repair full request while creating Delta Infopack....

Which is the correct one???If both are not correct then lemme know when to use repair full request???

Thanks in advance and waiting for ur valuable suggestions

Re: repair full request 
Posted: Mar 13, 2006 6:57 PM  in response to:BW

Hello,

Go for Repair Full Request. In order not to disturb your delta selections you need to do the repair full load. After your repair full load you can continue loading deltas normally.

Create a new InfoPackage and mark this as Repair and then choose full upload and execute.

There is no repair flag for deltas.

GSM.

Re: repair full request 
Posted: Mar 13, 2006 7:21 PM  in response to:BW

Hello BW,

If you are doing a Full load to InfoCube, before you load you have to ensure that the data that you are trying to load doesn’t exist in InfoCube already. If data exists in InfoCube then do a selective deletion first in the InfoCube and then do the Full load. As values will be incorrect as InfoCube has Addition update only.

If the data that you are trying to load doesn’t exist then do the full directly.

In the existing system the data load from ODS to InfoCube, using a delta load or a full load ?

Hope this helps,

GSM.

Re: repair full request 
Posted: Mar 13, 2006 7:38 PM  in response to:GSM

Currently Loading is delta ....Last delta load was on last december.....since I have 3 months of data to be pulled from R/3... I am planning to create a new Infopack with Full load by selecting Full repair request...
Thats what u have said right????

Re: repair full request 
Posted: Mar 13, 2006 8:38 PM  in response to:BW

BW,

You have delta runs till december 2005, and you are only missing 2 1/2 months data, so you can run even directly just run the delta run. But make sure in RSA3 whether you have delta records for 01, 02 & 03 of 2006. All the records are in delta queue then, just do the delta. Dont even run the full repair. Then do the reconciliation. By chance if it doesn’t match, then you can do the selective delete for Dec 2005 till 03/2006 and then run the full repair request for the missing periods.

GSM.

Re: repair full request 
Posted: Mar 13, 2006 9:59 PM  in response to:GSM

Hey GSM,
I am seeing only data for 2002 in RSA3 and even in RSA7 also....
Not only in development box but also in production box also....what would have happened to 2003, 4, 5 and 6 data????

Re: repair full request 
Posted: Mar 14, 2006 9:41 PM  in response to:BW

Hello BW,

For your case Full Repair is not an option. Because even after you do the full repair, when you do delta, system is gonna get all the records, after your previous delta. Then your records will be doubled(if it is loading into the cube). If you are getting the data into the ODS either delta or full you are good no problems. As in ODS it will overwrite for the existing records. But if it is in the Infocube that you are loading, then no option for you except delta.

Dont cross check anything in RSA3. First just schedule the delta load in your case. Once the delta load is done, using manage or listcube check the records came in for till march 2006 or not. after the load, your delta will be pointing to current date. Then you check in BW and source system whether you have all the data or not. If not, then can think for alternatives...for full repair.

(One more time full repair you need to use for preserving your delta selections. Also when you think that data which you have already pulled into BW is incorrect or missing in those cases you can do full repair.)

Hope this helps,
GSM.