2.3.9.1 Import data into DAT03 Historic Volumes module - 9.3 Import Shipping Metrics

sydneygouani

I am having issues with 9.3 Import Shipping Metrics. I'm not seeing why I keep getting this error. Please see attached.

Screen_Shot_2021-11-17_at_11_125098.png

Accepted answers

All comments

Kanishq17

Hi @sydneygouani

Can you please show what are the dimensions of time in the module where you are importing

this error usually occurs if there is a mismatch in the dimension of the mapping from the source

HarishBabu

Try using custom on time dimension ??YY

sydneygouani

This didn't work. I got the same error.

sydneygouani

Sure! See attached.

Screen_Shot_2021-11-18_at_8_125170.png

sydneygouani

I even added a new time range of FY20-FY21 and still got the same error. I'm not sure what to do

Kanishq17

Hi @sydneygouani ,

Can you pivot the line item field from columns to pages and retry the process.

pivot the line item dimension to pages section

sydneygouani

I made the pivot and got the same error.

Screen_Shot_2021-11-18_at_9_125180.png

Kanishq17

Hi @sydneygouani

adjacent to the main mapping there are mapping details of the dimensions like how time is mapped , how products are mapped etc.

can you check those tabs and check whether there is a gap

sydneygouani

From what I can tell I am mapping everything but Time correctly. I've been using ??YY custom formatting. This has been successful for the import but action 9.3 still gives the same error. I've attached photos of the rest of the formatting. I think its time because its the only thing that's custom.

Screen_Shot_2021-11-18_at_4_125206.png

Kanishq17

hi @sydneygouani

Yes its the time mapping , I believe the soucr is also dimensined at years no? , so mapping should be match names and clear matched items only ,

As highlighted , and then try again

time is not mapped correctly

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…