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