pentaho

How do I integrate LimeSurvey with Pentaho?

I'm trying to integrate LimeSurvey (a PHP web application to develop and collect responses to online surveys) with Pentaho (ETL, business intelligence, reporting, etc.), but I'm facing some serious problems. LimeSurvey automatically generates a new table for storing the answers of each survey created within my application, and I need to...

How to delete a folder using Modified Javascript in Pentaho?

I am trying to delete a folder using Modified Javascript in Pentaho, however the delete keyword is reserved by the PDI compiler (it is used to delete a variable from memory). Here's what I do: var source = new java.io.File("some path"); var files = source.list(); for (var i=0; i<files.length; i++) { deleteFile(oldpath + "/" + filen...

Pentaho : Images not having correct path

I am running Pentaho reports. The problem is all the images are set to localhost:8080 etc, so, I am not able to view the images. Can you tell me where this property be available ...

Using MDX, how to get only a few selected rows?

I have a Color dimension with many colors, but I want to show a table with just two rows (black and red). I tried this: SELECT [Color].[black] || [Color].[red] ON ROWS, {[Measures].defaultMember} ON COLUMNS from [SalesAnalysis] The result I was expecting was a table with one column and two rows. One cell for black sales, one cell f...

In MDX, calculate the sales rank of a given shop

I have an OLAP cube containing the sales count for each of my shops. Using MDX, how can I output the rank of a given shop? I am dreaming about something like below (does not work), it would return 8 if SomeShop is the 8th most-selling shop: SELECT RANK( [Shop].CHILDREN, [Shop].[SomeShop]) from [Sales] ...

MDX Rank request returning unexpected results

I wrote this fairly simple MDX request to get the rank by sales count of each gender: WITH MEMBER [Measures].[rank] AS RANK( [Gender].CurrentMember, Order( [Gender].Members, [Measures].[salescount], BDESC ), [Measures].[salescount] ) SELECT [Gender].Members ON COLUMNS, [Measures].[ra...

MDX WHERE: "AND" between several conditions

This MDX request works: SELECT [Measures].salescount ON COLUMNS, [Date].[2010] ON ROWS FROM [SalesAnalysis] WHERE [Area].[Shanghai] This one works too (different WHERE condition): SELECT [Measures].salescount ON COLUMNS, [Date].[2010] ON ROWS FROM [SalesAnalysis] WHERE EXCEPT([Product].[All Products].Children, {[Product].[All Produc...

Parameter Pentaho Report Designer with MDX

I am doing a report, using Pentaho Report Designer. My datasource is a Mondrian Cube with mysql jdbc. I am using mdx queries and i want to put some of parameters. I have configure a parameter with its own query. The problem is the way the relation between the main query and the parameter query. For that, i am using the function paramet...

Putting multiple DB-resultrows into one stream row

I have a database table, let's call it headers with an id and a String-field called "header". Another table in the database, called subheaders has two fields, headerId and the String field "subheader". There are 0, 1 or 2 subheaders per header. I now want to use Kettle/Pentaho Data Integration to generate an Excel output with the followi...