Setting up Pentaho Report Designer for OpenERP

-
In order to generate reports from OpenERP v7 you need to have Pentaho Report Designer downloaded from Pentaho’s website and unzipped on your computer. The package is a binary package which doesn’t need installation on your computer and hence you can run it from the folder where you unzipped it.
Here are the steps that you can follow to setup and run Pentaho Report Designer to Connect to OpenERP v7 and create reports:
  1. Pentaho Report Designer v3.9.1 is available from Sourceforge.net here. Download the package which is suitable to your computer architecture. For Windows Download prd-ce-3.9.1-GA.zip
  2. You need Java JDK Version 1.6.0 and above. You can download java from www.java.com and install it on your computer.
  3. Once Java is fully installed run the file named “set-pentaho-env.bat” from Pentaho folder. This will setup your environment and then click on “report-designer.bat”. Pentaho Report Designer should run now. Close it now and move on to the next step.
  4. Report Designer is not yet ready to connect to OpenERP server. For that you need to download the following packages
    1. PRD OpenERP Data Source for v3.9
    2. PRD OpenERP Data Source Editor for v3.9
    3. OpenERP Java Report Helper (v0.10.0)
    4. OpenERP Java API v 1.2.0
    5. Apache XMLRPC Binary Libraries v3.1.3
  5. Once you have downloaded the above packages. Copy all the jar files from point 4.1 to 4.4 to the lib directory of Pentaho Report Designer lib directory.
  6. Extract Apache XML RPC Binary Package and copy the xmlrpc-client-3.1.3.jar, xmlrpc-common-3.1.3.jar and ws-commons-util-1.0.2.jar from the extracted lib directory to Pentaho Report Designer lib directory.
  7. Done!! you can now run PRD again by running the “report-designer.bat” file and start developing reports for OpenERP.

Comments

  1. UnknownJune 3, 2014 at 10:44 PM

    Hi bro,
    can i use this for drill down reports.
    i would like to use sso for pentaho is this posible using this

    ReplyDelete

Post a Comment

Popular posts from this blog

Changing the Java VM Memory Limits in Pentaho BI

-
You can find docs biserver-ce\tomcat\webapps\pentaho\docs\ Changing the Java VM Memory Limits If you are running out of memory even though your server has a lot of RAM, you probably need to increase the resources allocated to the JRE instance that runs the Pentaho software you're trying to improve performance on. Adjusting the memory limit is an easy configuration change to make, but the instructions differ depending on the client tool or Web application server you're using. Refer only to the sections below that apply to your situation. Note: If you are running multiple Pentaho programs concurrently, the sum of their JVM maximum memory limits must not exceed the available RAM minus system overhead. Increasing Memory Limits on Microsoft Windows with a Graphical Installation By default, Tomcat has a relatively low memory allotment. This can cause out-of-memory errors in the BA Server fromtime to time. The below instructions will explain how to increase the mem
Read more

error in pentaho 5.0.1 - authentication via url parameters for iframe

-
After passing userid and password in URL and page load it ask for user and password, seems pentaho server does not recognize the parameters. check here for the workaround (it's on the comments):  http://jira.pentaho.com/browse/BISERVER-10708 Workaround is to edit the system/applicationContext-spring-security.xml file and change the parameters for the filterChainProxy. Lines 22 and 23 should be replaced by:         /api/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,requestParameterProcessingFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterceptorForWS         /plugin/**=securityContextHolderAwareRequestFilterForWS,httpSessionPentahoSessionContextIntegrationFilter,httpSessionContextIntegrationFilter,requestParameterProcessingFilter,basicProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilterForWS,filterInvocationInterce
Read more

CAS with Pentaho Community Edition

-
In this week I integrate one of the most useful feature i.e. CAS (Single Sign on) with the help my collegue and online user community . So with my boss’ blessing, I decided to document what I had to do to make this work in the spirit of giving back to the community. Plus with the rising awareness of the benefits of BI even for small to medium corporations, I have no doubt that this information would be useful for someone somewhere. The need 1) CAS Server 2) Pentaho BI 3.x server (Community Edition) 3) Install certificate IMPLEMENTATION OF CAS CLIENT IN PENTAHO BI SERVER 1) \biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml make changes in applicationContext file for CAS Client. and add following jars in biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib folder 1) spring-security-cas-client-2.0.5.RELEASE.jar 2) cas-client-core-3.1.10.jar After added jars and configuration in applicationContext file then install certificate step-1) download
Read more