Eliminating Sparsity

Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are not used. The trick is being able to identify and combat these cells in existing models as well as preventing them when building new.

Course Objectives: By the end of this class, you will:

  • Identify sparse cells in existing models
  • Think critically when building new models to keep sparsity at a minimum
  • Utilize line item components such as Applies to, Formulas, Summary, Versions, and Time to reduce sparsity
  • Analyze which dimensions are necessary in a module and which could be removed
  • Write formulas which allow you to eliminate other line items or dimensions
  • Understand how numbered or subset lists can be used to reduce sparsity

The course will take about 10-20 minutes to complete.

Start the course here.

Answers