How to add JNDI data source in Pentaho BI 5.0.1

Until Pentaho BI version 4.8 CE there was an option to add JNDI (Java Naming and Directory Interface) as a data source. But, in the newer version of Pentaho BI 5.0.1 CE version it was taken out. So, the simple-jndi will not work anymore on new version of Pentaho BI 5.0.1 CE.

Still we can use JNDI connection to the database. For this you need to create the data source in Tomcat server itself which will be active through out life cycle of Pentaho BI.

The Steps to perform this is given below:

(Please note that the example given below is used to configure JNDI for MySQL database)

1. First, Stop the tomcat server (Pentaho BI Server) running
2. Edit the file tomcat/webapps/pentaho/WEB-INF/web.xml
3. Insert the code snippet given below just after this line

<!-- insert additional resource-refs -->

<resource-ref>
    <description>DataSourceName</description>
    <res-ref-name>jdbc/myDataSource</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

4. Save the file and exit.

5. Now, edit another file in tomcat/conf/context.xml 
6. Anywhere inside of the  element, add the XML snippet shown below:

    <Resource name="jdbc/myDataSource"

    auth="Container" type="javax.sql.DataSource"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory" 
    maxActive="20" 
    maxIdle="5"
    maxWait="10000" 
    username="dbuser" 
    password="password" 
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://localhost:3306/DataSourceName"
    />

7. Save the file and exit.

8. Start the Pentaho BI Server and the new JNDI connection should be available

Pentaho CDE Charts - How to Suffix different sign (% or $) on Y-Axis label

In Pentaho CDE CCC2 charts - If you want to suffix a Percent sign (%) or a Dollar sign ($) on the Y-Axis label of the Charts, do the following:

1. Select the Chart Component
2. Click on the Advanced Properties
3. Scroll down till you find orthoAxisTickFormatter option. Click to edit it
4. Paste the following code:
   function percent_suffix_yaxis(per) { return sprintf('%d %', per); }
   // Note: To change to a dollar ($) sign change % to $ after %d.
5. Save the Dashboard and Preview it.