The following content was extracted from the Support Manual compiled by Sungard Technology Services in December 2010:
How to install Pentaho and Pentaho Server?
(NOTE: for full detailed instructions on installing the Mifos Business Intelligence Suite containing Pentaho and the Data Warehouse atInstalling Mifos BI (Pentaho))
There is no need to install Pentaho the designer and server. Just unzip the pentaho installer files and copy it in your root directory. On clicking the executable files both server and designer starts.
“biserver-ce” is the name of BI- server folder.
“report-designer” is the name of designer folder.
“administration-console” is the name of administrator folder for users and roles.
How to set up Pentaho to run on different port (if Mifos is running on 8080)?
Mifos will run on your default Tomcat on port 8080. To run Mifos and Mifos BI simultaneously, you will need to change which port Pentaho runs on. To do so you must change the port to 8086 via the web.xml and server.xml files. These tips were compiled by Ramya in this mailing list discussion.
INSERT INTO DATASOURCE VALUES('SampleData',500,'org.hsqldb.jdbcDriver',5,'pentaho_user','cGFzc3dvcmQ=','jdbc:hsqldb:hsql://localhost:9001/sampledata','select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES',1000);
e) If nothing works then the final solution is to add all your subreport queries in the main report connection only, and inherit them in your sub-reports correspondingly.
How to do JNDI settings in Pentaho?
In designer to use JNDI connections. Go to your
C:\Documents and Settings\Ramya.Toshniwal\.pentaho\simple-jndi\default.properties
mifos_kmbi as shown above, will be the name of your JNDI connection which you will simply mention in your design file.
For JNDI settings on server, I mentioned earlier already.
Log on to
http://<ip address of server>:8099
Go to advanced tab
How to turn off auto-submit button in Pentaho?
By default Pentaho turns on the auto submit button as soon as you select the mandatory parameters of reports while it’s execution. This helps in simultaneously executing the validations of report parameters (especially when are cascading parameters).
There are two ways of turning off it
a) In the designer, you can set the property “auto-submit” of your report as OFF( there is a minor bug in it. To be on safer side, first check the property and then uncheck to make sure it is OFF)
b) The other way is to off it at server. Open file
Tip: Whenever you have cascading parameters in your report, do not turn off the auto submit button
The processing of parameters will not happen then. In such cases try to use list type as your parameters instead of drop downs.
How to call stored procedure/kettle files in Pentaho designer?
There are two ways of running the stored procedures
If the procedure returns a resultset, then you can use the result like any other query in the report-designer by calling it via
However, if your procedure just returns a single value and you want to combine that value with results from other procedures or queries, then you have to use Pentaho Data Integration.
In second case, create the kettle file and in your report, select the source as Pentaho data Integration. Then select the kettle file and upload it.
Tip: Remember, if your connections are JNDI type in your kettle file, you have to make the same connections in Reports JNDI file also.
Browser recommendations for Pentaho
Generally Pentaho recommends Firefox to be used. So in case if the page gets blank after clicking view report button, first of all try the following stuff on Firefox.
There is a limit of every browser. IF the data of a MFI is huge, and you are selecting the entire organization parameter values then in that case http headersize for that browser may become small too fit the requirement.
Default headersize for Firefox is 64000
Heap space error:
Whenever you get this error, increase the JAVA_OPTS environment variable value in the server and at below two locations.