Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 
Microsoft SQL Server Analysis Services Function Page
Function Name: KPIValue
Category: KPI
Description: The KPIValue function returns the value for the metric that is the basis for the KPI.
Syntax: KPIVALUE( «String Expression» )
Technet Link: MDX KPIValue Function




The query below shows the KPIValue for the Revenue KPI. If you look at the value expression for the Revenue KPI, you will see that it maps to the Sales Amount measure.
 

SELECT
      {KPIVALUE("Revenue"), [Measures].[Sales Amount] } ON COLUMNS,
      {[Date].[Fiscal].[Fiscal Year].Members} ON ROWS
FROM
      [Adventure Works]
 
 

 
 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com