SharePoint 2010 PerformancePoint Services 记分卡不显示层次结构数字
我正在尝试在 SharePoint 2010 PerformancePoint 仪表板设计器中创建记分卡。我在 PerformancePoint 2007 中有一个非常相似的仪表板，运行良好。基本上，我创建了一个 KPI，它使用我的分析服务多维数据集作为数据源。在记分卡中我只使用这个 KPI。假设它是实际销售总额和目标销售总额。到目前为止，数字显示得很好。现在我真正想要的是按地区和商店进行深入分析。因此，我从多维数据集中提取维度层次结构并选择所有区域和子区域。然而，当我深入查看时，我没有看到任何商店的数字，它只是空白。它只显示顶层的数字。
I am trying to create a scorecard in SharePoint 2010 PerformancePoint dashboard designer. I had a very similar dashboard in performancePoint 2007 working fine. Basically, I have created a KPI which uses my analysis services cube as the data source. In the scorecard I just use this KPI. Let's say it is Total Sales Actual and Target. The numbers show up fine upto that point. Now what I really want is the drill down by region and stores. So I dran in my dimension hierarchy from the cube and select all regions and the children. However, when I drill down I don't see numbers for any store it is just blank. It just shows numbers for the top level.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
尝试将维度层次结构拖动到父框的右侧。如果将其按住一秒钟，框的右侧会显示一条蓝线，并且工具提示显示“最后一个子项”。如果您拖动到其他边缘，它可能是父级或兄弟级，这似乎无法深入到总数。
Try dragging your dimension hierarchy to the right side of the parent box. If you hold it there for a second a blue line shows up on the right side of the box and the tool tip says "last child". If you drag to the other edges it can be a parent, or sibling, which don't seem to drill down to the totals.
我不确定导致问题的原因，但我能够通过转到我的多维数据集的不同数据库（同一多维数据集托管在不同的盒子上）来解决问题。我认为我的开发 SQL 框可能存在一些问题。
I am not sure what was causing the issue but I was able to fix the problem by going to a different database for my cube (same cube hosted on a different box). I think my dev SQL box might have had some issues.