Level 3 account details

[Nick_Ennis]

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.

[Misbah · Accepted solution]

@Nick_Ennis 

It should be there in SYS02 Account Details Module in L3 Model

[Nick_Ennis]

Thanks Misbah. I made a mistake with the account>product list which caused me to delete the account list (and therefore clear out this module!). I downloaded the starter model again.

[Misbah]

@Nick_Ennis  Awesome! Happy Modelling

[abhi1017]

Hi Nick,

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.

~Abhi

[BahalR]

Hi @abhi1017 

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?

[Stacey_Gibbens]

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. 

Good luck,

Stacey