About Using dimensionalChildren

Use dimensionalChildren to perform a calculation, or use the values of all child measures belonging to a higher-level dimensional measure.

DimensionalChildren has this syntax:

dimensionalChildren(attribute, “template”, [“dimension1”, “dimension2”...])

Replace the placeholders with this information:

Attribute: Specify the kind of measure value, such as result, to use.
Template: Specify the name of the template that generates the dimensional measures you want to use.
Dimension1: Specify the name of each dimension that generates the dimensional measures to use.

For example, assume an organization has sales offices in Europe and North America. The number of sales (Revenue) each office makes is tracked using a Revenue template, a Product dimension, and an Office dimension. To identify the office that makes the largest number of sales, you could use this formula:

MAX(dimensionalChildren(result, “Revenue”, [Office”, “Products”]))