自定义BI应用程序中的powerpivot

本文介绍了自定义BI应用程序中的powerpivot的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

*是否可以将powerpivot用作自己应用程序中的一种控件？ *是否可以PowerPivot获取在SSAS中计算的数据并仅显示结果？

* will it be possible to use powerpivot as a kind of control in an own application? * Is it possible for PowerPivot to get the data calculated in the SSAS and show only the results?

背景： 我寻找一个良好的枢轴控制来集成自定义BI应用程序。

Background: I look for a good pivot control to intergrate in a custom BI application.

正如我从denali的信息中看到的那样，人们可以从互联网上使用powerpivot来获得excel。但它有限，因为计算完全在excel中进行。 excel在客户端安装excel不是问题，但是处理大量的数据客户端是不可能的，因为必须将数据传输到excel然后进行聚合。对于使用数百万行，这似乎不方便或最佳实践。

As I can see it from the denali infos one gets from the internet one can use the powerpivot for excel. But it is limited as the calculation takes place completetly within excel. to excel Installing excel at the client isn't the problem here, but handling the huge amount of data clientside is not possible as the data has to be transferred to excel and then be aggregated. For using millions of rows this seem not handy or best practise.

另一方面，可以使用powerpivot for sharepoint，它可以计算SSAS中的数据。但最终用户需要这个非常昂贵的共享点许可证，而且他买不起。

On the other side one can use powerpivot for sharepoint, which calculated data within SSAS. But then the end-user needs this very expensive sharepoint licensehe cannot afford.

除了这两个还有其他缺点还有其他选择吗？

Are there any alternatives besides these two with their drawbacks?

谢谢，Markus Loibl，Siemens AG

Thanks, Markus Loibl, Siemens AG

推荐答案

PowerPivot不能用作自定义应用程序中的控件。您需要Excel Services和SharePoint。另一种方法是寻找适用于SSAS的第三方OLAP控件。

PowerPivot cannot be used as a control in a custom application. You need Excel Services and SharePoint. The alternative is to look for a third party OLAP control that works with SSAS.