Database Reference
In-Depth Information
7. Click on
OK
to create the new KPI.
Something that may not be obvious when first creating KPIs is that you can specify
how the thresholds should behave. By default, it shows green on the highest and red
on the lowest; however, you can click on the bands below
Target
to change if you,
for example, would like to create a KPI that shows green when it is closer to the tar-
get.
After creating the KPI, you have to test your newly created KPI. You have a feature
in SQL Server Data Tools that allows you to directly connect to the temporary model
that resides on your workspace server from Excel. You access this function using the
Analyze in Excel
button.
Search WWH ::
Custom Search