Data Loading Issue from Cube to DSO

We are loading the data from Cube to DSO where the Key Figure in DSO is having aggregation property as Overwrite.

In the Cube for a single SOLD TO we have different materials with different Calday. Now while loading this data to DSO, I can see Key Figure values are getting populated randomly not on the basis of CALDAY means as per my understanding KF values should overwrite on behalf of latest calday but it's not happening here.

2. Create a start routine to sort the SOURCE_PACKAGE based on SOLD_TO MATERIAL Ascending CALDAY Descending and delete adjacent duplicates from it. This will ensure you have only 1 record based on the latest calday