记分卡的 PPS/绩效点日期范围
如何将“开始”和“结束”日期范围添加到记分卡和分析报告中？
它似乎没有在任何地方得到很好的记录（包括 PPS 书籍！），但肯定是任何报告的基本要求。
是否可以？或者是否有必要添加 2 个过滤器：一个日期时间选择器和一个“滞后”过滤器（其中包含下拉列表中的天数/周数/月数）：
要求是创建一个记分卡，其中 KPI 基于前几年的绩效，因此，有 2 个日期参数都需要传递到 KPI 中以过滤结果 (ParallelPeriod)。
提前致谢
How do I go about adding a From and To date range to a scorecard and analytic report?
It doesn't seem to be well documented anywhere (including PPS books!) but surely a basic requirement for any report.
Is it possible? Or is it necessary to add 2 filters: a DateTime picker and a 'Lag' filter (which contains the number of days / weeks / months in a dropdown):
The requirement is to create a scorecard, with KPIs based on previous years performance, so there are 2 date parameters both of which need to be passed into the KPI to filter down the results (ParallelPeriod).
Thanks in advance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以使用分析报告来执行此操作，但不能使用记分卡来执行此操作。对于报告，我不一定推荐它，因为您需要修改 MDX 来设置参数，这意味着您将失去报告的交互功能。以下是在 MDX 中设置参数的示例 - http://dailyitsolutions.blogspot.com/2011/01/from-date-to-date-in-performancepoint.html。
仪表板通常是查看和分析您可以轻松执行的时间段与通常在运营报告中找到的日期范围。如果 SSAS 数据库中没有可用的时间智能功能，您可能需要考虑使用 PerformancePoint 中提供的一些时间智能功能。
以下是 TI 公式的概述 - http://blogs.msdn.com/b/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx
You can do this with analytical reports, but not with the scorecard. For the report I wouldn't necessarily recommend it because you will need to modify the MDX to setup parameters and that means you will lose the interactivity features with the report. Here is an example of setting up parameters in the MDX - http://dailyitsolutions.blogspot.com/2011/01/from-date-to-date-in-performancepoint.html.
Dashboarding is typically looking at and anlyzing periods of times which you can easily do versus the date ranges that you would typically find in operational reporting. You might want to take a look at possibly using some time intelligence features that are available in PerformancePoint if you do not have this available in your SSAS database.
Here is an overview on the TI formulas - http://blogs.msdn.com/b/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx