title: open source business intelligence solutions
body: <p>which open source business intelligence solution would you recommend?</p>
  
  <p>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...</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>thanks a lot</p>
  
  <p>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...</p>
  
  <p>ps: some useful links:</p>
  
  <p><a href="http://en.wikipedia.org/wiki/Business_intelligence_tools#Open_source_free_products" rel="noreferrer">http://en.wikipedia.org/wiki/Business_intelligence_tools#Open_source_free_products</a></p>
  
  <p><a href="http://www.manageability.org/blog/stuff/open-source-java-business-intelligence" rel="noreferrer">http://www.manageability.org/blog/stuff/open-source-java-business-intelligence</a></p>
  
  <p><a href="http://www.jaspersoft.com/jasperanalysis" rel="noreferrer">http://www.jaspersoft.com/jasperanalysis</a></p>
  
  <p><a href="http://community.pentaho.com/projects/bi_platform/" rel="noreferrer">http://community.pentaho.com/projects/bi_platform/</a>
  <a href="http://community.pentaho.com/faq/platform_licensing.php" rel="noreferrer">http://community.pentaho.com/faq/platform_licensing.php</a></p>
  
  <p><a href="http://www.eclipse.org/birt/phoenix/" rel="noreferrer">http://www.eclipse.org/birt/phoenix/</a></p>
  
  <p><a href="http://www.spagoworld.org/xwiki/bin/view/SpagoWorld/" rel="noreferrer">http://www.spagoworld.org/xwiki/bin/view/SpagoWorld/</a></p>
  
  <p>spago demo
  <a href="http://spagobi.eng.it/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&amp;NEW_SESSION=TRUE" rel="noreferrer">http://spagobi.eng.it/SpagoBI/servlet/AdapterHTTP?PAGE=LoginPage&amp;NEW_SESSION=TRUE</a></p>
  
  <p><a href="http://ostatic.com/blog/open-source-business-intelligence-software-on-the-rise" rel="noreferrer">http://ostatic.com/blog/open-source-business-intelligence-software-on-the-rise</a></p>
  
  <p>jpalo demo
  <a href="http://www.jpalo.com/en/products/start_products.html" rel="noreferrer">http://www.jpalo.com/en/products/start_products.html</a></p>
  
  <p>jpalo (user:viewer/viewer)
  <a href="http://www.ten-sw.com:8080/Palo-Pivot/com.tensegrity.wpalo.WPalo/WPalo.html?locale=en_US&amp;theme=blue" rel="noreferrer">http://www.ten-sw.com:8080/Palo-Pivot/com.tensegrity.wpalo.WPalo/WPalo.html?locale=en_US&amp;theme=blue</a></p>
  
  <p><a href="http://docs.google.com/viewer?a=v&amp;q=cache:vhsqMQXwCUkJ:www.ow2.org/xwiki/bin/download/Activities/EuropeLocalChapterWebinars/ELCWebinarOSBI.pdf+open+source+business+intelligence&amp;hl=en&amp;pid=bl&amp;srcid=ADGEESgpJJ2MqaKprJQOF2jX2UXCZQjg_asv8d7EVYtq0Vma-e-tR1tFxS-I0SOW0IhJC5acYc94rkDOrgP1WckCp_vk4qhKqR9y2Klp_u9cL8hlXoKoUpMkpAd5wabu61A4W0y15E5P&amp;sig=AHIEtbRJ5FAI-3YK-qtayPjKkF_CwOgZag" rel="noreferrer">http://docs.google.com/viewer?a=v&amp;q=cache:vhsqMQXwCUkJ:www.ow2.org/xwiki/bin/download/Activities/EuropeLocalChapterWebinars/ELCWebinarOSBI.pdf+open+source+business+intelligence&amp;hl=en&amp;pid=bl&amp;srcid=ADGEESgpJJ2MqaKprJQOF2jX2UXCZQjg_asv8d7EVYtq0Vma-e-tR1tFxS-I0SOW0IhJC5acYc94rkDOrgP1WckCp_vk4qhKqR9y2Klp_u9cL8hlXoKoUpMkpAd5wabu61A4W0y15E5P&amp;sig=AHIEtbRJ5FAI-3YK-qtayPjKkF_CwOgZag</a></p>