Learn more about line item issues that might impact your model performance and the actions you can take to fix them.

Which line items don't need a summary?

When is this a problem?
When a new line item is created, a summary method is added by default. Many line items don't need summary calculations.

Why is this a problem?
Running unnecessary calculations can increase the time it takes to open a model.

How to correct
When creating a new line item, make it a habit to turn off summarizing. If a summary is needed, then turn the summary back on.

Related content

Are text-formatted line items overused?

When is this a problem?
Anaplan is optimized for numbers and Booleans.

Why is this a problem?
Text uses more memory than most other model components and doesn't perform as well as other data types. Text limits capabilities and impacts model size.

How to correct
When possible, convert text data to another data type. 

Related content

Are there more than 50 line items in a module?

When is this a problem?
When any module includes more than 50 line items.

Why is this a problem?
It goes against best practice to not include more than 50 line items in a module.

How to correct
Break up the module into separate modules, especially if any of the line items use subsidiary views.

Are there excessive subsidiary views?

When is this a problem?
Subsidiary views should be avoided for data that is used in calculations.

The following are the situations where a subsidiary view can be used (note that they all are related to how the data displays):

  • Show an attribute for end-user analysis, filtering, or sorting.
  • Show an alternative hierarchy for a dimension.
  • Display numeric values, such as ratios, that aren't needed for other calculations.
  • Filter reports or provide attributes for exports.

Why is this a problem?
Subsidiary views are hard to locate and audit in a model. If a line item with a subsidiary view is published to a classic dashboard, the data can't be edited.

How to correct
Think about adding a new module that includes the dimensions of the subsidiary view. 

Related content

Are there line items used as headers where the format isn't set to No Data?

When is this a problem?
Line items that don't follow this convention.

Why is this a problem?
Using line items as headers without the format set to No Data causes unnecessary calculations.

How to correct
Change the format to No Data to avoid unnecessary calculations.

Related content