L2 2.3.9.1 Import data into DAT03 - Issues with timescale & SKU list

Hello,

Been stuck in a loop for a while on this now - I can see a few other users have been caught out as well - so perhaps needs to be made more explicit in the guidance.

I am having two problems.

1. I do not understand how to map the timescales together

2. The SKUs lists between the two models are different - Did I do something wrong in the datahub?

Error_On_9_125008.PNG

Import_to_DAT03_p2_125008.PNG

Import_to_DAT03_p3_125008.PNG

Target_Module_DAT03_125008.PNG

Import_to_DAT03_p1_125008.PNG

Comments

JaredDolich

@learncw1

Great callout. Let's get you to the finish line. First, you did the right thing by checking your mapping. You may have noticed that your products didn't map to anything. that's because your product list probably isn't loaded yet. You'll need to do that first before you can load the transactional data.

learncw1

@JaredDolich Thank you very much. I have gone back through the end of Sprint 1 and imported the SKU details into the Supply Chain Model. Still stuck on the timeline however.

As far as I can see - I have attempted matched the dimensions of the target module of the source model.

I have tried many different options for the time settings in the import file - but I keep getting variants of the same result, so clearly I have missed something fundamental.

Thanks

DAT03_Time_Settings_125034.PNG

Import_Time_Setting_125034.PNG

Error_Message_125034.PNG

JaredDolich

@learncw1

Your time range looks like this? And your Export view in the data hub has excluded the months?

learncw1

@JaredDolich. Thank you for responding.

My time range matches the below. The DAT03 module export matches the requirements for 1.5.8.1.

When I apply the filter it shows the summary month columns as blank (this is the saved view which matches the requirement) if I switch off then reapply the filter the summary month column disappears. When I rerun the import action I still get the same error.

Any ideas?

Thanks

Supply_Chain_-_Time_Range_Settings_125059.PNG

DAT03_Filters_125059.PNG

9_125059.PNG

DAT03_Time_Settings_125059.PNG

DAT03_Saved_View_-_Export_125059.PNG

1_125059.PNG

JaredDolich

@learncw1

Well, we're a lot closer but we need to get the file to load with no errors. Some suggestions:

Make sure your calendar looks like this one
Add a Boolean Line item to SYS01 called Week? and set it to TRUE. Use this in your saved view filter to take out the months, quarters, halfs, and years.
I suspect you have aggregate time periods, like quarter and year showing up and not indicated in your calendar.
Your import action looks good so we just need to figure out what's causing the error. If you continue to get errors, go to the details section and scroll to the right to see what the specific error is.

learncw1

Ah i think you have zeroed in on the source of the problem.

My calender settings in both models match the below.

So I have checked SYS01 has a Weeks Only line item - I think this is ok.

When I apply this as a time filter in the DAT03 module - I just get blanks - This is where I played with filter settings until I was able to match the requirement view rather than landing on the right solution.

SYS01_-_Week_only_table_125082.PNG

SYS01_-_Week_only_in_blueprint_125082.PNG

DAT03_Without_Filter_125082.PNG

DH_-_DAT03_Filter_3_125082.PNG

DH_-_DAT03_Filter_2_125082.PNG

DAT03_Filter_Applied_125082.PNG

DH_-_DAT03_Filter_1_125082.PNG

Supply_Chain_Calender_Settings_125082.PNG

Data_Hub_Calender_Settings_125082.PNG

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…