Pentaho Data Integration (PDI) and Report Designer Manipulation with Parameters

Category: cassandra, pentaho, kettle, report-designer, pentaho-design-studio

I've been trying to tackle the following issue in Pentaho BI suite:

I have a data integration step that returns a column with n values. I want to pipe that data integration into pentaho report designer and pass that column as a parameter. I then want to convert that column into an array of all string values in the column so that I can pass it as a parameter into another data transformation.

Here is the example. Assume that the first transformation returned the following column


What I am looking to to is to transform this result into array ['abc','edf','hig']. To do so I assign hidden String parameter event inside report-designer to this column. Then keeping in mind that I want a single array object I created second hidden parameter Object output with the postprocessing formula =CSVARRAY([event];0;",";). Now if I pass my second parameter output to the second transformation, which is a cassandra input, I get empty result back.

Could anyone suggest a good solution?

Thank you!

March 7, 2013, 10:56 pm notrockstar on StackOverflow
Submit Answer!
None of these answers doing it for you? Ask your own question!

Similar Questions
Using PDI transformation in Pentaho BI server as data source for report parameters
Any advice on how to use PDI transformation as data source for report parameters in BI server's console? I've uploaded the prpt reports to BI server but the I get a message "Error parsing parameter information". The .prpt and .ktr...
Read more

upload file to my server using pentaho data integration(pdi)
On my pdi transformations, a file is created and then a table on my database_1 is updated with the information on that file. That work perfectly fine. What i need now is to upload the file to some place in...
Read more

pentaho data integration: Executing PDI the BI Server or with carte?
I'm working on a project with pentaho. I'm gonna use the whole community edition solution. I'll have jobs and transformations that will be launch by user for some (so with PDI on their computer), and automatically for others. I'm wondering...
Read more

using parameters in default formula for another parameter in Pentaho report Designer
I have two parameters defined in a Pentaho Report, both of them are dates, end date is something the user picks for eg. 2012-07-09 (July 9th 2012). The other parameter(start date) is hidden and is supposed to be the end...
Read more

Pentaho Report Designer - Dynamic Data Sources
All, I have a local instance of the Pentaho Report Designer running on my box and it has a local development database configured as it's data sources. (2 datasource config's, both pointing to the same local data server; source and...
Read more

Pentaho Report designer 3.9.0 not working with mifos 2.5.0
I am getting the following error in my application while trying to access the reports generated from PRD 3.9.0 version. JNDI Error Report cannot be generated because JNDI has not been configured. Please follow the instructions below to set up...
Read more

Change data source base on user for a report in Pentaho
I am very new in Pentaho report development. I have a trouble in changing data source for a single report base on the user logged in. For example - Now what I need is, if the user "cat" logged in,...
Read more

Questions regarding Pentaho Report designer
I tried looking on the net, however I couldn't find it. it converts the same to select distinct count (user_id) from mytable Please help....
Read more

Not able to run spoon.bat or any other batch file in Pentaho Data Integration (Kettle)
Tried pdi-ce-4.1.0-stable and pdi-ce-4.2.0-stable My Machine - Windows 7 64 bit When I run Spoon.bat cmd line window appears and disappears and then nothing happens. When I tried to run it from command line, I get But then again the...
Read more

Report designer could not load assembly file for my data layer
I have an ASP.NET website made in VS 2010 using .NET 4.0. In this website I have some reports (.rdlc) that access the data using another project where I have my data layer (MyDataLayer) then in MyDataLayer the data is...
Read more

Can I receive data from .rdlc Report Parameters?
I have a VS 2010 Report, and I would like to pass values that are calculated inside of one .rdlc report to another. Can I somehow use the Parameters to send data back out of the report, or have some...
Read more

Pentaho data integration "get file names" not loading big list of files
I have some big amount (more than two lakhs) of pdf files in a remote drive like \remote\location. Now I have to read all file names from that directory and insert the file names into database. I have tried "get...
Read more

cassandra reporting through pentaho report designer PRD error
I've been trying to generate a report from data in Cassandra. The data is read from the output of a data integration tranaformation. When i try to preview the data report designer throws an exception. The stack trace is given...
Read more

Pentaho Data Integration - Pass dynamic value for 'Add sequence' as Start
Can we pass any dynamic value (which is the max value of another table column) in "Start at Value" in ADD Sequence step. Please guide me....
Read more

Pentaho Kettle Data Integration Parent Child Solution required
I have a source table (from a MS DB) that contains a field "ParentID", which references the PK of "ID" The target Postgres table is filled (new "ID" PK inserted from sequence) and the "ParentID" is set to null. The...
Read more

Alternate editor (emacs/vim) in Pentaho Data Integration (Kettle)
I am new to kettle (Pentaho Data Integration) and am trying to develop some custom Java/JavaScript code. Is it possible to either edit the text blobs in emacs/aquamacs/vim/anything-else and/or save the scripts in separate files that can be directly edited...
Read more

Pentaho Data Integration (Kettle) Supported I/O Formats List
I'm wondering where I can find an official list of supported I/O formats for Pentaho's Data Integration product. ...
Read more

How to get access to google analytics data API using Pentaho PDI (Kettle version 4.2.1)
When I use the Google Analytics Input Step, all I have to enter is my account username and password for the Authorization. From there, the step looks up the Domain Table ID for me. So by just giving this step...
Read more

Does anybody know the list of Pentaho Data Integration (Kettle) connectors list?
I am doing comparison between three open source ETL tools Talend, Kettle and CloverETL. I could find with no problem Talend and CloverETL's connector list. But, I cannot find the one for Kettle. Does someone knows them or where can...
Read more

Recursive calls in Pentaho Data Integration
Is it possible for a step or transformation in Pentaho Data Integration to call itself, passing the results of the previous call as parameters/variables? My first thought was to create a loop in a transformation, but they don't seem to...
Read more