ANAPLAN Optimization for N users

PratyakshDua01

Hi ,

If we have users of around 10000000 in Sales team and we are using that list (Users) in one module so how can we optimize the structure of module as if that module page is published in Dashboard then it will take time at great extent to open and to load so how can we optimize the page of dashboard so that the user once logged-In will get memory allocated and once he/she log out the allocation must get remove so that the module will have space allocation only for current users logged in . 

AlejandroGomez

At this point, I am joining  @nathan_rudman in the request for more details:

 

• are we speaking about a module (or modules) using the user list as dimension? and therefore, ending up with a huge module given the size of the users list in combination with the other dimension of the module.  If this is the case, what are there other dimensions in these modules? Are you using the built-in user list or a dummy one?
• or are we speaking about concurrent usage of the model by thousands of users at a time, causing some performance issues?
• or both?

Also, a few considerations

• if the list of users is not being used in a module, it is unlikely to impact the size of the model. The performance could be affected by the number of users using the model concurrently and there is no solution to that other than a model  built according to best practices
• if the users list is part of models dimensions, then there is no way (to my knowledge) to cherry pick which users (or items of a list for that matter) get memory and which not. Anaplan recalculates the entire model when opening it for first time and every time something changes in it, so that means that all the items in all the modules "have memory allocated to them" in order to be recalculated.
• The only workaround I can think of is to manually set the Role of these users not being used to "No access" or, if is a  dummy list, use a Subsets (but this might lead to other challenges such as potential data loss when removing items from the subset..

then again, these are just ideas or considerations that I think may be related to your question and hopefully are of help, but since I fail to see the exact issue here, I cannot point my finger on a specific solution. 

rob_marshall

@PratyakshDua01 

 

Ok, I will play...You sure about that number, 10 million users?

 

Rob

AlejandroGomez

Wow! Congrats to the Account Executive who won that customer with 10 million users 😮 

 

Now, the few suggestions that I have for you given the information that you have shared are:

 

1. If that is really the built-in Anaplan User lists: you can switch off the option "Show all users", so each user will see only him/herself instead of the whole list of users in the page dimension.

2. If the users list is a regular list, you can set "Selective Access" on that list. Then, in the users tab of your model, assign a user from the regular list to each user of the real Users list (you can even create a module that matches every real users with the "dummy" user list and then import the permissions into the Users Tab):

 

3. If your users lists is some sort of a data base of customers of your company (I am trying to rationalise the 10 million users' list here...) you could either create subsets, a parent list for grouping these users (aka Customers) per Sale Rep or region and assign Selective Access on that segmented parent list...

 

Please, let us know if any of the tips above helped you with your challenge.

 

Regards,

Alex 

AlejandroGomez

I am not gonna lie, this got me puzzled as well 😄

PratyakshDua01

Hi Alejandro,

Thanks for putting your concern over the issue but is there any way we can optimize the space allocation of such amount of users because it will gradually going to affect the performance if we allocate 10 million users to list and by giving selective Access space is not going to reduce as at a time say only 10,000 users will log in so we can have the memory allocated to only such amount of users and when other users log - in then space gets allocated to them .

Thanking you in anticipation.

Regards,

Pratyaksh

PratyakshDua01

Hi Rob,

Thanks for asking,Yes I am sure about the number😊.

 

Regards,

Pratyaksh

 

nathan_rudman

In 99.9 % of the cases, the number of users doesn't impact the size of a model.

Only when using that list of users in a module, usually in order to filter that module per user, does it allocates space per the number of user (this is what Alejandro is showing you).

Is that you issue here ? 

 

So what are you other dimensions ?

Because if we are just talking about users, then 10 millions cells only is nothing for Anaplan.