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