Passing Dynamic IP address in Pentaho Drill down Reports

Hi Friends,

I am going to explain today about how to specify dynamic IP address in pentaho drill down reports.


For example, I have a Parent-report.prpt and child-report.prpt, Now If I want to create drill down from Parent report to child report. we have to use the drill down function where we manually browse the Child report.

Once you manually browse the child report the drill down function looks like below function:


=DRILLDOWN("remote-sugar"; "http://192.168.10.104:8081/pentaho"; {"country"; [COUNTRY] | "::pentaho-path"; "/public/TEST/sub-report.prpt"})


In the above sample function when ever you try to drill down from parent report to child report, you will definitely redirect to specific path only.

 If you deploy the code on to another server.  And when you drill down from parent report to child report then it will automatically navigate to hard code IP Address. So to avoid this we have to specify environment variables available in the pentaho.

So you have to specify drill down function something like below function:

=DRILLDOWN("remote-sugar"; ["env::pentahoBaseURL"]; {"country"; [COUNTRY] | "::pentaho-path"; "/public/TEST/sub-report.prpt"})



Note:  This is a sample function only.
you have to configure web.xml with proper IP Address.


<context-param>
<param-name>fully-qualified-server-url</param-name>
<param-value>http://192.168.10.104:8080/pentaho/</param-value>
</context-param>

When you use drill down functionality with ["env::pentahoBaseURL"] , it will take URL specified in the web.xml