OLAP Web 可视化和报告建议
我正在为客户准备报价。他们每周向不同的组织提供数据。有大量适合 OLAP 的数据需要通过网络上的图表和数据透视表进行可视化，并且自定义报告将由非 IT 人员构建（一个简单的 GUI）。他们将输入日期范围、要包含的数据列的位置并生成报告，并可选择将数据导出到 Excel。他们目前使用 MS Excel 和数据透视表准备报告，但现在需要更好的在线工具来向客户显示数据。表很大并且需要向下钻取功能。我目前所了解的Spring、Flex、MySql、Linux。我对 PostgreSQL、MSSQL 和 Windows 有一些了解。做这个项目最简单的方法是什么？您认为 SSRP（尚未尝试）和 ASP.NET 更适合这种工作吗？实际上我更喜欢开源解决方案。 Flex 有 OLAP 数据网格控件，可以在客户端进行聚合。 JasperServer 看起来很有前途，但似乎我需要企业版本（多个组织和临时查询）。 Modrian + Flex + PostgreSQL 解决方案怎么样？任何以前的经验将不胜感激。是的，我对选项感到困惑。
I am preparing an offer for a customer. They proide weekly data to different organizations. There is huge amount data suits OLAP that needed to be visualized with charts and pivot tables on web and custom reports will be built by non-it persons (an easy gui). They will enter a date range, location which data columns to be included and generate report and optionally export the data to Excel. They currently prepare reports with MS Excel with Pivot Tables and but they need a better online tool now to show data to their customers. Tables are huge and need of drill-down functionality. My current knowledge Spring, Flex, MySql, Linux. I have some knowledge of PostgreSQL and MSSQL and Windows. What is the easiest way of doing this project. Do you think that SSRP (haven't tried yet) and ASP.NET better suits for this kind of job. Actually I prefer open source solutions. Flex have OLAP Data Grid control which do aggregation on client side. JasperServer seems promising but it seems I need enterprise version (multiple organizations and ad hoc queries). What about Modrian + Flex + PostgreSQL solution? Any previous experience will be appreciated. Yes I am confused with options.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看看DynamicJasper，它基于JasperReports，但是是动态的！
他们在此处运行了一个网络演示，演示展示了如何自定义报告结果。但由于您的用户不是 IT 人员，因此您需要的选择会更少。
DJ Charting API 没有出现在演示中，但您可以在此处查看
Take a look at DynamicJasper, it's based on JasperReports, but dynamically!
They have a web demo running here, the demo shows how to customize the report results. But as your users wont be IT people, then you will need less options.
DJ Charting API does not appear in the demo, but you can check it here