TOPARENTLIST modifier

Description

Converts a Subset Dimension into its Parent Dimension.

Each Item in the Subset is naturally mapped to the corresponding Item in the Parent List. Any Items in the Parent List that are not included in the Subset return a blank value.

ℹ️ Note
Because this Dimension modifier maps data 1:1 and neither aggregates nor allocates data, it does not require you to specify an aggregator or allocator in the syntax.

Syntax

Expression[TOPARENTLIST : Subset]

Expression: Any valid formula expression that is currently dimensioned by the Subset.
Subset: The specific Subset Dimension you are converting to its Parent Dimension.

Return type

same as expression return type

Example

In this example, we have a Parent List called Country and a Subset of that List called EMEA Country.

We want to take a Metric called EMEA Sales Target (which is dimensioned by the EMEA Country subset) and convert it so that it is dimensioned by the full Country list instead.

Dimensions Setup: