Parameterised pentaho reports using ETL transformation as Datasource


Problem Statement :

Many times we come across a need to use transformation as data source for a report. Pentaho Report designer supports this kind of requirement. It allows Transformation or Job as data source. It also has support to use report parameters as transformation parameters

Scope of this Article:

This article helps you the usage of  transformation (ktr ) as data source of pentaho report.

Technology:

Pentaho Report Designer 3.6.0 GA (or) above

Details:

  • Create a table named year_val with following data

Viewdata

  • Create a transformation that reads data from year_val table for specific year and loads into a file. Year as a parameter to the transformation. Save the transformation

Viewdata

  • Open a new prpt report , Right click on data sets , select pentaho data integration . click on ‘+’ add a new data source ,give a name to it. Browse the transformation file that we created in step2.click on preview to get column name.

Viewdata

  • Get year and month fields to details, add year as parameter to prpt , go back to data source and click on ‘edit parameter’ option and add parameter’s at transformation Parameter and Transformation Arguments.

Viewdata

  • Please find the layout of prpt from below snap shot

Viewdata

  • Save and run the prpt report from PUC.

Viewdata

Summary:

This article helps you to understand in detail ,how transformation  can be used as Datasource  in PRD

Walking Tree promotes Pentaho and we support the corporates as well as the developers to ensure that the business is able to take complete advantage of Pentaho’s wonderful capability. In case you are looking for a professional assistance then do visit our website to get in touch with us.

Reference:

BI developer

Tagged with: , , , ,
Posted in Data Warehouse & BI, Pentaho

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

We Have Moved Our Blog!

We have moved our blog to our company site. Check out https://walkingtree.tech/index.php/blog for all latest blogs.

Sencha Select Partner Sencha Training Partner
Xamarin Authorized Partner
Recent Publication
%d bloggers like this: