Use of Setparam() and GetParam() function for Linking Two Dashboards in Pentaho CDE

Inorder to link two dashboards using Pentaho CDE we can define two set of functions one which could set the parameters and the other where one could fetch the parameters coming from the first Dashboard using the GetQueryParameter function. Before you set the javascript in the clickaction property for the first Dashboard you should set …Read More

Return Values from Sub Dataset to Main Dataset in Jasper Reports

Return Values from Sub Dataset to Main Dataset in Jasper Reports Sometime it is required to return values from sub dataset to main report dataset but due to bug in the jasper studio we are unable to it. Please refer this bug link http://community.jaspersoft.com/jaspersoft-studio/issues/4746 Steps to return values from sub dataset to main report dataset …Read More

How to hide some items in schedule Output options tab dynamically according to Roles.

–>In this case my aim is to hide File Handling & Output Destination to the Role_user so that he cant able to save schedule to any kind of repository. –>The only thing the user can do is to send this output to their email address. –>For ROLE_ADMINISTRATOR & ROLE_SUPERUSER both can have entire access. For …Read More

SQL with Groovy .

SQL with Groovy . Groovy provides a handy way to handle jdbc when compared to java. Playing with database becomes very easy with groovy. To use SQL scripting with groovy we have to use the  groovy.sql.Sql package. import groovy.sql.Sql sql = Sql.newInstance( ‘jdbc:jtds:sqlserver://serveripName/databaseName-CLASS;domain=yourdomainname’, ‘dbusername’, ‘dbpassword’, ‘driverclass’ ) sql.eachRow( ‘select * from tableName’ ) { println …Read More

Install Hadoop on Windows

Introduction : This blog enables Hadoop users to install Hadoop on windows. As Hadoop is usually built and run on LINUX, windows installation in relatively new. The following Blog contains steps to download Hadoop and its prerequisites, install YARN based Hadoop 2.5 and above. Prerequisites : Oracle JDK versions 1.7 and 1.6 have been tested by …Read More

Date Field Format Customisation in Adhoc View on Japser UI

Date Field Format Customisation in Adhoc View on Japser UI Often while working with Adhoc Reports on jasper we get limited option for the availble date format in jasper. There are number of ways to fix this but one I am going to discuss here is by adding date format options in the backend of …Read More

Work Flow of Talend MDM

Work Flow of Talend MDM   Talend MDM stores and manages the master data. It also provides platform to do data modelling for the master data. Domains are called entities here. The data is stored into XML format or in sql in relational database. It is based on the setting made according to preference.There are …Read More

Install and setup Talend MDM

Master Data Management -MDM Master data is the mostly consistent data which is spread across the various systems in an enterprise and possibly their partners. It mostly contains Id, Code, Description and other properties which defines a particular domain. It is not the quantitative data related to a single transaction, it is not an operational …Read More

Points to remember while developing JRXML

Few points needs to remember while developing JRXML 1) Use .equals() comparison operator for String fields If you want to compare string fields then use .equals() function instead of == operator. In Java, the == operator compares if the objects are the same instance while .equals() compares the state of object. 2) JRXML Detail Band …Read More

How to avoid duplication of values in the columns in PDI if column names are same?

How to avoid duplication of values in the columns in PDI if column names are same? There can be requirements where we want same column names in the transformation (PDI). In such case the value of field is overwritten on another field. For ex: If for a company we want 3 pairs of Loan Id …Read More