Skip to main content

Items That You Can Use in Calculated Members and Measures

Items That You Can Use in Calculated Members and Measures

Via calculated members and measures, you can greatly extend your model without rebuilding any cubes. The following table summarizes all the kinds of model element that you can use within the definition of a calculated member or measure:

Item To Access This Item from a Calculated Member or Measure
MDX standard cube items (dimension, hierarchy, level, measure, property, calculated member, named set) Many options; see Using InterSystems MDX.
computed dimension* Use the dimension and member name to create a member expression that refers to the desired member, in the same way that you do for any standard member.
quality measure* Use the %QualityMeasure dimension to create a quality measure expression that refers to the measure.
KPI or plug-in* Use the %KPI function to refer to the value of a property in the KPI or plug-in.
term list*
  • Use the %LOOKUP function to return the value of a term list item.

  • Use the LOOKUP function to return a given field (the value field or another field), for a term list item.

  • Use the %TERMLIST function to create a set of members, given a term list pattern.

*These items are discussed in Advanced Modeling for InterSystems Business Intelligence.

The system does not provide a way to access a production business metric from within a calculated member.

FeedbackOpens in a new tab