Level3. Territory>Account module

Gharbali
Gharbali
in Modeling

Hello,

I created a module in Data-Hub to transfer the territory>account to Sales Planning model in a numbered format to use as a dimension. However, I am pretty sure that something is incorrect with my module cause all the accounts listed in each territory repeatedly. Any idea what is wrong here?

Screenshot_6-11-2024_14153_us1a.app.anaplan.com.jpeg
Screenshot_6-11-2024_14139_us1a.app.anaplan.com.jpeg

Thanks,

Best Answer

  • Gharbali
    Gharbali
    Answer ✓

    I imported the CSV file given in the Sprint 2 into SYS16 and I think it will resolve my issue. I will write you back if there is an issue.

    Thanks.

Answers

  • Dikshant
    Dikshant

    This is the cross section of territory and account list, so the same account will show for all territories and hence it's repeating. You code to Use line item is unique as it's a concatenation of both Territory Code and Account Code.

  • Gharbali
    Gharbali

    @Dikshant

    Thank you for assisting me here. However, if SYS16 Create Territory>Account module is correct, by importing data into Sales Planning model G4 Territory>Account#, I see all the accounts in all territories

    Screenshot_7-11-2024_8833_us1a.app.anaplan.com.jpeg

    which is messing my SYS07 Account>Territory Details because it shows all the accounts in all the territories.

    Screenshot_5-11-2024_8291_us1a.app.anaplan.com.jpeg

    Any advise?

Categories