Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2

Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2

While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly.

why? because:

It is the reason that region flat has 3 line items: AMER, EMEA, APAC.

However the csv DATA file attributes the regions as AMERICAS, EUROPE and PACIFIC

Tags

Importing and Exporting Data

Modeling

Calculation Functions

Data Integration

Accepted answers

how to fix?:

I found two options to fix:

1st and not recommended:

change the format from locationflat to 'text' at blueprint

so the obstacle while importing data will not encounter to the wall of format and will upload properly.

2nd and preferable:

change the excel data info by converting Americas, Europe and Pacific to proper format as AMER, EMEA, APAC

so this will pass the proper importing format.

I want to share my solution because there is no other entry for this topic,

hope this helps who needs

All comments

how to fix?:

I found two options to fix:

1st and not recommended:

change the format from locationflat to 'text' at blueprint

so the obstacle while importing data will not encounter to the wall of format and will upload properly.

2nd and preferable:

change the excel data info by converting Americas, Europe and Pacific to proper format as AMER, EMEA, APAC

so this will pass the proper importing format.

I want to share my solution because there is no other entry for this topic,

hope this helps who needs

Quick Links

Can you help?

Unanswered questions

Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…