L3 Sprint 2 building the list: G4 Territory > Account#

Karthik31 · 2024-02-12T16:21:37+00:00

There was an error rendering this rich post.

Karthik31

Hi Community,

I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model

I followed below steps as per training

Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module created.
However, I am struck where how to build list G4 Territory > Account# in Spoke model (Sales Planning model) as there is one CSV in lesson 4.4 section with CSV name Download: CYW Scenario Territory to Accounts.csv used this CSV directly to build the list below is screenshot after loading this file directly into list.

Kindly Please provide your inputs as is this the above performed is right step or

do we have to prepare a saved view module with relation to Territory and accounts in Data Hub and then import that saved view to the G4 Territory > Account# list in Sales Planning model

Please request for cream layer hint to proceed further would be really helpful in proceeding further. as I am doubtful about the code in G4 Territory > Account# list which is reflecting in below screenshot

Territory_sys_module.png

Accepted answers

Tiffany.Rice

Hi @Karthik31 - L3 course can be very challenging and often times the instructions are intentionally less descriptive than previous courses. This is intended to simulate real life model building where requirements may be vague and we need to rely on our experience to build the best model. You will need to use your best judgement as this course is intended to test proficiency without external assistance (you were likely prompted to sign a pledge of independence at the commencement of the course).

That being said, a couple tips. It can be helpful to revisit your models from L1/L2 to refresh yourself on unicorn candy company. When I get stuck, I find it helps to step away and work on something else and then come back with fresh eyes/perspective as restart the task. Carefully reading requirements and analyzing the files to determine my model building approach.

All comments

Tiffany.Rice

Karthik31

Hi @Tiffany.Rice thanks much for the advice wherein revisited and refreshed on topics and was able to clear through with a fresh mind set by analyzing the model approach.

Tiffany.Rice

Glad to hear it, way to go @Karthik31!!!

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
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…