开源商业智能解决方案
您会推荐哪种开源商业智能解决方案？
我需要的只是构建一些多维数据集，让最终用户使用维度、过滤数据、排序等，完成后能够将其导出到 Excel...
我希望解决方案尽可能简单易用顺便说一句，我希望它尽可能多地开源。我听说许多可用的解决方案在社区版本方面确实有很多限制。
我想听听您的建议以及每种替代方案的优缺点，以帮助我选择正确的工具，并且您是否可以向我指出一些基本的演示和教程来开始使用。
非常感谢
ps：我正在使用 sql server 数据库，它们不是巨大的数据库（通常少于一百万条记录），而且我不一定必须处理“实时”数据...
ps：一些有用的链接：
http://en.wikipedia.org/wiki/Business_intelligence_tools#Open_source_free_products
http://www.manageability.org/blog/stuff/open-source- java-business-intelligence
http://www.jaspersoft.com/jasperanalysis
http://community.pentaho.com/projects/bi_platform/ http://community.pentaho.com/faq/platform_licensing.php
http://www.eclipse.org/birt/phoenix/
http://www.spagoworld.org/xwiki/bin/view/SpagoWorld/
spago 演示 http://spagobi.eng.it/SpagoBI/servlet/AdapterHTTP ?PAGE=LoginPage&NEW_SESSION=TRUE
http ://ostatic.com/blog/open-source-business-intelligence-software-on-the-rise
jpalo 演示 http://www.jpalo.com/en/products/start_products.html
jpalo（用户：查看者/查看者） http ://www.ten-sw.com:8080/Palo-Pivot/com.tensegrity.wpalo.WPalo/WPalo.html?locale=en_US&theme=blue
which open source business intelligence solution would you recommend?
All I need is to build some cubes and let the end user play with dimensions, filter data, sort, etc, and once it's done being able to export it to excel...
I'd like the solution to be as simple and easy on resources as possible, and also I'd like it to be as much open source as possible, by the way. I've heard that many solutions available do have many restrictions when it comes to there community version.
I'd like to ear your advices and the pros/cons of each alternative, to help me choose the right tool, and if you could point me to some basic demo and tutorial to get started.
thanks a lot
ps: I'm using sql server databases, they aren't huge databases (in general less than a million records) and I doesn't necessarily have to work on "live" data...
ps: some useful links:
http://en.wikipedia.org/wiki/Business_intelligence_tools#Open_source_free_products
http://www.manageability.org/blog/stuff/open-source-java-business-intelligence
http://www.jaspersoft.com/jasperanalysis
http://community.pentaho.com/projects/bi_platform/
http://community.pentaho.com/faq/platform_licensing.php
http://www.eclipse.org/birt/phoenix/
http://www.spagoworld.org/xwiki/bin/view/SpagoWorld/
spago demo
http://spagobi.eng.it/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&NEW_SESSION=TRUE
http://ostatic.com/blog/open-source-business-intelligence-software-on-the-rise
jpalo demo
http://www.jpalo.com/en/products/start_products.html
jpalo (user:viewer/viewer)
http://www.ten-sw.com:8080/Palo-Pivot/com.tensegrity.wpalo.WPalo/WPalo.html?locale=en_US&theme=blue
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
据我使用 Pentaho 和 BIRT 的记忆，这些工具非常难以安装和学习。但是，如果您不介意投入时间来学习繁琐的用户界面，那么您最终会获得非常强大的工具。
我想您对开源 BI 感兴趣是因为预算而不是“宗教”吗？如果是这样，我会考虑使用低成本/试用 SaaS 替代方案，至少首先向您的用户提供快速原型。
同时，花时间评估和学习您选择的开源工具。
最后，在几周内，您将获得满意的用户，他们可以使用维度、创建报告并为您提供宝贵的反馈和对您选择的 BI 工具的深入了解，以便您可以就走哪条路做出合格的决定。
免责声明：我是 www.gooddata.com 的顾问，该公司提供我建议至少用于向用户提供早期原型的 SaaS BI 软件。如果您尝试按照上述方式进行操作，请随时寻求帮助。
As far as I remember from playing with Pentaho and BIRT, these tools are quite difficult to install and learn. But if you don't mind invest your time into learning cumbersome user interfaces you get quite powerful tools at the end of the day.
May I suppose you are interested in open-source BI because of budget rather than 'religion'? If so I'd consider a low-cost/trial SaaS alternative at least to deliver a quick prototype to your users at first.
In the meantime use your time to evaluate and learn an open-source tool of your choice.
Finally, in a couple of weeks, you get happy users who can play with dimensions, create reports and give you valuable feedback and a good knowledge of a BI tool of your choice so you can do a qualified decision about which way to go.
Disclaimer: I work as a consultant for www.gooddata.com - a company that offers that kind of SaaS BI software I'm proposing to use at least to deliver an early prototype to your users. Feel free to ask for any help if you try to do it in the way outlined above.
与其他的不同，我建议使用 Jasper。其质量比 Pentaho 更加卓越且用户友好。您必须破解许多不同的开源库配置。当我使用 Jasper 时，我感觉我在使用 Crystal，但当我使用 Pentaho 时我没有这种感觉。
Unlike the others, I would suggest using Jasper. The quality is far more superb and user friendly than Pentaho. You have to hack many different opensource library configs. I feel like I am using Crystal when I use Jasper, but I don't get that impression when using Pentaho.
看看 Pentaho Community Edition 这里 我使用过他们的 ETL 工具，它很有魅力。
Have a look at Pentaho Community Edition Here I have used their ETL tool a bit and it works a charm.
Pentaho FTW。我真的很高兴。 Mondrian 在 mysql 上工作得很好。
为了进行报告，我使用 BIRT
Pentaho FTW. I'm really happy with it. Mondrian works great over mysql.
For reporting I'm using BIRT
SpagoBI 是一个全球解决方案，包含从 Birt 报告到 Jasper 报告以及地理定位分析等所有工具...
SpagoBI 是免费且易于设置的，看看并提出您自己的想法。
SpagoBI is a global solution which contains all the tools, from Birt reports to Jasper reports, and geolocalization analysis ...
SpagoBI is free and easy to setup, have a look and make your own idea.