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




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

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

 
 

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