自定义BI应用程序中的powerpivot [英] powerpivot in custom BI application

问题描述

*是否可以将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 license he 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.

 

这篇关于自定义BI应用程序中的powerpivot的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！