Hi all, I would like to create a hierarchy with 3 levels of lists: 1. Entity > 2. Direction > 3. Department. In the level "2. Direction", I want items to belong to several Entities. It is the same for Department level (a Department can belong to several Directions). I need to create a data hub and then a spoke model. In the picture below you can find an example of my problem: I don't really know how to populate my 2.Direction list in the spoke model. In my data hub, I've created 3 flat lists: Entity, Direction and Department. I don't know how to roll up my list 2.Direction into my 1.Entity list when it comes to the spoke model. I was thinking about using a numbered list for both Direction and Department in my spoke model? I don't know how I can export these items from the data hub to the spoke model (I can import them manually, but that is not the point). Thank you in advance for your answers 🙂
... View more
Hi, I am currently trying to grant access to my Regional Sales Excutive role for the Account Review DB. Reading user stories, I understood that Regional Sales exec could override or hold sales targets for each account in their countries (ie country located in the region they are responsible for). Since I only enable selective access for regions, I am currently able to override data for all accounts, even if they are not in my region. I know this is quite logical since I do not enable selective access for accounts. But my question is : is there a way to grant access to accounts to a regional sales exec, without adding each account in the users content panel ? Account list is not rolling up into the country list hierarchy so this is not automatic. I was thinking about adding a condition in my access driver module (for the target module) checking if the region of the account is equal to the region of the Regional Sales Executive (highlited in yellow on the picture below). How can I write the "current user. region" in Anaplan language ? Thanks by advance for your response.
... View more