Data mart status has beed reset by del the in between req in source ODS

[Former Member]

Hi SDN,

We have a situation where in which there is a daily delta laod going from ODS to Cube and we have reset data mart status accidentally by deleting the request which is in between multiple number of requests in the source ODS, now when we deleted the requests in ODS we got a POP asking for 'do you want to delete the data in cube' we went with on that POP up, after that when we see in the manage of the source ODS the datamart status is not seen for all the requests that have been loaded to target cube. Then we have reconstructed the data for the deleted request from the PSA.

Next day when a new laod comes into ODS then will the ODS send the correct delta update to target Cube.

If correct delta is not updated to cube is there any method that we can follow to maintain the data consistency with out deleting the data in the target cube.

Thank you,

Prasaad

[Former Member]

Hi SDN,

One more thing to mention is, the request in cube has been deleted and there is no staging in PSA to reconstruct that request if at all we go for "Init with out data transfer". Would you please give the solution as early as possible.

Thank You

[former_member181964]

Hi,

You dekleted Data in Cube and loaded,but Ddata Mart is not appearing in ODS. So if you have all data in ODS, delete data in Cube and then just delete datamart layer in ODS and right click and click on Update data in DataTarget, then fresh request will update to Cub , this is Init only then Deltas will go from net day onwards.

Thanks

Reddy