Posts

Pentaho/R Integration Plugin

Image
http://dekarlab.de/wp/?p=5 Pentaho R Integration Plugin is used to execute R code direct from Pentaho Data Integration (PDI). R Script Plugin can be downloaded here:  Downloads Installation R script plugin can be installed by performing the following steps: 1) Copy the plugin folder (RScriptPlugin) into the folder of your PDI installation: data-integration\plugins\steps 2) Install R project from the site http://www.r-project.org/ 3) Install rJava package in R by executing: install.packages(“rJava”) 4) Copy JRI library rJava/jri/jri.dll (windows) or rJava/jri/libjri.so (linux) to: data-integration/libswt/{your operation system} 5) Specify location of R using R_HOME environment variable. (like: C:\R\R-3.0.2). 6) For windows, it is also needed to put in PATH variable the path to R.dll, for example: C:\R\R-3.0.2\bin\{your operation system} 7) The plugin can be found under Sripting Folder in Design Tab: Note: to check the installation press Hel...

Debunking GROUP BY myths

http://rpbouman.blogspot.co.uk/2007/05/debunking-group-by-myths.html

Maintain the Pentaho BA 5.0 Server Manually

https://help.pentaho.com/Documentation/5.2/0P0/000/050 http://infocenter.pentaho.com/help/index.jsp?topic=%2Fadmin_guide%2Ftask_config_baserver_manually.html \biserver-ce\tomcat\webapps\pentaho\mantle\home\content\welcome\index.html comment line no 27 to 37 for unvisible Learn, Contribute, Meet the Family \biserver-ce\tomcat\webapps\pentaho\mantle\home\content\welcome\img add your logo in above path and add image path in line no 27     <div class="header-navigation">         <img src="img/company_logo.png">     </div>        \biserver-ce\tomcat\webapps\pentaho\jsp\PUCLogin.jsp

Create your own app for the Pentaho BI/BA Server

http://diethardsteiner.blogspot.in/2014/02/sparkl-create-your-own-app-for-pentaho.html

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,a...

Performance tuning settings for Pentaho Reporting

https://www.on-reporting.com/blog/performance-tuning-settings-for-pentaho/

remember if Alfresco Audit Analysis and Reporting plugin installed

Installed Alfresco Audit Analysis and Reporting with branch Limited This plugin requires CDA and CDE installed in the Pentaho BIServer and has been developed using Sparkl. All the configurations, logs, sources and scripts are stored in the AAAR folder. Several actions are performed during installation, in particular: - Creation of 2 database schema (one as Kettle repository and one as AAAR Data Mart). - Creation of a new JDBC data source in the Pentaho Server. - Creation of a repository structure with dashboards and reports installed inside. - Update of script stored into the file system.