I didn't get the problem clearly.
But assuming you have deleted some request in ODS and for that ODS is linked to cube in your dataflow.
My question how can you deltete the data in ODS with out deleting the request in cube, may be you have deleted the datamart staus in ODS for that request..
Try to delete the request in your data target and it load again from source ODS which will reset the datamart status in your ods.
Hope this helps.
As you deleted the request with out changing the data mart status in ODS, you should have lost the delta functionality.
To rectivify the above problem, you have to follow the below steps:
1. Delete the same request from Infocube.
2. run the info package with the option '' Initialise the data transfer with out data transfer''.
3. Then this request will be run with single record and pointer will be set to run the delta.
4. Now you will get delta functionality. You can go ahead with your usual delt loadings.
Deltas are updating properly up to Dso, I want to update the same delta requests to infocube. while iam loading the same request from dso to infocube with delta option again it is giving error.
In infocube i have deltas up to 03.04.2010 , In Dso I got deltas up to 05.04.2010, so i have to update 04.04.2010 and 05.04.2010 delta requests from dso to infocube
Which option i have to use to get the data mart status again and deltas of 04.04.2010 and 05.04.2010 in infocube, initiaze with data transfer r with out data transfer.
Thanks & Regards,
If the complete data is there in DSO, then delete the all requests in Cube and then RUN DTP if it is BI 7 flow,
in BW 3.5 you dalete the Data in Cube and then load the data from DSO to Cube using Infopackage. Then it will come. Or right click on DSO and updata the data in data Tragets check this option.
If you find the datamart status deleted though all requests are present in higher level data target then just doing Init without data transfer should suffice as next delta will pull new deltas only, you cannot avoid init here.
If you find data mart status is deleted and also some of the delta request were not pulled then problems, you need to do reinit with data transfer deleting data in higher level data target.
Hope this helps.
As you said that you have deleted the request from the DSO without deleting the request from the data target, did u get any message that it will effect all connected data targets?
Are you going to load the request back to DSO from Source? I guess you cannot load back the request into the DSO untill you delete all the requests from the connected data targets. You will get short dump when you try to load the data from PSA to DSO.
I deleted a request in ODS with out deleting that request in data target. Due to this all data mart status for all the requests in the ODS got reset? I want to set the data mart status for the requests back again. Please suggest how this is done.
If you have data in ODS, then again you load data from DSO to Cube then your problem will be resolved.