Level3. Territory>Account module

Hello,

I created G3a Territory in Data-Hub rolled up to G2 country. And loaded with Territory Data via CSV file that has been provided in the sprint 2. I created a sys module with a dimension of G3a Territory and Account to create the needed info for Territory and Account# in the Sales Planning Model. However, I see some data discrepancy in the Data-Hub module:

Screenshot_4-11-2024_15513_us1a.app.anaplan.com.jpeg

as you see, Account Country is UK but the territory shows US East. What am I doing wrong here? Please advise.

P.S. here is the blueprint:

Screenshot_4-11-2024_151841_us1a.app.anaplan.com.jpeg

Thanks

Accepted answers

Dikshant

SYS16 Territory Code is Blank as you are using LOOKUP based on country.

Just simply write CODE(ITEM('G3a Territory'))

All comments

Dikshant

SYS16 Territory Code is Blank as you are using LOOKUP based on country.

Just simply write CODE(ITEM('G3a Territory'))

Gharbali

Hello @Dikshant

Thank you for assisting me here. I have follow up concerns. I cleaned up my SYS16 modules to reflect correct formula and info. I imported the data into my G4T Territory>Account# in Sales Planning Model.

I am checking SYS07 Territory Account Details. I noticed some account's countries are other than US but the territory shows US East which can't be correct. any advice?

Screenshot_5-11-2024_8291_us1a.app.anaplan.com.jpeg

Screenshot_5-11-2024_82949_us1a.app.anaplan.com.jpeg

P.S. What Code Import represents?

Thanks,

Gharbali

Hello @Dikshant

Any idea what does "Code Import" represents?

Dikshant

I don't see it's used anywhere. Feel free to ignore this line item

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385