Criteria affecting overall system performance

[SaraBTIT]

We're trying to optimize our Anaplan system performance, except the adoption of user list as dimension, type and format of formulas, amount of actions, does a nested grid with lots subsidiary views affect the performance?  see below comparison: 

• A:  10 separated modules, each module has its own dimensions, each module got 100 line items. Those line items are being referenced amount the 10 modules. Different user log in different module.
• B:  1 module containing 10 different subsidiary views, total 10*100=1000 line items in one module. All users login the same module. 

Note: A and B have the same functionalities.

Compared with A, does the B solution impacts performance much when 50 users are logging into the one single module and operating some data inputs?  

Thanks in advance.

[LipChean_Soh · Accepted solution]

Hi @SaraBTIT 

At a model calculation level, there's no difference between A and B.

However there is a difference when user views the data in a dashboard (B's performance is worse than A), since there's a possibility that you're showing more line items in B than is needed.

Besides performance, B doesn't follow the DISCO methodology and according to PLANUAL, we try to avoid subsidiary view unless it's used for display, filtering, export, sorting, conditional formatting purposes.

Thanks,

LipChean

[SaraBTIT]

@LipChean_Soh  thanks, that's really helpful : )

[rob_marshall]

@SaraBTIT 

Take a look at this "checklist" for help in optimizing your model.

https://community.anaplan.com/t5/Model-Optimization-Checklist/tkb-p/model-optimization

Rob

[SaraBTIT]

@rob_marshall  thanks Rob, it helps a lot on our performance evaluation! 👍