-
What dimensions are used in the module? Are they all necessary?
When is this a problem? This is a problem when you have unnecessary dimensions—meaning that the logic or data in the module does not apply to the dimension. Why is this a problem? Unnecessary dimensions in a module could cause poor performance from a formula having to perform unnecessary calculations and increasing the…
-
What time dimensions are being used in the module? Can a Time Range be used?
When is this a problem? This is a problem in models where the time requirements of the module differ from the Model Calendar. This could mean that the year requirements are outside of the model calendar or do not need all of the years in the model calendar. It is also a problem to include unnecessary time summary settings.…
-
Are the dimensions in order?
When is this a problem? This is a problem in all models. During a model build, lists are organized in the way that they are added. Why is this a problem? Through research, we discovered that dimensions that are not in order can make the engine work harder. How to correct: On the Modules pane (Model Settings>Modules) look…
-
If there are any saved views, do they use the correct filtering?
When is this a problem? This is a problem when saved views use multiple filters per tab. Why is this a problem? Multiple filters on a tab can cause performance issues. The data is read for the first filter, then those results are read for the next filter, etc. How to correct: Filters should be set up using Boolean values…
-
If there are saved views, are all of the line items in the view necessary?
When is this a problem? This is a problem when the view includes line items that aren't needed. Why is this a problem? The extra line items can impact performance because the view has to render the extra line items. For example, if three line items are needed, but 25 line items are defined, performance will be impacted.…
-
Is the default view clean?
When is this a problem? This is a problem when the default view has filters applied, hidden list or line items, or includes conditional formatting or sorting. Why is this a problem? The default view of the module should always be a blank canvas for any model builder to modify. The expectation is that nothing is hidden or…