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

tion return a value normalized between -1 and 1, although there is no
technical requirement that you do so. The KPI_Name is a string expres-
sion.
KPIValue ( KPI_name ) Returns: member Extension: AS2005
This function returns the member that calculates the value of the KPI
named KPI_name. The KPI_Name is a string expression.
KPIWeight ( KPI_name ) Returns: member Extension: AS2005
This function returns the number that calculates weighting of the contri-
bution of the KPI named KPI_name to its parent KPI. To conform to the
conventions used in constructing the KPI graphic images, you should try
to have this function return a value normalized between -1 and 1, al-
though there is no other technical requirement that you do so. The
KPI_Name is a string expression.
L
member .Lag ( index ) Returns: member Standard
.Lead () returns the member that is index number of members after the
source member along the same level, and .Lag () returns the member that is
index number of members before the source member on the same level.
.Lead (0) and .Lag (0) each result in the source member itself. Lagging by a
negative amount is the same as leading by the positive quantity and vice
versa. Figure A-24 shows examples of .Lead () and .Lag ().