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: KPIStatus
Category: KPI
Description: The KPIStatus function returns the status for the specified KPI.
Syntax: KPISTATUS( «String Expression» )
Technet Link: MDX KPIStatus Function

The query below shows the KPIStatus for the Revenue KPI for all fiscal years. Included on the 0 axis is the KPIValue and KPIGoal

      {KPIVALUE("Revenue"), KPIGOAL("Revenue"), KPISTATUS("Revenue")} ON COLUMNS,
      {[Date].[Fiscal].[Fiscal Year].Members} ON ROWS
      [Adventure Works]
You will notice when the Sales Amount equals the Revenue goal, the value of the KPIStatus is 0. When the Sales Amount is greater than the Revenue Goal, the status is set to 1...and conversely, when the Sales Amount is less than the Revenue Goal, then a negative 1 is shown. The status value usually ranges from -1 to 1 with -1 meaning not good, 0 meaning ok, and 1 meaning good.


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