Author Archives: Benjamin Goewey

Xaction Basics – FTPing a file

Posted on March 20, 2012 by Benjamin Goewey

Here is another little xaction that demonstrates the FTP capabilities of xactions. Just like the last one, make sure to save it in the workspace directory for Design Studio so that it displays properly when you try to edit it. … Continue reading →

Posted in BI Server, Pentaho | Leave a comment

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 | Leave a comment

Changing Pentaho’s Default Email Server to a Gmail Account

Posted on March 13, 2012 by Benjamin Goewey

Since we use gmail for our company email, we found it to be a bit trickier to enter the information through Enterprise Console unless you update your password.  To get around this, we edited the server\biserver-ee\pentaho-solutions\system\smtp-email\email_config.xml file as shown below.  … Continue reading →

Posted in Uncategorized | Leave a comment

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 | 4 Comments

Setting Up Logging Tables for PDI both Locally and on Server

Posted on February 28, 2012 by Benjamin Goewey

When running an ETL in Pentaho Data Integration (Kettle), logging is normally done in a log file on the local system.  When running an ETL through Carte or the BI server, it will add the information to their own separate … Continue reading →

Posted in Data Integration, Pentaho, Pentaho Data Integration | Leave a comment

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 | Leave a comment

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 , , , , , , | 6 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