cancel
Showing results for 
Search instead for 
Did you mean: 

Loading Daily Data into Technical Week based Key Figure

Hi,

In our Demand Planning Model, we have set Technical Weeks as the lowest time profile level. However, the Actual Sales Qty. coming from our BW system (via HCI) is at Date level (i.e all SO in a day for a material and customer combination come as single value).

If there are multiple records with dates falling in the same Tech. Week, we are getting error message "Unable to import the data because the row is duplicated in batch xxx and file yyy.csv" . This error also appears during manual upload via Data Integration.

Is there a way to ensure that day-level data can be aggregated automatically as a single Tech. Week level value and loaded via HCI. Please provide your valuable suggestions.

Regards,

Shivpriye

serhii_rud
Explorer
0 Kudos

Hello,

I have the same Issue. Seems that it should be some standard approach for this aggregation somewhere...

Regards,

Serhii

Accepted Solutions (0)

Answers (0)