Using Dimensional Measures

Use dimensionalMeasure to perform calculations using a single dimensional measure. See dimensionalMeasure.

UsedimensionalChildren to perform calculations using the values of dimensional measures and their children. For example, a calculation you perform using the ItalianOffices measure in this dimension outline, is also applied to the Florence, Venice, and Rome child measures.

European Offices
- Italian Offices
  - Florence (child)
  - Rome
  - Venice

NOTE:

Data for child dimensions may be omitted from the Trending Table on reports if you aggregate results using this function in result formulas. For example, assume this dimensional outline:

APAC
- Australia
  - Sydney
- Korea
  - Seoul

Assume that you specify the following as the APAC measure result formula, in which Region is the name of the measure template: SUM(dimensionalMeasure(result, "Region", ["Australia", "Korea"]))

Because you cannot specify multiple child nodes in the same dimension in formulas, resolve this issue by adding the SUM of each node as follows:

SUM(dimensionalMeasure(result, "Region", ["Australia"])) + SUM(dimensionalMeasure(result, "Region", ["Korea"]))

See About Using dimensionalChildren.