Creating Sub Districts

Hi,

Has anyone experimented with having Sub Districts in their Territory and Quota Planning? For FY20 we have a new requirement to merge our North East District 2 and North East District 6 into one district: North East District 2. But, all vault accounts in the original North East District 2 will become sub district North East District 2a and all vault accounts in North East District 6 will become sub district North East District 2b. Does anyone have anything like this? Would love some thoughts and reccomendations? Our current FY19 structure calculates our quotas down to the District level only so will we need to calculate further down to the Sub District level?

Best,
Amanda

Accepted answers

All comments

kavinkumar

HI @aabalos,

In this case you can create 2 Sub-Districts and bring in the all related accounts as you mentioned. Creating Sub-districts are totally based on the business necessity cos in our case we have created Sub-ds as they want to see the Quota roll up at Sub- District Managers level.

Creating Sub Districts.PNG

And we do have some reports (Dashbaords) at Sub-d level. I know it leads to some more additional enhancement in your model but this will help users to see granular level figures.

Regards,

Kavin.

ChrisAHeathcote

@aabalos

Hi,

Could this not be solved by amending the current hierarchy? This would create a direct relationship across districts and sub-districts.

If this is not possible then an alternative method of establishing the relationship/mapping is required.

You will have to create a new list at the high level and create a mapping module with the lower level as the dimension and the higher level as a list formatted line item ( assign the new list to this line item ).

Select the new list member as the correct mapping and use this module to aggregate your values when creating your reporting modules.

I would recommend trying to adapt your hierarchy instead of the manual mapping approach. An updated hierarchy will ensure that your aggregations roll up logically and will not require you to create aggregation formulas every time you need to report at the higher level.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…