DELTA AND INIT TO CUBE Simple

[Former Member]

Please help me with this, I have a bad red delta request coming from billing ods in bmw cube so i deleted the request, but bmw cube has other green request coming from order and delivery which is fine green and success.

now to resolve this i deleted the red delta request of billing and also deleted every thing from ods and i redo the set up table and did init to billing ods but now when init goes to bmw cube it fails please tell me the exact step to resolve this please tell me how can i set up the delta again so that init from billing ods goes to cube

help me with navigation step.i do not want to delete the entire data from cube to resolve this

thanks

soniya

soniya

[Former Member · Accepted solution]

If you have deleted everything from ODS and built it afresh, you may have no option but to load the cube afresh as well.

You may try to delete the init on the cube (from the infopackage editor), do an init without transfer from ODS to cube, and then do normal delta. Even if it works, it may not account for the delta that might have happened since you last loaded the cube.

[Former Member · Accepted solution]

Hi Soniya,

The first option would be to go the monitor, select the old request to the cube from billing that failed and set the overall status to red. If you do this, the next time you open the infopackage it would prompt you to repeat the delta. Go ahead and see if it pulls the records this time. If this option didnt work, please do what Ajay recommended. That is...delete the initialization by going into infopackage -> scheduler -> Initialization options for source system -> Delete the existing init. Once done, do a init with data transfer (if you have only one request in the ODS). Let us know if you have any questions.

Assign points if helpful.

[Former Member · Accepted solution]

Hi ! we do not have infopackage in datamart to load init and delta , its automatic update from billing ods to sales cube. now sales cube also recieves the data from order ods and delivery ods automatic no infopack from ods to cube. so please clarify how ur suggestion work here.

Overallstatus for the bad delta request is red in sales cube it is always red when it fails why and where it need to set up manually. Now Prakash please suggest how i determine what records were there in delta which failed to run the set up table. Please suggest me the solution to simple problem i have a cube where delta load from billing failed so i deleted that. and also all the request that come from billing ods also i deleted in cube.<b><b>but all other request from order and delivery remain in cube as it is green.</b></b> and i did the setup run and init the ods billing but now when it automatically update to cube request in cube fails. please

tell me the solution.

Correct my approach

delete all request in cube from billing order and delivery

and then delete all request from ods billing order and delivery.

load data in all 3 ods from psa init request.

and then init from ods billing, order and delivery will go automatic one by one into cube

and then do delta from ods to cube

please tell me some easy approach this required lot of work

thanks soniya

[Former Member · Accepted solution]

Hi Ajay, Srini, Prakash, Joseph and all bw experts, you all are very helpful, but here is what i implemented the solution, confirm me if it is correct since all data is reportable

i deleted the failed delta red request from sales cube and deleted the init from infopack from ods to cube and reinited without data transfer and then i did the the full load with repair request for the same fiscal year/period like in billing ods for the delta which failed. and then i am done since there is no new delta right now it does not allow at the moment delta update but i guess once new delta will come to ods tomorrow it will update the cube. please confirm this is the best solution to fix the delta red request in production.

thanks

soniya

[Former Member · Accepted solution]

Let me try to get it.

Your ODS has delta coming in for a specific fiscal period? Is there no overlap (meaning one billing document coming in as new into the ODS and cube is not changed in the next period)?

If not, there may be a problem.

Consider the case where you had a document which came in earlier (successful) request, and is there in the cube (say with a original qty of 25). Now, say your last delta had a change to it (of qty increased by 5, say), and this delta failed to go to the cube. Now you are doing a full load with repair for this period.

Since you are doing a full load, it will bring a qty of 30; however your cube has the earlier record (with a value 25), so instead of total 30 (correct) you will end up with a value of 55(incorrect).

The difference here is that your delta which failed had a qty of 5 (incremental amount) for this doc, but now you are bringing the qty of 30 with a full load.

This is a theortical scenario which can cause inconsistency to your data. If there is no case where an earlier existing record was being changed in the last delta (ie last delta had all new records) then you should be ok.

[Former Member · Accepted solution]

Hi Ajay since I deleted the all the request from cube and loaded init with no data transfer and then full load for all fiscal year .period so there are no chance of overlap why there will be. please tell if this approach then is correct to fix the delta i assigned the points but please help me on this

[Former Member · Accepted solution]

It will be fine as I understand it.

[Former Member]

Soniya

Before deleting all data, please weigh your optioins.

For missed delta records, simply run the setup for only those set of records, instead of filling the setup tables from scratch.

And then do a full load with repair request. this should take care of many delta failure scecnarios.

Prakash

Assigning points on SDN is a way of saying thanks!!