The location and segment for each of the accounts is not populated in the starter model and this information is not in the data hub either.
Did I miss an upload in the L2 build? I am currently trying to map accounts to countries in order to calculate the detailed account targets.
Go to Solution.
It should be there in SYS02 Account Details Module in L3 Model
@Nick_Ennis Awesome! Happy Modelling
The data is available in the model already.
1. Use SYS02 Account Details module for mapping country and segment to the Accounts in the TAR 02 Account review module.
(Note: Time dimension is not required while populating data for country and segment, from SYS02 Account details)
2. To calculate the detailed account targets:- create a separate module with dimension of Segment and G2 country lists and use SUM to pull targets data from TAR 02 Account review.
Hope it helps.
I am struggling to understand what I need to do for this activity.
I created a module with G2 Country and Segment dimension but I am not able to populate this module.
Am I missing something ? Attached screenshot
Is this what the activity is asking for?
The Final Sales Target field will not have data in it until the next user story. Try including a line item for the Initial Account Sales Targets field in addition to the Final Sales Targets field, just to make sure your logic is working right.
If you set the time dimension in the TAR04 module, the result is 0. It looks like the SUM doesn't aggregate across the timescale. Any clue why?