Tab Approach in Pentaho CDE

Hey Guys,

In this post i would like to explain How to use Tab approach in Pentaho CDE Dashboard.


In this example you will learn:

1) Creating Responsive Dashboard Structure
2) Tab Approach
3) lvy Gauge Component
4) Passing Parameter

Contact me for any type of  Demo or POC work Just drop a email or comment

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

Cheers..!!!!

Sumit Bansal
BI Developer

"The beautiful thing about learning is nobody can take it away from you."

lvy Gauge component in Pentaho CDE

Hey Guys,

In this post i would like to explain How to use lvy Gauge component in CDE Dashboard using pentaho 5.0.1 CE.

It's really awesome component and easy to explore..

First you need to install lvy Dashboard component from market place.


1) Create the layout as per your requirement.


2) You will find lvy IS left down corner and  Take Gauge component:

3) Datasource:

Here i have created one drop down in that drop down i have defined the employee id ..based on selection it will display the employee name and salery.

Your result set should be like this..

Name Salery
-----------------
Sheri   80,000

 

i.e., it'll take  2 columns ..first column is string like value and the next would be a numeric...

4) Out put:

Note: For Customization the style you need to add some property of Gauge chart under the extension point section : http://justgage.com/

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

Sumit Bansal
BI Developer
"The beautiful thing about learning is nobody can take it away from you."

Inserting images for dashboards in pentaho CDE

Hey Guys,

In this post i would like to explain How to insert image in CDE Dashboard using pentaho 5.0.1 CE.

1)Add Image Functionlity

2)Using HTML Tag

3)Using CSS

Example:

1) Using Add Iamge Functionlity

Assuming that your image is located in Public -> mySolution -> images -> logo.png:

/pentaho/api/repos/:public:mySolution:images:logo.png/content


2) Now, Add HTML tag to a column and in the HTML code give the following, code which refers the location of your image is located in Public -> mySolution -> images -> logo.png:

CODE in HTML tag:
<div class="test">

<img src="../../../api/repos/public:mySolution:images:logo.png/content" />

or

<img src="/pentaho/api/repos/:public:mySolution:images:logo.png/content" />

</div>

3) Using CSS:

.test
{

background:url('/pentaho/api/repos/:public:mySolution:images:logo.png/content');

}



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

Sumit Bansal
BI Developer
"The beautiful thing about learning is nobody can take it away from you."

How to Render D3 Chart in Pentaho CDE

Hey Guys,

In this post i would like to share my experience It really awesome work with Pentaho C-Tools along with D3 charting library..

You just need to Install D3 components plug-in from market Place.

In this example you will learn:

1) How to render d3 chart in Pentaho CDE

2) How to pass the parameter in D3 chart

3) How to add Legend in D3 chart

4) How to add chart Title along with X-axis and Y-axis label.

Image 1: Bar chart render using D3 library

Image 2:By clicking the value from the drop down particular action will be happen

Code will be updating soon..

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

 

Cheers..!!!!
 

Sumit Bansal
BI Developer

"The beautiful thing about learning is nobody can take it away from you."