0SD_C03 Problem when Pricing Date value changes

[Former Member]

I am loading the 0SD_C03 cube using the 2LIS_11_VAITM and 2LIS_11_V_SSL datasources. I am using delta loads. I have a problem when the Pricng Date is changed. Pricing Date is a characteristic in the cube. Since the cube does not have Overwrite, a new record is created in the cube whenever the Pricing Date is change for a sales document. Am I doing something wrong. The only fix I can think of is to delete the contents of the cube and reload all the data from the 0SD_O01 DSO. This does not seem like the right solution. Can someone share how the overcome this issue?

Thanks.

Ryan

[Former Member · Accepted solution]

Hi,

Thats should not cause any issue.

When delta is getting loaded into cube from ODS. All the KF's with old Pricing date will get a delete image. This makes all the KF's to Zero Value and a new record will be created with the new priocing date with all KF values.

Please do check KF's of Old pricing date and new pricing data.

Regards,

Bilapati