LO Cockpit Missing Deltas!
Recently we had a problem with our LO cockpit data source and we lose some deltas for 1 week. Now we need that deltas restored using date selections in infopack , we are using Created on and changed on but we are getting duplicates / missing some records...
Can any one let me know how to get the deltas using the above two date selections without missing any record...
Currently am using two full loads of that period for each date selection, Iam getting duplicates. If I use only one full load using created / changed on then am missing some....
If it would have been a load to DSO and then to the cube,then it would have been very easy.
But since it is directly to the cube you have to be very careful now.
As you said you have 420 records which are comon in both the selections.
let the load happen from both the selections and then delete these records from the cubes through selective deletion based on sales doc values and do a full load to the cube seperatel for these sales document only.
This is bit tough as it is momotnous but there is no other option.