2.2.5.3.11 OLAP Calculated Members

  • Article

A calculated member (2) is specified by the sequence of records that conform to the SXADDLCALCMEMBER rule (section 2.1.7.20.5) and is used to create an OLAP calculated member or an OLAP named set with an associated user-specified MDX expression for a custom calculation.

If the fLongFormula field of the SXAddl_SXCView_SXDCalcMember record (section 2.4.273.100) is equal to one, then the stMDXFormula field of the SXAddl_SXCView_SXDCalcMemString record (section 2.4.273.101) specifies the user-specified MDX expression. If the fLongFormula field of the SXAddl_SXCView_SXDCalcMember record is equal to zero, then the stMDXFormula field of the SXAddl_SXCView_SXDCalcMember record specifies the MDX expression.

The fSet field of the SXAddl_SXCView_SXDCalcMember record specifies whether the associated calculated member (2) creates an OLAP named set or an OLAP calculated member.

If the user-specified MDX expression associated with a calculated member (2) defines an OLAP measure, then this calculated member (2) is associated with a measure pivot hierarchy (section 2.2.5.4.5) as specified in section 2.2.5.4.5.2.

If the user-specified MDX expression associated with a calculated member (2) specifies an OLAP member in an OLAP hierarchy other than the OLAP measure hierarchy, then this calculated member (2) can only be associated with a cache item (section 2.2.5.3.6).

If a calculated member specifies an OLAP named set, then this calculated member (2) is associated with a named set pivot hierarchy as specified in section 2.2.5.4.5.4.