Criteria affecting overall system performance

SaraBTIT
Contributor

Criteria affecting overall system performance

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.

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: Criteria affecting overall system performance

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

View solution in original post

4 REPLIES 4
LipChean_Soh
Certified Master Anaplanner

Re: Criteria affecting overall system performance

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

View solution in original post

SaraBTIT
Contributor

Re: Criteria affecting overall system performance

@LipChean_Soh  thanks, that's really helpful : )

rob_marshall
Moderator

Re: Criteria affecting overall system performance

@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
Contributor

Re: Criteria affecting overall system performance

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