Blog: Shawn Rogers

We can add jaspersoft, Eclipse/BIRT project (Actuate) and Mondrian/Jpivot.

But I don´t know how will go in the future.

The URL for Mondrian is http://mondrian.sourceforge.net - it is missing in the update list.

-Barry Klawans

The Bee Project
http://bee.insightstrategy.cz/en/index.html

You should take a look at OpenI as well (http://www.openi.org). It is a BI web application that we have been using in production for some time now, and we recently publihsed it into sourceforge to leverage an open source development model. OpenI provides out-of-box capabilities to create/publish your analysis with XMLA-compliant OLAP datasets (Microsoft Analysis Services, Mondrian, etc.). Future versions will include support for data mining models (e.g. R), relational databases, and others as the community sees fit.

You should also check out http://www.OpenI.org. This is an open source business intelligence application that spun out of Loyalty Matrix. It is based on more then four years of work with Fortune 1000 companies.

We just open sourced our BI application based on JPivot as OpenI ("open-eye"). There is demo, documentation etc. on http://www.openi.org, or you can directly download from sourceforge at http://sourceforge.net/projects/openi

I'd be interested to get your and community feedback.

We have a complete stack of open source components and can deliver portal based analytics, reports execution and scheduling TODAY.

We are also taking these components and building vertical analytic solutions and announced the availability of our first vertical, Life Science/Pharmaceutical Sales and Marketing Analytics at OSCON in Portland on Tuesday August 3.

Check us out at www.marvelit.com

Readers may with to have a look at PALO (www.palo.net) which is an open source MOLAP based server.

With a free excel add-in creating dimensions and cubes is a doddle.

Where something like palo really shines is that values are written back directly to RAM, which is in contrast to Analysis services which uses a separate relational table. As can be imagined with Analysis services the writeback table grows in size and performance slows. Sure the data can be processed back in, or you can resort to a combination of MOLAP and ROLAP (relational - slow) or you have data which is out of sync.

Ideal applications include bugeting and forecasting, reporting, BPM

PALO (www.palo.net) is an open source MOLAP server. Since data can be written back to RAM it's ideal for planning applications and financial applications such as budgeting and forecasting.

This article provides some data about the increased adoption of Open Source BI. It also discusses reporting and analysis server and suites.

http://www.sqlsummit.com/trends/OpenSourceBI.htm

You can add Breadboard BI as an implementer of BI using open-source tools - http://www.breadboardbi.com. Especially interesting is their ability to build over PeopleSoft and JDE ERP applications.

The reason why actuate is doing BIRT is partly because of wenfeng li.

Wenfeng li incured a huge lawsuit with his previous employer and brought a huge lose in lawsuit money to Actuate. Actuate has to layoff several times.

Then wenfeng li pushed to China. BIRT is his last desperate resort to build his force in Actuate. However, wenfeng li( PMC lead as he named himself )
doesn't really have much experience in Java technology.

Essentially Wenfeng li is wasting Actuate's money and resources to gain huge benefits for himself. At the same time to develop a very inferior product and call it a "massive success" and continue to add version number to that...

I am starting to think you don't like Wenfeng Li. Being that you have posted the same comment to several spots on the site it seems to me you have an agenda. Perehaps you could link us to a few of the items you discuss so we can see some facts about Actuate and Mr. Li?

Actually wenfeng li came from Microstrategy, but Microstrategy sued him for his unethecial behavior which cost both sides multi millions of dollars.Then wenfeng li engaged a series crazy actions in Actuate...

MicroStrategy Ranked Number 1
Nigel Pendse of The OLAP Survey compiled findings from almost 1,000 customer sites. In the survey, companies using more than one BI product were asked which product they would choose to standardize on and why.

MicroStrategy was selected by 87.5% The Peer Group consists of MicroStrategy, Hyperion Essbase, Cognos PowerPlay, Business Objects and Oracle Discoverer.

Here is how they ranked:

1 MicroStrategy
2 Business Objects
3 Cognos PowerPlay
4 Hyperion Essbase
5 Oracle Discoverer

In case you are wondering, you can install Mondrian on a Ubuntu box quite easily! ROLAP for free even! Pair it up with MySQL and you've got a very useable solution.