This article applies to SAP Business Intelligence (BI 7.0). For more information, visit the Business Intelligence homepage.
These documents describe step by step procedure of loading the recently missed delta using reconstruction method. Hopefully it will be useful to anyone else who’s about to load missed delta (especially for beginners).
Author(s): Rajesh Kumar Sinha
Company: Accenture Services Pvt. Ltd.
Created on: 25 April 2012
Author Bio :
Rajesh Kumar Sinha, is working as a SAP BI Consultant in Accenture has an experience of more than 1.5 years. Skill set includes SAP Business Intelligence and Business Objects.
This article explains how to load recently missed delta using Reconstruction method (3.x flows) in BI system.
This method can be used if the delta load is taking place:
- From one DSO to other DSO.
- From DSO to cube.
- From Cube to Cube.
There are two ways to load missed delta one is the repair full load and other is load manually missed delta using reconstruction method.
SAP BW supports two types of updates in which data can be loaded into SAP BW. The full update always extracts all data for the fields of a transfer structure. The second type of update is the delta update, which only extracts data that has changed since the last load process or that is new. Delta updates are especially suited to large data masses so that data does not have to be loaded into SAP-BW multiple times. Deltas can also be transferred from the source systems with extractors so that complete transfers can be avoided.
Reconstruction can be performed on cube in BI7.0 only and it can be performed on cube if it is 3.x flows Info Package.
To reconstruct the requests the data for the corresponding requests must be available in PSA.
This function can be used to fill a DataStore object with requests that have already been loaded into the BI system or another DataStore object.
Reconstruction can be used is only for DataStore objects that obtained their data from InfoPackages.
Reconstructing the DataStore object gives data from the change log, so the delta can be loaded into the Reconstructed DataStore.
Requests can be used to reconstruct the current InfoCube or construct another InfoCube.
If the requests contained in the InfoCube were already rolled up in aggregates or in BI accelerator indexes, then these requests cannot be used for reconstruction. Only the last (uppermost) requests can be used for reconstruction.
- Take lesser time to load recently missed delta compared to repair full.
- If there is no date selections(like Cal-day) in Info Package then this method will be efficient compared to repair full load.
Step By Step Solution
Here we are taking the scenario for Example: Source is DataStore Object (DSO) and Target is InfoCube(Cube).
If the delta load has failed from past 2-3 days from DSO to Cube, we can load the entire missed delta from DSO to Cube request by request using reconstruction method.
To perform this operation follow the below steps.
- Delete the error requests from the Cube by forcibly changing the status to red (do it even the request is red) at the monitor screen and also in manage data of the Cube.
- Delete the data mart from the source DSO.
To delete the data mart perform the following steps.
- Right Click on DSO.
- Then click on manage option of the DSO.
- Go to the request tab and click on Data Mart Status of Requests.
d. It will prompt for new screen (in the below screenshot)
e. To confirm that the correct data mart is being deleted, Click on the Display Request monitor.
f. It will redirect to monitoring screen there you can verify the Data Target System (in this case it is Cube)
g. Click on Reset Delta Management (Delete option).
It will prompt to “Are you sure to reset the delta management”.
Click on yes.
h. By clicking on Yes tab Data mart will be deleted.
3. Now delete the all failed delta request from source DSO (Requests What are not loaded to target Cube) after deleting the data mart.
4. Now Load the data from DSO to Cube.
5. Check if the delta has pulled any record (Missed delta) or not.
6. If it has pulled 0 records to from DSO to Cube, then there may be chance that Cube’s delta has been corrupted.
To initialize the delta perform the following steps.
Steps to Initialize the Delta.
1. Go to the update tab of Info Package and select “Initialize Delta Process” and then select “Initialize Without Data Transfer.
2. Now Go to the Schedule Tab on Info Package and click on Start.
Now it will prompt for “Deltas already loaded for requests …(old init Request in)….init. Selection; no 2 init”.
3. Go to Scheduler tab (Top left of the screen) of Info Package and select the “Initialization Options for Source System”.
4. Now select the previously initialized delta request, without making red the monitor status of previously initialize request and click on delete.
5. Now It will prompt for “Deleting initializations affects Data Store Object” click on ok.
6. Check if there is any selections in the previously initialize delta.
7. It will again prompt for
“There are active init selections in the source system for this data source
Therefore, only ALL init selections can be deleted once
Do you want to delete all init selections (all channels)”
Click on Yes.
The previously initialize delta will be deleted.
8. Now go to the Schedule option of the Info Package and click on Start.
9. After successful initialization of delta load the missed delta from source to target.
Steps To perform Reconstruction of the requests.
1. Now go to reconstruction tab of the source DSO and select the first deleted (request which loaded first to the DSO) request and click on reconstruct/Insert option.
If the requests were deleted by making monitor status red then it will prompt for
“Request ….. is not marked as correct
This request cannot be used for reconstruction!
Ignore the request?”
2. Now go to monitor screen by clicking on “Display Request Content” of the deleted request and make the monitor status green.
3. And then again click on Reconstruct/Insert option.
Message will be displayed at left bottom of screen “ Reconstruction scheduled for DataStore/Cube …(Name) “.
4. Now after reconstruction load the data from DSO to Cube.
5. Now again go to the reconstruction tab of DSO and reconstruct one more request and load the same to the target Cube one by one(Reconstruct one request and load the same request from DSO to cube ,again reconstruct one request and load the same request from DSO to Cube).
6. Perform above steps till the last request gets loaded successfully.
Similarly the reconstruction method can also be used in Full Load.