User List Formatting Performance Issue

Options
RobinSilk
RobinSilk Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

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!

Tagged:

Comments

  • RobinSilk
    RobinSilk Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    Per your boolean idea, how would you be able to filter it in order to know who created the adjustment? Would this mean dimensionalizing the line item by the users list or something?

  • RobinSilk
    RobinSilk Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    There would be over 1200 users with access to the model. Unsure how many would need access to the adjustment creation functionality but it would be easier to not make some sort of quasi "subset" of adjustment creators. I do see what you have in mind, though, and will think it through.


    As far as the number of adjustments, there is no set list length. It needs to be able to grow to any size - potentially thousands but unsure.

Categories