Export (0) Print
Expand All

CalculationPassValue

SQL Server 2000

CalculationPassValue

Returns the value of a Multidimensional Expressions (MDX) expression evaluated over the specified calculation pass of a cube.

Syntax
Numeric

CalculationPassValue(«Numeric Expression», «Pass Value»[, «Access Flag»])

The CalculationPassValue function returns a numeric value, evaluating the MDX numeric expression specified in «Numeric Expression» in the calculation pass specified in «Pass Value», optionally modified by an access flag specified in «Access Flags».

String

CalculationPassValue(«String Expression», «Pass Value»[, «Access Flag»])

The CalculationPassValue function returns a string value, evaluating the MDX string expression specified in «Numeric Expression» in the calculation pass specified in «Pass Value», optionally modified by an access flag specified in «Access Flags».

Remarks

The behavior of the «Pass Value» parameter can change depending on the content of the «Access Flag» parameter. The following table details the access flags allowed in the «Access Flag» parameter.

Access flag Description
ABSOLUTE The «Pass Value» contains the zero-based index of a calculation pass.
RELATIVE The «Pass Value» contains a relative offset from the current calculation pass. If the offset resolves into a calculation pass index less than 0, calculation pass 0 is used; no error occurs.

Example
Numeric

The following example returns the value of [Sales] from calculation pass 0:

CalculationPassValue([Sales], 0)
String

The following example returns the full name of the [Sales] member from the previous calculation pass 0:

CalculationPassValue(MemberToStr([Sales]), -1, RELATIVE)

See Also

CalculationCurrentPass

Show:
© 2014 Microsoft