Send Pentaho Report By EmailThe Pentaho Report Designer 3.5 brought along some important improvements. If you set up Xactions before that sent out reports by email, there are some slight changes now that you want to be aware of.In my case I prepared a report that uses a MDX query as source, which automatically selects the last 5 days of data. The report doesn't use an input, so it is fairly easy to integrate into an Xaction.My idea is to have basically a simplified version of the report in the email body and the full report with a chart as attachment....
Tuesday, 27 October 2009
Friday, 9 October 2009
Current date function on MondrianPentaho BI Suite - MondrianI create quite a lot of operational dashboard views like "How many users did we acquire through which kind of channels in the last 7 days on a daily level?". In the past my solution was to write some Javascript within an xaction to define the date variables and then to pass on these variables as parameters to an MDX query. The results set of the MDX query would then be passed on to a JPivot component. While you can fairly easily implement this in an xaction, it is probably not the most...
Wednesday, 7 October 2009
How remove the sample users from the login boxPentaho BI Server - Configuration Have you ever wondered how to get rid of the sample users in the Pentaho BI Server login box? Tom Barber pointed out a simple solution recently on the Pentaho forum that was originally posted by Paul Stoellenberger:You can edit the login properties of mantle in:biserver-ce\tomcat\webapps\pentaho\mantleLogin\loginsetting s.propertiesthere is an option:#showUsersList=truechange that toshowUsersList=falseThat's easy enough, if you know it :) ...
Thursday, 1 October 2009
Converting binary data type to String in KettleSometimes you might come across data that is store in in binary form in a table. To convert this data you chose one of the following approaches:Convert directly using SQL in the database input stepOne quick method would be to use the CONVERT or CAST function (test which one works best for you):CONVERT(prodCode USING latin1) AS prodCodeCAST(prodCode AS SIGNED) AS prodCodeSelect Values ... stepGo to the Meta-data tab, choose your binary field and set Binary to Normal to Y.Note: You can only use one tab...
Setting up an "All" ParameterThis short tutorial is fairly similar to the last one, let's say it's an improved version:We work again with Pentaho Report Designer 3.5. Imagine you want to give your users the possibility to choose either one of the parameter values or all. So how can we implement this with a MySQL query? The approach is as follows:Set up the query to for the parameter values like this:SELECT"All Countries" AS country_nameUNIONSELECTcountry_nameFROMtable;We...
Subscribe to:
Posts (Atom)
