Skip to Content
0

Data Loading Issue from Cube to DSO

Nov 23, 2017 at 05:05 PM

49

avatar image
Former Member

Hi Team,

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.

Could please someone help me here.

Thanks in Advance !!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 28, 2017 at 07:06 AM
1

HI,

Below Steps may help:-

1. Change the DTP- Check Semantic Grouping for Sold_to, Material (Hope sold_to and material are key fields in your target DSO)

Try with step 1 and see if it works else,

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Maju Alexander,

Thank you for your suggestions.

I have tried the suggestion 1, it was not working before.

As suggested for Start Routine, I tried it before and it was not working. But yes this one gives me some closer solution..

Thanks & Warm Regards,

Rahul Pratap Singh

0