In SQL Server Analysis Services (SSAS), a key performance indicator (KPI) is a metric that a business uses to measure its success and progress. The metric is compared against a goal to determine its position relative to that goal and its velocity (trend). For example, a business might identify "Monthly Profit" as a KPI. The business establishes monthly goals for profit, and then compares the actual monthly profit to those goals to see if they met, exceeded, or fell short of their goal, and whether their profit is increasing, decreasing, or staying the same.
In Analysis Services, KPIs are objects in a cube and they define expressions that Analysis Services uses to get the value, goal, status, and trend for the KPI. Analysis Services KPIs also specify images that helps users grasp the status and trend of the KPI.
This article is also available in the following languages:
Richard Mueller edited Revision 10. Comment: Removed (en-US) from title, added tag
Fernando Lugão Veltem edited Revision 4. Comment: added portuguese version
Matt Burr MSFT edited Original. Comment: Added a link to SQL BOL tutorial on creating a KPI. I'll start doing that more often where it makes sense.
Nice post
gracias