Calculated Measures

Type of measure function that you want to perform.

You can either create the calculated measure by using the existing functions, such as, Difference or Contribution in the interface, or write custom MDX by selecting the Custom function.

• Contribution

  A calculation that determines the contribution per portion for different factors. For example, you can calculate the percentages from different categories from total cost, such as maintenance, repair, and lost opportunity.

  When using a contribution calculation, you can choose to evaluate the improvement opportunity for a particular family in comparison to all other families. An "improvement opportunity cost" means the potential for saving money if a particular factor is properly evaluated to prevent failures and downtime.

  On selecting the measure type Contribution, the following fields appear.

  • Measure
  • Dimension Hierarchy

• MDX Query

  You can create custom measures using the MDX query in the Expression box.

• Difference

  A calculation that involves the subtraction of one member from another to compute a value.

  A value expression can be used to evaluate overall repair cost and the costs within a site.

  For example, the difference in a repair cost can be compared between all repairs for a site and then all repairs for a particular piece of equipment. For this type of calculation, you would type in the [Measures] dimension and then the measure Cube, [Site Repair]. Note that when calculating the difference in a repair cost column, drilling down the hierarchy will automatically calculate the difference.

  On selecting the measure type Difference, the following fields appear.

  • First measure
  • Second measure

   

The measure for which you want to create the contribution.