Defining key performance indicators
You can define a KPI within the SSDT tab called KPIs by specifying the value, goal, status, and trend expressions along with optional properties. A KPI's value is a measure, its goal is the ideal value of the calculation, the status shows the relative condition of the measure compared to the goal, and the trend indicates whether the business is moving closer to the target. For example, the Adventure Works sample database has a KPI called Growth in Customer Base. This KPI is built upon the [measures].[growth in customer base] measure which compares the current time span's customer count with that of the previous time span: the current year is compared to last year, the current quarter is compared to last quarter, ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
