用于 Olap 分析的 Swing 组件
我们正在创建一个桌面应用程序，它将使用 OLAP 服务器来执行分析。我正在寻找一个可以提供类似于 JPivot 功能的 Swing 组件。我们需要：
- 能够将多维数据集的维度添加为行/列
- 从多维数据集检索数据并显示它
- 展开/折叠层次结构（又名切片和骰子）
另外，JPalo 是一个很好的展示，但它仍然是一个 Web 解决方案。 <一href="http://www.jpalo.com/en/palo_pivot.php?sent=yes&option%5b%5d=OpenApp&option%5b%5d=ViewTabs&option%5b%5d=AutoLogin&option%5b %5d=AutoUser&选项%5b%5d=OpenView1&选项%5b%5d=Toolbar1&opt ion%5b%5d=HorizonalAxis1&选项%5b%5d=Save1&选项%5b%5d=POV1&选项%5b%5d=VerticalAxis1&opti on%5b%5d=工具栏3&选项%5b%5d=HorizonalAxis3&选项%5b%5d=POV3&选项%5b%5d=VerticalAxis3#pivot" rel="nofollow">demo
我们考虑了几个解决方案：
- JRubik。项目已经过时，是一个嵌入了 Mondrian OLAP 服务器的独立应用程序，它无法从头开始使用远程 XMLA 源。我们考虑分叉该项目并根据我们的需求重写
- OpenSwing 数据透视表/JIDE 数据透视表。网络中有 2 个数据透视表组件可用，因此我们正在考虑围绕这些组件构建我们自己的解决方案。不管怎样，它们中的任何一个都不适合我们，因为两者都采用平面模型并在 Swing 代码中进行所有聚合。相反，我们希望在 OLAP 端进行所有聚合，并且我们的 swing 组件应该只显示它。
- 拉阿扎达。它是另一个类似于 JRubit 的一体化应用程序，构建在 Eclipse RCP 之上。它包含我们需要的功能，但依赖于 SWT 和 Eclipse RCP，因此将其嵌入到现有的 Swing 应用程序中可能需要花费太多精力。
- 构建我们自己的解决方案。这是我们考虑的最后一个选项，但我们可能会选择这个。在这种情况下，我们希望尽可能地简化我们的工作，因此如果有任何带有可折叠行和列的 Swing 组件可以用来连接 XMLA，请告诉我。
目前我们对所提出的解决方案都不满意，所以我想听听社区的想法和建议。如果问题不清楚，请告诉我，这样我会尽力更好地解释。谢谢。
We're creating a desktop application which will use OLAP server to perform analysis. I'm searching for a Swing component which can provide functionality similar to JPivot. We need to:
- Be able to add cube's dimension as a row/column
- Retrieve data from cube and display it
- Expand/collapse hierarchies (aka slice&dice)
Also JPalo is a good showcase, still it's a Web solution.
demo
We've considered few solutions:
- JRubik. Project is outdated and is a standalone application with Mondrian OLAP server embedded, it can't work with remote XMLA sources from scratch. We consider forking the project and rewriting to our needs
- OpenSwing pivot table/JIDE pivot table. There are 2 pivot table components available in network, so we were considering to build our own solution around this components. Anyway, either of them didn't work for us, as both take flat model and do all aggregations inside swing code. Instead, we want to make all aggregations on OLAP side and our swing component should just display it.
- La Azada. It's a another all-in-one application similar to JRubit, built on top of Eclipse RCP. It contains functionality we need, but depends on SWT and Eclipse RCP, so it might be too much effort to embed it into existing Swing application.
- Build our own solution. This is the last option we consider, but it may happen that we will chose this one. In that case, we want to simplify our just as much as possible, so if there is any Swing component with collapsible rows and columns, which may be adopted to connect to XMLA, please let me know.
At this moment we're not happy with neither of proposed solutions, so I would like hear ideas and suggestions from the community. Let me know if question is unclear, so I will try to explain things better. Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
如果您正在开发自己的解决方案，我强烈建议使用 Olap4J
If you're developing your own solution, I'd strongly advise using Olap4J
也许这可以帮助
http://java-sl.com/envelope.html
May be this can help
http://java-sl.com/envelope.html
过去几年我们正在开发自己的产品。
它是一个 Swing 数据透视表解决方案，构建在 JTable 之上，100% Swing。
我们正在编写手册和 javadoc。
它使用olap4j 库，可处理平面模型和源自OLAP 多维数据集的数据。
您可以在这里查看演示：
www.scientific.gr/pivot-demo.jnlp
我用更新的版本更新了演示版本。可能和jre版本有关系。
We are developing our own product for the last few years.
It is a Swing Pivot Table solution, built on top of JTable, 100% Swing.
We are in the process of writing the manual and javadoc.
It works both with a flat model and data originating from an OLAP cube, using the olap4j library.
You can see a demo here:
www.scientific.gr/pivot-demo.jnlp
I updated the demo with a more recent version. Maybe it has something to do with the jre version.
另一个免费的简单 Java swing 组件 https://github.com/aristsoft/jpivot 用于可视化数据多维视图。
它的设计只是为了显示数据，因此它本身不会进行任何类型的数据聚合。
Another one free simple Java swing component https://github.com/aristsoft/jpivot to visualize the data in multidimentional view.
It designed just to show the data, so it don't doing the data aggregation any kind itself.