Level 2 Sprint 3 INV01 Beginning Inventory - Import from DataHub

Julia2020

I have issue to import Beginning inventory from DataHub view to Supply Chain DAT01 Beginning Inventory module. Loading process has no issue to complete 371 lines, but when I check module, it only imports first Location - Country list. All location sub in DataHub and supply chain list are matched. So Frustrated, Please help!

Accepted answers

All comments

bhatjaved

@Julia2020 can you share screen shot of error you are facing ?

Julia2020

after I import data, it only bring me one country location, missing others.

bhatjaved

@Julia2020 is your code populated for all the locations in data hub view ? check that pls also share the screen shot of SYS07 build location view module

Julia2020

DataHub and supply chain both location list has it 's code filled, and SYS07 also.

bhatjaved

@Julia2020 looks like your list is populated can you show me blueprint view of DAT01 module ,you would need to use subset of G3 location list as- your dimension here.

Julia2020

bhatjaved

@Julia2020 I suspect you are missing hierarchy levels here , please check if you G3 list is parented by G2 and g2 is parented by G1 and G1 got top level as ALL regions - screen grab below

Julia2020

see both datahub and supply chain have parent hierarchy list already

sobaid

There issue could also be due to mapping, please share the screenshots of your mapping

Julia2020

run this import process without errors to complete total 371 lines, but strange thing is location mapping only coming out one location here.

Julia2020

Thanks for your big help ! The issue is my Select Access blocked.

sobaid

You mean you had selective access enabled on Location list by mistake?

Julia2020

yes, I set select access list under my user id for only one location. After remove that, I can import all locations. Thanks for you help !

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…