I have a problem with data mart status in the ODS for some reasons the we have lost data mart status for all the requests in the ODS. Now I need to reset the data mart status without using initializing without data transfer option.
Can anybody suggest me how to reset the data mart status in the ODS without using initializing without data transfer option.
Thanks in advance
Say ur loading data from cube1 ( stock info cube) to cube2.
Now if u run a delta for the cube 2 from cube1, then the datamart status will be ticked again. To find the IP which loads the delta, just click on the previous data marted tick mark, go inside the monitor and see the Info package. If u schedule this immediately, the datamart will be ticked
Hope this helps u..
Datamart status indicates whether that request got pulled to higher level datatarget or not.
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.
IF you donot do as above, the problem is your next delta will fetch all the requests to your higer level datatarget.
Hope this helps.
RSDMSTAT and RSDMDELTA are the tables for data mart administration.
The tab data mart status of the request (Cube-->monitor)will be checked if the data is loaded into subsequent data targets from this cube.
Hope it helps
Thanks for your reply,
We have 4 ODS and 1 info cube.
ODS are 1O, 2O, 3O and 4O and Infocube is 1IC.
ODS 1O, 2O and 3O are loading to 4O (1O, 2O, 3O --> 4O (delta updte)).
4O is loading to 4O and 1IC (4O --> 4O and 1IC (delta updte)) .
Now the problem is we have lost the data mart status in the ODS 4O (4O --> 4O and 1IC (delta updte)).
I am not able to load deltas to the ODS and IC from 4O --> 4O and 1IC.
The data is upto date in the ODS 4O and info cube 1IC only thing is I lost data mart status in the 4O.
We need to get data mart status in the ODS 4O with out using Init without data transfer.
Please suggest me in this issue.
Thanks in advance
Thanks for your reply,
Why without using init without data transfer ? is because the delta load from ODS 4O is loading to 4O and 1IC (4O --> 4O and 1IC (delta updte)) . ODS 4O is loding to same ODS 4O (self data mart). All the request are linked in the ODS 4O. The latest load from the ODS 4O --> 4O and 1IC is loaded to PSA only and the laod failed in the ODS 4O and it sucessfully completed in the 1IC. when I tried to delete the bad request in the ODS 4O I lost the data mart to all the request in the ODS 4O. The latest request from ODS 4O --> 4O and 1IC is loaded to PSA only.
When I planned to to prepare a run book for init without data transfer. I am confused what request we need to delete because of the self data mart to the ODS 4O.
Now I want to reset the DM status with out performing init without data transfer . once the DM status is updated in the ODS then I can load the failed request from PSA.
Thanks in Advance
The delta load from 4O to 4O was loaded till PSA right,assuming after this only you lost data marts so delta was picked properly.
Just pull this to the ODS 4O also , by correcting the previous error.
Now do a init without data transfer to both Cube and 4O, this should set up the data mart till your last request.
Later on load deltas.
Hi Narendra If its BI 7.0 you can go for DTP with Delta option by flagging get request by request option in DTP level. If its BW 3.5 then the process would be run full repair once its done then run an init with out data transfer so that you want loose any thing as our base(source)level ODS is having all the data in it. and infact it wont affect to any thing elase weather its updating to two targets or many targets. As you know that init is purely source specific with out doing init w/o data transfer retaining delta is bit tricky... Hope its clear a little..! Thanks (P159793)K M R **Assigning points is the only way of saying thanks in SDN***
Narendra Reddy wrote:
> Hi All,
> I have a problem with data mart status in the ODS for some reasons the we have lost data mart status for all the requests in the ODS. Now I need to reset the data mart status without using initializing without data transfer option.
> Can anybody suggest me how to reset the data mart status in the ODS without using initializing without data transfer option.
> Thanks in advance
Now you need to reset the datamart status in 4O.If this is the case try as below.
1)Run the delta Infopack ie 40-->40 and 1C....this now load the data from 40 to the cube and ODS.
This should set the datamart status and bring all the data for the request ids where data mart status was not set.
2)As the this data is already avilable in the cube....please delete the request id which loaded on point 1 from DSO and cube.to ingore the duplicates.
3)Now push the current data from PSA ie later data and run the delta Infopack for latest data.
Hopes this helps you.