L2 Model Building Conclusion: Failed Import into Shipping Expenses OTH01 Module

Hello Anaplan Community,

I've been stuck for too long trying to import the shipping costs from my Saved View into OTH01. I've tried numerous saved views but can't seem to resolve the errors. I've deleted all Saved Views and started over because I think I am confusing myself. Below are screenshots of where I am currently at.

Current Saved View: I selected "Shipping Costs" for Select Levels to show vs. hiding the Code line item. Note: I tried moving line items to Page Selectors so I can attempt to load by Code as well as resolve errors I am getting regarding dates but it's not working.

Below are screenshots of my mapping:

Note: mapped manually to resolve spelling issues with Montreal and Mumbai. Can't figure out how to load it by Code...I think this might be why I am having issues as the instructions say to load by code.

Error:

Any help would be greatly appreciated.

Thanks,

Heidi

Comments

JaredDolich

@HALY

Heidi,

Looks like your saved view from INV05 needs to be adjusted. Add a subsidiary view to INV05 for location code and add it to your saved view so it looks like this.

ShubhamCh

@HALY

If both objects, source view and target module have the same time dimensions i.e. months, use Match Names option in time mapping.

It'll fix the problem.

Thanks!

-Shubham

HALY

Thanks for your prompt reply Jared. I tried your proposed solution but I don't think it will help me achieve what I need. Please see the load with given the recommended SV.

SV:

Load:

HALY

Hi ShubhamCh,

I had already tried what you suggested with my original SV and it didn't work. I actually got another error (Invalid Line Item Identifier) Please see the screenshot errors.

I am really stumped on this one. Tried multiple Saved Views with multiple imports but am unable to resolve the errors. It should be straight forward but clearly I am missing something.

Error:

ShubhamCh

@HALY

Try mapping manually and ignore Code line item.

If error still comes, click on details and share the screenshot.

HALY

YAY that worked. Thank you so much! My brain was so fried staring at this for so long, I can't believe I missed that.

ShubhamCh

Glad it worked.😊

Next time if error comes and you want to post it on community. Post "Details" screenshot as well. It helps in understanding the error.

All the best for your L2 certification.

- Shubham

HALY

Will do and thanks again!

dpong8898

I've got to a point where I resolved all the errors like the one upstairs did to manually map Bombay and Montreal. But after the import, the numbers went to 0s and 1s, instead of bringing in the true numbers from Supply Chain Model. What did I miss?

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…