1. Calculation functions
  2. All Functions
  3. Compound Functions

These are complementary functions that are frequently used together for efficiency: Poorly constructed compound functions will impair performance and can cause your model to stop working. The common compound functions are shown here, along with tips on implementation.

Name Description
SUM & LOOKUP First it sums based on a list-formatted line item or property in the source, then looks up a value from a source module using one or more mappings.
SUM & SELECT First it selects a specific item from one or more of the hierarchy lists, then it sums values based on a list-formatted line item or property in the source that matches a dimension in the target.
SELECT & LOOKUP Selects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.