Question:
Hi,
Actually the data was uploading to the infocube by delta upload for daily job. Incidentaly due to mismatch at the report side , few request deleted at the infocube and try to update the data again into infocube.
While uploading the data into infocube from ODS , I am facing the error as 'request delete at info cube' and the procedure says go for init delta.
However, the init delta upload has defined 1 and half year back ,after that it starts using detla upload for any new data.
Could you please suggest what are the various steps to be follow up to get the delta data from ODS to infocube. Shall I have to go for init delta even though the data present at Infocube.
Thanks & Regards,
Muzeeb
Answer:
Once you have lost different delta requests in a cube, as for as I know you have no other option than to redo an init delta.
Gr,
M.
Answer:
Hi,
Actually the data was uploading to the infocube by delta upload for daily job. Incidentaly due to mismatch at the report side , few request deleted at the infocube and try to update the data again into infocube.
While uploading the data into infocube from ODS , I am facing the error as 'request delete at info cube' and the procedure says go for init delta.
However, the init delta upload has defined 1 and half year back ,after that it starts using detla upload for any new data.
Could you please suggest what are the various steps to be follow up to get the delta data from ODS to infocube. Shall I have to go for init delta even though the data present at Infocube.
Thanks & Regards,
Muzeeb
If i copy u properly ur INIT/DELTA got messed up in INFOCUBE while loading from ODS
1)if ur Datamart status in ODS is still in sanctity(not disturbed and lies safely in ODS) for those requests deleted from Infocube
Steps - Delete request from cube which failed
goto ODS--->Request(which failed to cube) click on DATAMART STATUS besides to reporting ICON ,its gonna pop u a dialog box ,hit the delete button for the request which failed to cube
u r now set for ur next load with ur usual INIT/DELTA mechanism
Also check the reason why the last load failed as a part of sanity check.
PS. Dont delete Datamart status for those requests which have been already updated to cube else u r screwed.
Hope it Helps
_________________
Chetan
@ CP...