用于呈现 OLAP 数据的包
我正在管理一个基于 MS SQL 2005 的非常大的数据仓库（> 1 TB）。我想为用户创建一个解决方案来在线显示来自多维数据集的数据（Web 界面）。 现在他们正在使用 Office Web Components，但效果不太好。 我对他们创建的报告没有任何控制权。 我用谷歌搜索了一下，有一些解决方案，比如 Dundas 或 Analyzer。
也许有人对此（或其他）包有一些经验并且可以分享意见？ 我有一些基本要求：
- 高性能并且对 OLAP 服务器没有不必要的查询
- 能够存储报告（例如：用户创建过滤器，选择日期范围并且他必须能够存储它）
- 能够导出到 Excel
- 一些内置的图表引擎就很好了。
一些想法？
I'm managing a very large data warehouse (>1 TB) based on MS SQL 2005. I would like to create a solution for the users to present data from the cubes on-line (web interface). Right now they are using Office Web Components, but it's not so good. I don't have any controls over the reports that they create. I googled, and there are some solution like Dundas or Analyzer.
Maybe someone has some experience with this (or other) packs and can share opinions? I have some basic requirements:
- high performance and no unnecessary queries to the OLAP server
- being able to store reports (for example: users creates filters, selects dates ranges and he must be able to store it)
- ability to export to Excel
- some charting engine built in would be nice.
Some ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
Devexpress 有一个非常好的“PivotGrid” - 一个可以在 ASP.NET 应用程序中使用的 OLAP 数据挖掘组件：
http://www.devexpress.com/Products/NET/Controls/ASP/Pivot_Grid/
及其对应的 Winforms 应用程序：
http://www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/
RadarCube 也是一个 ASP用于呈现 OLAP 数据的 .NET 组件：
http://www.radar-soft.com/ products/aspnet.aspx
这里有一个潜在的 OLAP 演示工具的完整列表 - 我并不真正了解其中任何一个 - 但您可以看看！
http://www.download32.com/net-olap-software.html
马克
Devexpress has a really nice "PivotGrid" - a OLAP data mining component that can be used in ASP.NET apps:
http://www.devexpress.com/Products/NET/Controls/ASP/Pivot_Grid/
and its counterpart for Winforms applications:
http://www.devexpress.com/Products/NET/Controls/WinForms/Pivot_Grid/
RadarCube also is an ASP.NET component to present OLAP data:
http://www.radar-soft.com/products/aspnet.aspx
And here's a complete list of potential OLAP presentation tools - not that I really know any of them - but you can have a look!
http://www.download32.com/net-olap-software.html
Marc
看一下 Pentaho Mondrian 使用的 JPivot。
JPivot 是一个开源 Java 标签库，用于连接通过 Mondrian（Java OLAP 服务器）或通过 XML/A（我相信 Microsoft Analysis Services 使用的）公开的多维数据集。
JPivot 控制相当全面，尽管还需要进行一些改进。 我相信一个新项目 Pentaho Analysis Tool (PAT) 正在开发中，作为 JPivot 的替代品，它使用 GWT 来呈现更好看的 UI (
我使用 Pentaho Mondrian 和 JPivot 在我的 Intranet 上展示我的多维数据。 我正在使用在 SQL Server 2000 上运行的 ROLAP 模式。它工作正常，并且还支持使用 JFreechart 生成图表。
Mondrian Java OLAP 服务器 - http://mondrian.pentaho.org/
JPivot http://jpivot.sourceforge.net/ - 屏幕截图 http://jpivot.sourceforge.net/temp-N101F1.html
Eclipse BIRT 也可能值得一看，我相信这可能支持某种交叉表控制，但是我从来没有尝试过。
Take a look at JPivot that is used by Pentaho Mondrian.
JPivot is an open source Java tag library for connecting to cubes exposed through Mondrian (Java OLAP server) or through XML/A (which I believe is used by Microsoft Analysis Services).
The JPivot control is pretty comprehensive although it could do with a little bit of a facelift. I believe that a new project Pentaho Analysis Tool (PAT) is in development as a replacement for JPivot this uses GWT to render a nicer looking UI (http://wiki.pentaho.com/display/COM/Pentaho+Analysis+Tool).
I use Pentaho Mondrian along with JPivot to present my multidimensional data on my intranet. I am using a ROLAP schema running on SQL Server 2000. It works ok and also supports generating charts with JFreechart.
Mondrian Java OLAP Server - http://mondrian.pentaho.org/
JPivot http://jpivot.sourceforge.net/ - Screenshots http://jpivot.sourceforge.net/temp-N101F1.html
It may also be worth looking at Eclipse BIRT I beleive that this possibly supports a sort of crosstab control but i've never tried it.
你使用Sharepoint吗？ 由于 Microsoft 最近宣布了许可重组，您可能会发现您已经获得 PerformancePoint/ProClarity 服务器/组件的保护。
Do you use Sharepoint? You might find that you're already covered for a PerformancePoint/ProClarity server/components, due to recent licensing restructuring announced by Microsoft.