Category Archives: Business Intelligence

Designing Cognos Insight

Posted on October 18, 2013 by Thomas Manchego

One of the most powerful parts of Cognos Insight is the ability to add different themes to your workspace.  This can cause your widgets to pop out a little more, and give a little more color.  Sometimes we want a … Continue reading →

Posted in Analytics, Business, Business Analytics, Business Intelligence, Cognos, Cognos Insight, Data Integration, IBM, Productivity, Reporting | Tagged , , , , , , , | Comments Off on Designing Cognos Insight

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

Let’s Make A Deal! Intuition, Analytics, and Answering the Right Question

Posted on June 26, 2013 by Gerrit Goewey

I was wandering around YouTube one weekend looking for something mentally stimulating when I came across the Monty Hall problem.  For those who are not familiar, the problem is named after the host of the gameshow Let’s Make A Deal.  … Continue reading →

Posted in Business Intelligence, Cognos, Cognos Insight, Data Integration, IBM, Reporting | Tagged , , , , , | Comments Off on Let’s Make A Deal! Intuition, Analytics, and Answering the Right Question

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 MySQL (or other ODBC connections) with Cognos

Posted on April 23, 2013 by Gerrit Goewey

MySQL is quite possibly the most commonly used database today due to its free license tier making it a very low risk investment.  While it is not well geared towards the large queries of reporting and analysis, there may be … Continue reading →

Posted in Business Intelligence, Cognos, IBM | Tagged , , | 1 Comment

Raising the Bar with Mobile BI

Posted on September 7, 2012 by chelsea

(Enjoy a sneak peak of some dashboard screenshots as you read) In recent years, mobile device sales have outshined those of personal computers. One survey reported that 95 percent of employees purchased a mobile device with the intent to use … Continue reading →

Posted in Business, Business Analytics, Business Intelligence, Productivity, Uncategorized | Tagged | Comments Off on Raising the Bar with Mobile BI

Xaction Basics – Sending an Email

Posted on March 15, 2012 by Benjamin Goewey

There are moments when working with the BI server that you will desire functionality that isn’t necessarily available through the server itself or any plugin that is currently out there.  In these situations, you will need xactions, which can be … Continue reading →

Posted in BI Server, Business Intelligence, Pentaho | Comments Off on Xaction Basics – Sending an Email

Fusion Charts in Pentaho Report Designer

Posted on March 8, 2012 by Benjamin Goewey

For those of you looking to add a little something extra to your Pentaho Report Designer reports, here are some steps to allow FusionCharts to be inserted directly into the report.  Of course, this is very format specific, and will … Continue reading →

Posted in Pentaho Report Designer, Reporting | 6 Comments

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

Differences in Private versus Public Schedules using Pentaho User Console

Posted on February 23, 2012 by Benjamin Goewey

We get a lot of questions about the scheduling mechanism within the Pentaho BI Server and the differences between Public and Private Schedules. Update: Michael D’Amour of Pentaho informed me that the scheduling mechanism will be completely re-written in the Sugar release … Continue reading →

Posted in BI Server, Business Intelligence, Pentaho | 1 Comment