Professional SQL Server™ Analysis Services 2005 with MDX

7.7. New MDX Functions

Analysis Services 2005 introduces several new MDX functions to facilitate data extraction from the UDM. The following table covers some of the functions and gives a brief description about their behavior for quick reference. Detailed information about these functions is provided in Appendix A. We recommend you learn more about the MDX functions used in MDX scripts with scenarios in MDX Solutions 2nd Edition by George Spofford et al. (Wiley, 2006).

MDX Function	Description
MeasureGroupMeasures(<Measure Group Name>)	This function retrieves all the measures within a specific measure group. Because the UDM can contain several measure groups, this function helps by making the query more specific.
EXISTS (<set>,<filterset> EXISTS(<set>,<filterset>,<measuregroup name>	This function is used to determine if tuples in the set exist with the tuples in the filter set. If yes, those tuples are returned. When the measure group argument is used, the measure group is used to determine the EXISTS operation.
KPI Functions - KPICURRENTTIMEMEMBER( "String Expression" ) KPIGOAL( "String Expression" KPISTATUS( "String Expression" KPITREND( "String Expression" ) KPIVALUE( "String Expression" ) KPIWEIGHT( "String Expression" )	KPI functions help in retrieving the values for the KPI, which help in displaying the status of KPI through KPI graphic icons. Some of these functions return normalized values between −1 and 1. All the KPI functions except KPICurrentTimeMember take the KPI name ...