SSRS 2016 CTP 3.3 has introduced the new web portal which features KPI’s and mobile reports.
KPIs are small tiled reports pinned to the main SSRS web portal, they give users a quick glance on performance.
This blog will focus on creating a KPI tile based on theMicrosoft Adventure works data warehouse installed on a SQL Server 2016 CTP 3.3, with the latest SSDT and report builder installed.
As of CTP 3.3 the only way of creating a new KPI is through report builder (v 3.0). This blog assumes you have already created and deployed a Data Source to the SSRS server.
1) Open report builder, click on “File” and then on “new dataset”: select the Data Source of your choice and hit create.
2) Once in the dataset editing window, select a stored procedure that you have previously created (the one i used can be found here: spObtainInternetSalesByYearKPIV1.sql (386.00 bytes)). Go to file and then save the dataset with a name of your choice on the SSRS server.
3) Go to the SSRS web portal, click on new and then on KPI.
4) In the new window enter a name for your KPI and then go to “Trend set”, in the drop down select “Dataset trend” and in the “Pick dataset trend” box click on the three dots.
You will be prompted with a view of all SSRS folders, navigate to the folder where the dataset you created earlier is and click on it.
A new window will open with a preview of the data from your dataset, select the column your KPI is based on, in my case is “SalesKPI” and click “OK”.