MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1046

See also: CalculationPassValue (), iif ()

CalculationPassValue ( numeric expression , pass number [, flag ]) Returns:
number

Extension: AS2005, AS2000

CalculationPassValue ( string expression , pass number [, flag ]) Returns:
string Extension: AS2005, AS2000

This function evaluates the given expression at the calculation pass iden-
tified by pass number and returns the value to the current calculation
pass. If the flag is specified, it may be one of the following:

FLAG DESCRIPTION

The pass number is the absolute number of a pass (starting
from zero). If you refer to a pass number that is higher than
the currently executing pass, you will begin invoking the high-
er numbered pass for the cells that are referenced in the ex-
pression if they have not already executed that pass.

ABSOLUTE

This indicates to take the value from the pass that was pass
number passes later. A negative pass number will refer to an
earlier pass, and a positive pass number will invoke a later
pass. A pass number that would refer to a pass earlier than
pass 0 will silently cause a reference to pass 0.

RELATIVE

Note that in AS2005, passes for session-scoped cell calculations (created by
CREATE CELL CALCULATION) and those for query-scoped cell calculations
(created by WITH CELL CALCULATION) are separated, so that query, ses-
sion and global passes (from MDX scripts) cannot refer to calculations in
each other.

See also: CalculationCurrentPass (), iif ()

Call UDF-Name ( [ arguments ] ) Returns: Void or rowset Extension: AS2005,
AS2000