dimensionalMeasure

Use dimensionalMeasure to perform calculations using the values of one dimensional measure or child measures in an outline. For example, you could use this function to perform calculations using only data for the Venice measure in this outline:

  To use dimensionalMeasure:

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

  2. Select Application Data, thenDimensional Data, and double-click dimensionalMeasure.

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

    This inserts: dimensionalMeasure(attribute, “template”, [“dimensional member1,” “dimensional member2”...])

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

  5. Replace dimensionalmember1 and dimensionalmember2 with the names of the dimensions used to generate the dimensional measure to use.

    Note:

    If the measure is generated using only one dimension, delete the dimensionalmember2 placeholder. If the measure is generated using more than two dimensions, specify each dimension.

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

    For example, this formula finds the highest product revenue result gathered by the Venice dimensional measure:

    MAX(dimensionalMeasure(result, “Revenue”, [“Venice”, “Products”]))