Each of the Anaplan calculation engines is designed for models with different densities of data. Polaris is designed as a natively sparse calculation engine, so is well-suited to sparse data sets.

Dense models are models where most cells are populated. Sparse models are models where most cells are NOT populated.

A populated cell within Polaris is a cell with a non-default value. The default values for the different data types are:

  • Number: 0
  • Boolean: FALSE
  • Date: Blank
  • Time Period: Blank
  • List Item: Blank
  • Text: ““ (an empty string)

Data in Anaplan models is stored in modules in hierarchical lists and line items. Lists and line items are used as dimensions in a module. See the example below:


APACAMEREMEA
Product cost125.00087.45
Sale price135.00092.50
Quantity sold1,1560897

In the Classic engine, this data is stored as an array and is dense. This means that every cell requires memory, regardless of whether it's empty or not. Each cell in the Classic engine uses 8 bytes of memory, whether it contains data or not. So the example above would use approximately 72 bytes of memory, as it contains 9 cells.

The example below is more suited to Polaris as it has more empty cells:


APACAMEREMEA
Product cost0087.45
Sale price0092.50
Quantity sold000

In Polaris, map-based storage with keys is used instead of an array. This means that only cells that contain data consume memory. Empty cells do not consume memory. However, each cell that contains data in Polaris uses 24 bytes of memory for numeric cells. So the example above would use approximately 48 bytes of memory, as it contains two cells with data.

You determine the calculation engine at the workspace level, so consider the general composition of all data within a workspace when understanding the memory efficiency.

Each cell in a grid in the Classic engine uses 8 bytes of memory, whether it contains data or is empty. Only cells that contain data in Polaris use memory – 24 bytes each for numeric cells.

Which engine is more memory efficient depends on overall density:

  • When more than 33% of cells contain data, the Classic engine is more memory efficient
  • When fewer than 33% of cells contain data, Polaris is more memory efficient

You can check the effect of formulas upon sparsity when you configure line items. This information is in the Populated Cell Count, Memory Used, and Calc Complexity columns. Learn more about the potential effects of formulas upon sparsity.