Category Archives: Microsoft

Using XMLA in Pentaho Reporting

Posted on March 6, 2012 by Gerrit Goewey

Anyone who has ever actually attempted it may have noticed that Pentaho Report Designer does not natively accept XMLA as a datasource.  It is still possible, and this little guide will step you through how to do this.  We used … Continue reading →

Posted in Analysis Services (SSAS), Microsoft SQL Server, OLAP, Pentaho Data Integration, Pentaho Report Designer | Tagged , | 2 Comments

How to Use MySQL and Microsoft PowerPivot Together

Posted on September 5, 2011 by Benjamin Goewey

Overview This document shows how an Open Source Database like MySQL can be used with Microsoft’s popular Excel plugin PoweverPivot.  Many clients enjoy the familiarity of Excel and ease of use that PowerPivot brings but the clients do not want … Continue reading →

Posted in Business Intelligence, Microsoft, Mondrian, MySQL, OLAP, Pentaho, PowerPivot, Reporting | Tagged , , , , , , | 7 Comments