Level3. Territory>Account module

Gharbali

Hello,

I created G3a Territory in Data-Hub rolled up to G2 country. And loaded with Territory Data via CSV file that has been provided in the sprint 2. I created a sys module with a dimension of G3a Territory and Account to create the needed info for Territory and Account# in the Sales Planning Model. However, I see some data discrepancy in the Data-Hub module:

as you see, Account Country is UK but the territory shows US East. What am I doing wrong here? Please advise.

P.S. here is the blueprint:

Thanks

Dikshant

SYS16 Territory Code is Blank as you are using LOOKUP based on country.

Just simply write CODE(ITEM('G3a Territory'))

Gharbali

Hello @Dikshant

Thank you for assisting me here. I have follow up concerns. I cleaned up my SYS16 modules to reflect correct formula and info. I imported the data into my G4T Territory>Account# in Sales Planning Model.

I am checking SYS07 Territory Account Details. I noticed some account's countries are other than US but the territory shows US East which can't be correct. any advice?

P.S. What Code Import represents?

Thanks,

Gharbali

Hello @Dikshant

Any idea what does "Code Import" represents?

Dikshant

I don't see it's used anywhere. Feel free to ignore this line item