BootStrap In Pentaho CDE

Hello Guys

First of All I really thanx for Harris Ward (@hazamonzo) of Ivy Information Systems to provide a great webinar and It’s really help full to use of Bootstrap in Pentaho CDE for making responsive dashboard.

Also i would like thanx to Pedro Alves and Diethard Steiner.  to provide such information.

In this blog you will Learn how to create a simple but stunning and mobile compatible dashboard using the CDE and Bootstrap framework. 

Why Bootstrap:

The most popular front-end framework for developing responsive, mobile first fluid grid system that appropriately scales up to 12 columns as the device or viewport size increases.

CDE Version:

You must install the latest trunk version  in pentaho CE  5.

In the marketplace, click to open "Community Dashboard Editor" (click over the app name, don't click the install /uninstall button) and go to version button (down-left) and choose Trunk-snapshot.

Step:

1) Click on the setting icon in the main menu and change the dashboard type to Bootstrap.

2)    Layout Structure:

With Bootstrap, the total span size of the page is 12 columns (as opposed to Blueprint, which has 24 columns).

Span Size=12/No. of columns

3) Adding Table Component

4) SQL Query:

 

 After that Save the Dashboard and check the preview

OutPut:

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal

 

ERROR_0002 - Unable to get the list of connections in pentaho CE 5.0.1 when changing the configuration files from HSLQDB to MySQL

Hello Guys,

In this post I would like to explain Unable to get the list of connections in Pentaho CE 5.0.1 when changing the configuration files from HSLQDB to MySQL.

Problem:

I've similar problem with Pentaho 5.0.1 istalled on Linux Ubuntu and MySql5.

I followed instruction on this link http://anonymousbi.wordpress.com/201...llation-guide/ to connect data to mysql.

I can create by user console new data source but i can't publish new report, metadata, cube (using new version application prd, pmd, psw) on server.

Additionally, if i open on user console --> Browse File --> Folder --> Public --> Steel Wheels --> Reports it remain in loading and don't load anything.

Pentaho Log:

2014-04-03 17:50:20,753 ERROR [org.pentaho.platform.dataaccess.datasource.wizard.service.impl.ConnectionServiceImpl] ConnectionServiceImpl.ERROR_0002 - Unable to get the list of connections: DatasourceMgmtService.ERROR_0004 - Error occurred during retrieving the datasource . Cause: exception while getting children for folder with id "b52d2785-5091-4376-beaa-ab01caf91af5"

Solution:

It seems to be working now. Somehow, when changing the configuration files from HSLQDB to MySQL, something went broken with the samples, so the steps i did to resolve the issue were:

• Stop pentaho server
• Remove or rename folder /pentaho-solutions/system/jackrabbit/repository
• Start pentaho server

It all seems to be working fine now.

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal

Removing MySQL 5.5 Completely

Hello Guys,

In this post I would like to explain How to uninstall Mysql from ubuntu 12.04 completely.

Command:

• sudo apt-get remove --purge mysql-server mysql-client mysql-common
• sudo apt-get autoremove
• sudo apt-get autoclean
• sudo deluser mysql
• sudo rm -rf /var/lib/mysql

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal

How to hide .CDA file in Pentaho CDE.

Hello Guys,

In this post I would like to explain How to hide .CDA file in Pentaho CDE.

It’s no use to the end user to see the data source in the tree view so edit:

Go to:  ../biserver-ce/pentaho-solutions/system/cda/plugin.xml

And comment the lines between:

<!–
<content-types>
…
</content-types>
//–>

For your reference the content type tag look like this:

<content-type type="cda" mime-type="text/html">
            <title>Data Access</title>
             <description>Community Data Access File</description>
            <icon-url>content/cda/resources/cdaFileType.png</icon-url>
            <meta-provider>pt.webdetails.cda.CdaFileMetaProvider</meta-provider>
              <operations>
                <operation>
                      <id>EDIT</id>
                    <perspective>cda.edit</perspective>
                </operation>
                <operation>
                      <id>RUN</id>
                </operation>
                <operation>
                      <id>NEWWINDOW</id>
                </operation>
              </operations>
        </content-type>

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal

Pentaho Report (PRPT) Component in CDE

Hi Guys…

In this section I am here by explaining you how to render a simple Report within our dashboard.

The Layout

Create your layout

Set the row height to 800 for this sample

The Data Source

We do not have to define a Data Source this time as it is already defined within the Pentaho

Report itself

The Report Component

Open the Components Tab

Expand the Other Component Group

Add the PRPT Component to the dashboard

Set the HTML Object

Time to select what report we want to render. Our report is stored in:

steel-wheels/reports/Product Sales.prpt

Set Action to Order Status.prpt

Set Solution to steel-wheels

Set Path to reports

Save and Preview

We should be looking at our Product Sales Report rendering within a CDE dashboard.

OutPut:

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal
 

Advance Property of CCC Chart Using Extension Points in Pentaho CDE

Hey Guys..

I am here by share you some advance setting or property of CCC Bar/Pie/any chart.I hope so it will be useful for someone who want to customize the chart property.

Title Label Properties

Extension points	Sample Value	Example	Description.
titleLabel_font	20 px serif	Arg0: titleLabel_font Val0: 13 px serif	For change the Title Label  fonts , Please note that title will be set by the “Title” Property
titleLabel_fillStyle	blue	Arg0: titleLabel_fillStyle Val0: blue	­-
titleLabel_textAngle	-0.2	Arg0:titleLabel_textAngle Val0:  -0.2	To rotate the title label.
titleLabel_textAlign	left	Arg0: titleLabel_textAlign Val0:  center	To Change the alignment , possible value are “left” , “center” ,”right”
titleLabel_textBaseline	top	Arg0: titleLabel_textBaseline Val0: top	Base line of text , possible values are “top” and “bottom”
titleLabel_textStyle	blue	Arg0: titleLabel_textStyle Val0:  blue	To change the color of the text , you can also specify the color code in hexadecimal.
titleLabel_text	-	Arg0: titleLabel_text Val0: Function(d) { return d.substr(3); }	Use for dynamic Title change, you can include any parameter over here also.

Hope this post helps someone and feel free to give comments and suggestion

Sumit Bansal

To change the Default Port Number of Pentaho Server

Hi Guys..

There are many reasons for changing the Pentaho BI Server’s default port, but one of the most common is a conflict with another server.

To change this port we need to modify the following files.

1)biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml

<context-param>
        <param-name>base-url</param-name>
        <param-value>http://192.168.60.195:8080/pentaho/</param-value>
    </context-param>

2)  biserver-ce-4.5.0-stable\biserver-ce\tomcat\conf\server.xml

<Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1" connectionTimeout="20000"

redirectPort="8443" /,>

Remember to restart BI Server

Hope this post helps someone and feel free to give comments and suggestion 
 

Sumit Bansal