Import into DAT03 Historic Volumes

ciara
Occasional Contributor

Import into DAT03 Historic Volumes

Hi,

 

Im currently on Level 2 Sprint 2. For Importing the DAT03 from the Data base to the Supply Chain, I keep getting a error

ciara_0-1592771350953.png

This is stopping me from running the proccess 9. I have connected the Supply chain to the Data hub.

ciara_1-1592771452576.png

Please help, I am lost and have gone back to see what I have missed but nothing is coming up

1 ACCEPTED SOLUTION

Accepted Solutions
Kanishq17
Community Boss

hi @ciara 

 

Adding to this, you need to ensure that in the line item tab of the mapping the mapping is established as here your names are different , so mapping may have to be established manually in column 1

 

 

View solution in original post

18 REPLIES 18
einas.ibrahim
Master Anaplanner/Community Boss

Hi @ciara 

 

Can you please share a screenshot of the instruction so we can walk through it step by step.
Also, Have you not changed the name of your DataHub you created in Sprint 1?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
ciara
Occasional Contributor

Hi, Thanks 🙂 I havent changed the name of the Data Hub from Sprint 1

ciara_0-1592773905222.png

 

einas.ibrahim
Master Anaplanner/Community Boss

Hi @ciara 

 

As you can see from the instructions it mentions that the data in the Datahub is for the actuals of the FY19 year, however, the supply chain model has a model calendar starting at FY20.

They have created a time range for FY19-FY20. 

Have you used that time range in the model you are importing into? 

Also, Could you please check the mappings of the import. I want to make sure that you are mapping the times and the line items correctly. 

 

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
ciara
Occasional Contributor

Hi,

Yes, Im using the that time line

ciara_0-1592776111820.pngciara_1-1592776201030.png

 

When I upload the DAT03 I get the error in my 1st post and when I run the import in the Action I get the error DAT03 can not be found

einas.ibrahim
Master Anaplanner/Community Boss

I’m confused.

if the import didn’t go through (has eeeor) then what action are you running?

you have to make sure the mappings are correct so the import is excused correctly and hence the action is correct.  

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
ciara
Occasional Contributor

Sorry I meant the Action wont run. I just tried it to see.

 

The import from Data hub to supply chain gives the following. 

ciara_2-1592809043019.png

 

 

abhi1017
Super Contributor

Hi Ciara,

 

abhi1017_0-1592812960380.png

Try changing the highlighted to column 1: line items from fixed line item.

Line items should match automatically.

 

Hope this helps.

~Abhi

ciara
Occasional Contributor

Hi, thanks for getting back, that doesnt seem to work wither

ciara_0-1592815863272.png

 

abhi1017
Super Contributor

 

1. Post mapping column 1 to line items check the whether the line items are getting mapped in the DATA03 Historic Volumes lineitems in the import action, if not map it manually. 

2. Check the time dimension of the module you are importing into. (Need to use the time range created)

 

If still not successful, could you please share the screenshots of  each tab in the import action.

 

 

~Abhi