Nilesh Patil's blog

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

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

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

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

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

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

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.

INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role> add following configuration before close   </security-constraint> <security-role>         <description>security role</description>         <role-name>PENTAHO_ADMIN</role-name>     </security-role>

Installed Pentaho Repository Synchronizer with branch Trunk This plugin copies a version of libpensol.*.jar to the server's WEB-INF/lib. It's possible that on Windows boxes there's an error upgrading the repositorySynchronizer. If that happens, stop the server and delete the WEB-INF/lib/libpensol.* jar file(s)

To hide the .CDA files, its no use to the end user to see the datasource in the treeview so edit: biserver-ce/pentaho-solutions/system/cda/ plugin.xml And comment the lines between: <!– <content-types> … </content-types> //–>

http://stackoverflow.com/questions/1...select-limit-1 mysql> select VERSION(); +--------------+ | VERSION() | +--------------+ | 5.6.13-log | +--------------+ 1 row in set (0.00 sec) mysql> SET OPTION SQL_SELECT_LIMIT=10; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=10' at line 1 mysql> select VERSION(); +------------+ | VERSION() | +------------+ | 5.5.11 | +------------+ 1 row in set (0.00 sec) mysql> SET OPTION SQL_SELECT_LIMIT=10; Query OK, 0 rows affected (0.00 sec)Older versions of MySQL employed SET OPTION, but this syntax is deprecated in favor of SET without OPTION. You should just use SET SQL_SELECT_LIMIT=10; instead. Incompatible Change: The obsolete OPTION modifier for the SET statement has been removed.

Dynamic pivot tables (transform rows to columns)   in MySql there is no function of automatically table transformation. Surely we can use some program (tool), which is able to connect to MySql and execute data transformation. But in this case we want to do it manually, and we have one variant – to write a query which will execute the data rotation in the table   http://buysql.com/mysql/14-how-to-automate-pivot-tables.html   http://stackoverflow.com/questions/10925445/mysql-select-dynamic-row-values-as-column-names-another-column-as-value   http://stackoverflow.com/questions/10986031/sql-dynamic-view-with-column-names-based-on-column-values-in-source-table?rq=1

http://type-exit.org/adventures-with-open-source-bi/2011/05/dynamic-coloring-of-prd-charts/

http://diethardsteiner.blogspot.in/2012/11/stylesheets-with-pentaho-report-designer.html

http://pentahoreportingandintegration.blogspot.in/2013/04/pentaho-report-integration-in-iframe.html http://jira.pentaho.com/browse/BISERVER-8090 http://jira.pentaho.com/browse/BISERVER-4067 forum issue

http://woodlouse.blogspot.fr/2013/02/how-to-create-pentaho-report-using-rest.html http://woodlouse.blogspot.in/2013_02_01_archive.html

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

http://forums.pentaho.com/showthread.php?26490-Getting-Help  Understanding that those of us at Pentaho are volunteering our time to help users get started with the platform, if you reach a point where reading the provided documentation and looking through the forums can't solve your problem, here's a quick best-practices way to get the most out of the forum. Start Here: http://community.pentaho.org/faq/forum_assistance.php Post information about your environment, operating system, whether you're using the Preconfigured Install (PCI), what application server you're running in, what jdbc driver you're using, what version of the platform you have, what version of the client tool you're running, etc. If you're using Tomcat for example, we need to know the exact version of Tomcat you're running. We also need to know the JDK version. Without all this information, we just have to turn around and ask you what you're running. This wastes...

ERROR [org.quartz.core.ErrorLogger] An error occured while scanning for the next trigger to fire.org.quartz.JobPersistenceException: Couldn’t acquire next trigger: Field ‘PRIORITY’ doesn’t have a default value [See nested exception: java.sql.SQLException: Field 'PRIORITY' doesn't have a default value] Solution :- Simply to set the DEFAULT of the column to 0 in following tables QRTZ_TRIGGERS                  COLUMN         PRIORITY          set default value 0 QRTZ_FIRED_TRIGGERS                  COLUMN         PRIORITY          set default value 0

In case you get this error Failed to obtain DB connection from data source ‘myDS’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/Quartz’ Solution :-  delete the following file toncat/conf/Catalina/localhost/pentaho.xml and try again.