Returns either the numeric or the string value of a Multidimensional Expressions (MDX) expression evaluated over the specified calculation pass of a cube.
If a numeric expression is provided, the function returns a numeric value by evaluating the specified MDX numeric expression in the specified calculation pass, and optionally modified by an access flag and an access flag modifier.
If a string expression is provided, the function returns a string value by evaluating the specified MDX string expression in the specified calculation pass, and optionally modified by an access flag and an access flag modifier.
This function is used in conjunction with IIf (MDX) and CalculationCurrentPass (MDX) in Microsoft SQL Server 2000 Analysis Services to handle recursion issues. However, with automatic recursion resolution in SQL Server Analysis Services, this function has little practical use.
Only administrators can use the CalculationPassValue function within an MDX script. An error occurs if an MDX script that contains this function is run in the context of a role that does not have administrator privileges.