Category Archives: OLAP

How to Work With Dates in Cognos Insight

Posted on July 19, 2013 by Thomas Manchego

Dealing with dates in Cognos can sometimes be a daunting task.  Dates should be straightforward, but sometimes they take extra work to get what you want.  Your data is designed to list the date of the transaction, but maybe you … Continue reading →

Posted in Analytics, Business, Business Analytics, Business Intelligence, Cognos, Data Integration, IBM, OLAP, Reporting, Uncategorized | Tagged , , , , | Comments Off on How to Work With Dates in Cognos Insight

Joining Columns In Cognos Insight

Posted on May 30, 2013 by Thomas Manchego

One of the benefits of Cognos insight is the ability to combine columns during the import process.  This can help us when browsing the data through explore points.  It is often beneficial to combine columns as it is easier to … Continue reading →

Posted in Business Intelligence, Cognos, IBM, MySQL, OLAP, Uncategorized | Tagged , , | Comments Off on Joining Columns In Cognos Insight

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

Pentaho Analysis Mondrian OLAP Security Setup – Part I

Posted on June 30, 2011 by Benjamin Goewey

Hello. This is the first Datamensional blog and personally the first blog I’ve ever wrote! Yes, I know I’m a little behind the times but our team aims to add useful and interesting knowledge for both Pentaho and the Business … Continue reading →

Posted in Business Intelligence, Mondrian, OLAP, Pentaho | 13 Comments