是否使用 OLAP
我想问的是，与使用 SSAS 构建 OLAP 层并以这种方式访问数据相比，使用 ODBC 连接直接从 Oracle DW 中提取 Sharepoint 2010 中的报告有何性能提升。
I want to ask what are the performance gains of pulling reports in Sharepoint 2010 directly from an Oracle DW using an ODBC Connection as opposed to building an OLAP Layer using SSAS and accessing the data that way.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
听起来您混淆了术语和技术。将 ODBC 与 OLAP 和 SSAS 进行比较就像将苹果与橙子进行比较。它们是非常不同的东西，用于非常不同的目的。共同点是它们都处理数据……而苹果和橙子都是水果。
但是，尝试从字里行间解读，如果配置正确，OLAP 将比从标准 RDBMS 聚合的数据更快、更容易地提供可操作的信息（商业情报等）。毕竟，这就是 OLAP 的设计目的：
It sounds like you're confusing terminologies and technologies. Comparing ODBC to OLAP and SSAS is like comparing apples to oranges. They are very different things used for very different purposes. The commonality is that they both deal with data... and apples and oranges are both fruit.
But, trying to read between the lines, OLAP, if configured correctly, will deliver actionable information (biz intel etc.) much more quickly and readily than data aggregated from a standard RDBMS. After all, that's what OLAP is designed for:
现在 SQL Server 2012 已发布，您可能希望考虑在 Oracle 数据上构建 BISM（使用 SSAS），然后在 SharePoint 中显示结果。
尽管您可以使用“PowerPivot on SharePoint”模式来使用 SharePoint 资源托管（渲染）BISM，但您宁愿使用单独的服务器来托管 SSAS，这样渲染（大概）大型报表的工作量就不会增加。减慢您的 SharePoint 服务器速度。
当然，仍然可以使用 SSAS 构建 OLAP 多维数据集，但除非您需要 BISM 模型中尚未提供的一项或多项功能，否则您宁愿构建 BISM 而不是 OLAP 多维数据集，因为 BISM 利用 Vertipaq（因此构建起来更简单，即需要更少的 Oracle ETL）。如需了解更多信息，请查看 BISM 上的我的 Slideshare 幻灯片
Now that SQL Server 2012 is released, you may want to look into building a BISM (using SSAS) over your Oracle data and then displaying the results in SharePoint.
Although you can use the 'PowerPivot on SharePoint' mode to be able to host (render) the BISM using SharePoint resources, you'd rather get a separate server to host SSAS, so that effort of rendering (presumably) large reports doesn't slow down your SharePoint server.
Of course it is still possible build an OLAP cube using SSAS, but unless you need one or more of the features not yet available in the BISM model, you'd rather just build a BISM than an OLAP cube, as the BISM leverages Vertipaq (so it's simpler to build, i.e. requires less ETL from Oracle). For more check out my deck on slideshare on the BISM