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

API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…