技术控

    今日:72| 主题:49409
收藏本版 (1)
最新软件应用技术尽在掌握

[其他] Advanced KPI Configurations in SQL Server Reporting Services 2016

[复制链接]
無可奈何的無賴 发表于 2016-10-3 11:43:16
242 6

立即注册CoLaBug.com会员,免费获得投稿人的专业资料,享用更多功能,玩转个人品牌!

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
By:Koen Verbeeck |  |   Related Tips: > Reporting Services KPI
   Problem

   SQL Server Reporting Services 2016 (SSRS) introduces the concept of mobile reports and KPI, followed by Microsoft's acquisition of Datazen. The tip Create a basic KPI in SQL Server Reporting Services 2016 explained how you can create such a KPI in the brand new Reporting Services portal. In this tip, we'll take it a step further and explain additional configuration options for a KPI.
  Solution

  Test Set-up

   We will use the same test set-up as in the tip Create a basic KPI in SQL Server Reporting Services 2016 , so it's advised to read it first. The tip explains how to create a shared data source, a shared data set and a basic KPI using the result set of the dataset. For the sake of completeness, this is the query used in the dataset:
  [code]DECLARE @KPIGoal INT = 75000000;
SELECT
  YTD_TotalExcludingTax = SUM([Total Excluding Tax])
,KPIGoal    = @KPIGoal
,KPIStatus    = CASE WHEN SUM([Total Excluding Tax]) / @KPIGoal < 0.70 THEN -1
         WHEN SUM([Total Excluding Tax]) / @KPIGoal > 0.90 THEN 1
         ELSE 0
         END
FROM [Fact].[Order]
WHERE [Order Date Key] ¡Ý '20160101'
AND [Order Date Key] ¡Ü '20161231';[/code]  With the dataset created, you can create a KPI by following the instructions in the tip. Ultimately, your KPI should look like this:
   
Advanced KPI Configurations in SQL Server Reporting Services 2016-1 (additional,Microsoft,explained,further,reports)

  Using Favorites

   In the Portal, you can mark one or more KPIs (or reports) as your favorites. You can simply do this by clicking on a KPI, which will result in a pop-up. In the pop-up, you simply select Add to Favorites .

Advanced KPI Configurations in SQL Server Reporting Services 2016-2 (additional,Microsoft,explained,further,reports)

  When you return to the portal, you can recognize your favorite KPIs by a star in the upper right corner.
友荐云推荐




上一篇:小白学react之SASS实战
下一篇:CurrencyFormatter.js – A super simple currency formatting library
酷辣虫提示酷辣虫禁止发表任何与中华人民共和国法律有抵触的内容!所有内容由用户发布,并不代表酷辣虫的观点,酷辣虫无法对用户发布内容真实性提供任何的保证,请自行验证并承担风险与后果。如您有版权、违规等问题,请通过"联系我们"或"违规举报"告知我们处理。

昆仑之巅 发表于 2016-11-6 09:18:38
昆仑之巅涨姿势了
回复 支持 反对

使用道具 举报

笑白 发表于 2016-11-6 15:14:51
出来混,老婆迟早是要换的.
回复 支持 反对

使用道具 举报

自我催眠 发表于 2016-11-9 10:35:23
不明觉厉,先回再看!
回复 支持 反对

使用道具 举报

白晴 发表于 2016-11-10 11:19:48
不作死就不会死
回复 支持 反对

使用道具 举报

李茂 发表于 2016-11-13 12:55:08
传说中的沙发???哇卡卡
回复 支持 反对

使用道具 举报

贾叶洋 发表于 2016-11-14 08:23:26
无论是不是沙发都得回复下
回复 支持 反对

使用道具 举报

*滑动验证:
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

我要投稿

推荐阅读

扫码访问 @iTTTTT瑞翔 的微博
回页顶回复上一篇下一篇回列表手机版
手机版/CoLaBug.com ( 粤ICP备05003221号 | 文网文[2010]257号 )|网站地图 酷辣虫

© 2001-2016 Comsenz Inc. Design: Dean. DiscuzFans.

返回顶部 返回列表