Skip to Content

Data Loading Issue from Cube to DSO

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 !!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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


    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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