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 read, and not always necessary to sort by columns individually.
Business Intelligence
30 posts
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 a need to report directly from an existing MySQL database […]
(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 it for work. For many this has meant discovering the […]
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 a little intimidating at first glance. For this reason, we’ll […]
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 only work with HTML. Download, Setup, and Test on Pentaho […]
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 MSSQL 2008R2 with the standard Adventure Works example data loaded. […]
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 which is the next generation of the Pentaho Suite. The […]
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 to married with any one particular vendor in their Business […]
Hello. Today I’m going to be discussing how to go about setting up SSO (Single Sign On) support for Pentaho using CAS (Central Authentication Service) and an LDAP (Lightweight Directory Access Protocol) Server. By doing this, you can allow Pentaho to utilize the same usernames and passwords as your other […]
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 Intelligence communities. What I have here is a YouTube Video […]