L3 sprint 2 2.3.1 QUO01 Territory Account Validation

Ssudilovsky · 2023-02-28T22:59:32+00:00

There was an error rendering this rich post.

Ssudilovsky

Hi everyone,

I am a bit confused and have been stuck for a while, how to approach the

line :" Assigned>1?: Is the account assigned to more than one territory? "

also, what is the purpose of "cf_account" line?

which modules should I reference? any ideas?

Thank you!

Accepted answers

All comments

AjayM

Hi @Ssudilovsky ,

Assigned>1? should give you TRUE if the count of territories each account is assigned to exceeds 1. For this you first have to count number of territories each account is assigned to, at account level (a SUM by A1 account). And then you would verify if this count is greater than 1, at G4 level.

cf_account will be used on UX page to apply conditional formatting ("cf") for those accounts which satisfy Assigned>1? condition. You would highlight those accounts in some color if they are assigned to more than one territory.

Hope this helps you in making progress.

Cheers!

Ssudilovsky

@AjayM Hi thanks for responding, I guess I don't understand how a child (account) can be assigned to more than 1 parent (territory). is “Candyonse” the only account that needs to be flagged?

Thank you!

AjayM

Hi @Ssudilovsky ,

Account to Territory assignment is done using numbered list and that's how you are able to assign same child to more than one parent. By the end of user story 2.5, you should be seeing only one account “Candyose” assigned to more than one territory.

Cheers!

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…