Level 3 Model Building Sprint 2 Territory Data

Highlighted
Contributor

Level 3 Model Building Sprint 2 Territory Data

Hello,

 

Many of you have probably finished the Level 3 Model Building Certification. 

As I start Level 3, Sprint 2, I got confused with the below instruction:

jonathanpascual_0-1602243029876.png

My questions/clarifications:

 

1. In Sprint 1, the Level 3 Model is connecting with the Data Hub, and there was an option to download a New Data Hub or Use the Data Hub in Level 2 Model Building. I used the Data Hub in my Level 2 Model Building. There is no Territory List in Level 2 Data Hub. Where can I import the data? Do I have to create a new list for Territories in the Level 2 Data Hub? See screenshot below:

jonathanpascual_1-1602243235663.png

2. Do I really have to do it in the Level 2 Data Hub? It seems that it's already in the Level 3 Model itself, both in List and Sys module:

 

jonathanpascual_2-1602243438800.png

 

jonathanpascual_3-1602243588647.png

 

Thanks so much!

 

Jonathan

12 REPLIES 12
Highlighted
Frequent Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

Hi @jonathanpascual 

 

It is asked to create it in Data Hub why because the data should be feed from Data Hub to Spoke Model ( Sales Planning Model ) .

You can create list in Data hub (Flat) . and import it in the Spoke Model . 

Or else If the Data Hub is downloaded one , then you can directly import this Data in G3T Territory list in Spoke Model . 

Data flow should be Data Hub to Spoke Model .

 

Hope this helps.

 

Thanks,

Puneeth HP 

Highlighted
Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

Thank you.

 

I understand. 

 

I'm confused what would be the child/children of the G4 Territory>Accounts. Do we have the data to be uploaded for this? As you can see, this list is a numbered list and is a parent for A1 Accounts. But how do we know which Accounts are in each territory? Is there a data to be uploaded to accomplish this? For example, for territory US East, does it have ALL the accounts or just a few ones? And so on. How can we ensure the accuracy of the data? 

 

Thanks! 

 

Jonathan

Highlighted
Frequent Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

Hi @jonathanpascual 

 

Account to territory Assignment is not manual . And we are provided with data file to import to the G4 Territory>Account. 

Before doing that you will have all the training videos and setup to come at this data, is given in the training in further steps . 

Go through those and you will get a fair idea on how to proceed further . 

Hope this helps . Happy Anaplan !

 

Thank you,

Puneeth HP  

 

Highlighted
Occasional Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

I read through all the above and understand that a file will be provided later on assigning accounts to territories.  However, I am confused with the dimensionality of the Quota reports.  There are several accounts that role into single territories - so how would we go about updating the G4T Territory>Account list as well as the Account name in the 2.3.1 QUO01 Territory account validation module

 

@Puneeth H P

@jonathanpascual

Highlighted
Frequent Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

Hi @bleeds 

 

Since the List G4 Territory>Account# list is a numbered list , you would be importing Data in to list Property Display Name of the list . 

And in the module which is having Dimension of the G4e Territory>Account# list you can directly reference this Display Name property in the module for Account Name line item .(A1 Account list formatted line item ) 

 

Hope this helps.

 

Thanks,

Puneeth HP 

Highlighted
Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

@Puneeth H P 

@bleeds 

I believe I was able to do this by adding a line item in the SYS module that houses the accounts and importing the Sales Rep to Accounts data.. and using a SUM function by that line item... I was albe to get the Quota... I'm struggling now on the Length of Service and Tenure, I believe the other line items in there are dependent on those two so I can set a formula to get the correct data from the assumptions. 

Highlighted
Occasional Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

Appreciate both of the responses.  Was able to figure out the below!

 

I completed the length of service by subtracting the current period start date from the sales rep start date.  You have to go through the process of completing the QUO4-QUO 6 modules and converting the number value in the SYS07 module to text.

 

Let me know if that clears anything up?

 

Also @Puneeth H P  I am having trouble populating the Target amount in the QUO01 Territory Account Validation Module.  I'm currently attempting to pull the requisite data from the Final sales target amount column in the TAR02 Account review module.  However, either nothing populates or I'm receiving a dimensionality error.  The dimension of the QUO01 module is "G4T Territory>Account#"...The property of this numbered list is "A1 Accounts".  I've added the display name from the above list into the module as well as the SYS06 Territory Account detail module and still no luck.  Also added a time dimension to the target line item consistent with the time populating in the source module. 

 

Is the expectation for us to create a new module and re-load the Target data?  Any suggestion would be incredibly helpful. 

 

bleeds_0-1603199379811.png

 

Highlighted
Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

@bleeds it's because there is no year dimension in the QUO01 Module. If you're referencing the TAR02 Account Review module, also look at the SYS99 Lookups Module (you would need something there)

 

Let me know how it goes. 

Highlighted
Contributor

Re: Level 3 Model Building Sprint 2 Territory Data

@bleeds @sosunkwo @Puneeth H P 

 

Obviously, I did something wrong. But I'm not sure which part(s) I got wrong.

When I was building the model, my numbers were tying up with the "Check your Build" section.

But when the tech questions came along, I was surprised that I'm not getting the correct answers. 

This project was put on hold for me for now. 

 

Thanks!

 

Jonathan