Using dimensionalChildren

  To use dimensionalChildren:

1. Ensure that you are modifying the template that generates the dimensional measures to use.

2. Select Application Data, thenDimensional Data, and double-click“ dimensionalChildren”.

3. Select the template that generates the dimensional measures to use from the Select Template box.

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

4. Replace attribute with the value, such as score, to use.

5. Replace dimension1 and dimension2 with the names of the measures to use, and whose children to use.

6. Place the cursor before dimensionalChildren and insert the operation or function to perform.

   For example, this formula uses the average score of the dimensional measures and their children to track the revenue of each Italian office:

   Average(dimensionalChildren(score, Revenue, [Italy, Products]))