User List Formatting Performance Issue

RobinSilk

Hello,

 

We currently have a model built out with functionality to create "adjustments"; these adjustments have a line item that is dimensionalized by the Users list. The idea is to track who has made which adjustments, and figured that the users list is the best way to do this.

 

We currently have 2 versions of the model - UAT and PROD. UAT has almost 1200 Users in it, while PROD has 124. We expect PROD to reach (and potentially eclipse) the UAT number at some point. Testers have reported performance issues in the UAT model when trying to make a selection with this line item, even to the point that the model will time out.

 

Are there known performance issues for line items dimensionalized by Users when the users list reaches large numbers? Trying to determine the root cause here, and if its an Anaplan bottleneck or something external. For reference, testers have reported this while using Google Chrome.

 

Thanks!

rob_marshall

@RobinSilk 

 

I am not sure you want to go down the Users route with this because essentially you are blowing up the size of your model, especially with the number of users you are talking about.  Silly question, can you create a boolean that user clicks to enter an adjustment, and then filter on that boolean to figure out who did an adjustment?

 

To answer your question about performance, there shouldn't be a hit as it acts like any other list, but there are some things you need to think about:

• as stated earlier, your model is going to **** up in size
• when playing with users and inputting data, it is difficult to get data out due to security around the Users list
• When using Users, every time a new person is loaded into the system, your model is going to get bigger

Usually when using Users as a list in model, it is for reporting purposes and not for inputting data so I would attempt to move away from using Users in this case.

 

Hope this helps,

 

Rob