Sort by:

## How to use the SUM function

Summary: When building Anaplan models, the SUM function is used to add up values that meet one or more specific criteria.  Find out how to construct a formula using the SUM function in this short lesson. Course Objectives:   By the end of this lesson, you’ll be able to: Identify source and mapping cross reference data to use with SUM Use the proper syntax to write a formula to calculate SUM Identify when a User Story calls for an output that will use the SUM function The course  will take about 15-30 minutes to complete.   Prerequisite: Basic understanding of model building in Anaplan • Lists • Modules • Formula Bar   Click to Launch Course

## Effective Dating (311)

Use of effective dating addresses the basic challenge of recording the dates when a change is made in the system. To use an HR example, recording when an employee transfers from one department to another. Other examples include contract renewals, territory assignments, and compensation plans. Essentially, any change that you want to be able to document and record a history of when that change happened, requires effective dating. After completing this course, the learner will be able to: Explain when is an appropriate time to use effective dating techniques and why they are important Utilize start, end, and transfer dates to create effective dating formulas Create an Action to sync employee information Have the system properly attribute resources to the correct hierarchy, such as the employee's salary to the correct department Write formulas to calculate headcount This class will take approximately 17-20 minutes to complete.   The model blueprint is also attached to this article. Launch Training

## 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.

## Reducing Model Size – Introduction to Sparsity

Summary: Unnecessary model size has a large impact on your Anaplan environment from using valuable space to slowing down key processes. Sparsity is one of the biggest causes of inflated models. Understanding what sparsity is and how it impacts a model is the first step in knowing how to reduce it. Course Objectives:   By the end of this class, you will: Define concepts such as storage capacity and workspace memory Differentiate between model, module and line item sizes Contrast the differences between spaces cells and dense cells Explain how sparsity is measured in a model The course  will take about 5-10 minutes to complete. Start the course here.

## Hub Model Hierarchy Management (305)

This class gives the Anaplanner the fundamental steps to automate a hierarchy load from a Hub model to a downstream model.  This training is intended for Anaplanners wanting to automate loading hierarchies/lists.  You should have a good understanding of modules, views, actions, and processes before taking this training. After completing this learning you will: Understand the architecture of hierarchy management from a Hub model Utilize best practices in this process Use the Anaplan Connect Wizard to import data from an outside source into Anaplan This class will take approximately 20-21 minutes to complete.   Launch Training