Loading Weekly Forecast Data from APO Demand Planning to S&OP via HCI
I am trying to load forecast data from a planning area in APO Demand Planning (DP) to a planning area in S&OP via HCI. The source planning area has weeks and months as time buckets. I have generated a data source for the planning area in APO DP and use it as source in HCI. Transferring the data on monthly level works fine. Now I have the requirement to transfer the data on weekly level. Here I have a problem where hopefully somebody can help me with.
From APO DP I get the time bucket information in the field CALWEEK in the format '<Year><Week>' e.g. '201452'. The planning area staging table on S&OP side uses a datetime field to identify the weekly time bucket as you can see in the screenshot below.
I have not found any HCI function to derive the date from a calendar week. Due to the year dependency there also seems to be no really simple logic to do this conversion. Does anyone have an idea how to reach such a data load on weekly level?
Thanks and Kind Regards,