Import Shipping Expenses into OTH01 Module

katarina129

Hi everyone,

I'm still struggling with the import into the FP&A model (Level 2 Conclusion)

Here's the mapping I have had:

And here is the error I have got:

2021-06-09 (5).png

Here's how my INV05 Shipping Export module looks like in a Blueprint mode:

2021-06-09 (6).png

2021-06-09 (7).png

Is there any chance someone could help me, please?

Accepted answers

Vinay VaradarajM

Hi @katarina129 ,

The source view consists of summary level items as well, as can be seen in your screenshot (All regions, Americas etc), which is one of the causes for failures. You might want to use the 'select levels' in the source, and only include lowest level items (which is want you want to import).

This way you can get rid of the error.

Regards,

vinayvm

All comments

Vinay VaradarajM

Hi @katarina129 ,

This way you can get rid of the error.

Regards,

vinayvm

katarina129

Thank you @Vinay VaradarajM - it has worked!

JosAngel94

@Vinay VaradarajM

Hello, i have this same issue,

My saved view includes summaries but i can´t find the option of 'select levels' in the source that you mention to remove them. Can you help please, TY.

Vinay VaradarajM

@JosAngel94 : You can right click in the area where List items are shown on the left hand side, and it will open a menu of options where you can find 'Select Levels' or 'Reselect Levels' (if something is already selected)

Example:

Screenshot 2023-03-09 at 10.22.04 AM.png

In your case:

Screenshot 2023-03-09 at 10.22.52 AM.png

Regards,

vinayvm

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
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…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…