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

Extension Points in Pentaho CDE

Hi Guys,

 

Here I am coming back to share with you one more useful information in Pentaho CDE.

 

How to use extension point in pentaho CDE 

Pentaho CDE tool, Extension points are very useful feature. You can treat this extension points as a advance setting or property of CCC Bar/Pie/any chart. By setting this extension points you can achieve the below sample thing like..

• Change the X axis Label
• Change X axis label fonts , COLOR , alignment (vertical , diagonal).
• Same way you can change the Y axis lables/fonts.

Problem1: How can I rotate x axis labels diagonally in CCC Bar chart with help of extension points.

   Solution:   In CDE, Open the related CCC chart component, click on the “Advance Properties”

    that component and select the extension points, it will open the one popup window 

         Add below extension point to rotate the x Axis lables.

 

·                  Arg0: xAxisLabel_textAngle       Val0:  -0.8   

·     

                   Arg1: xAxisLabel_textAlign        Val1:  right  

          

        Problem2: How can set Y axis fonts and color of labels.

     Solution:   In CDE, same way set below extension points ,

            Arg0: xAxisLabel_font                Val0:  13 px Arial

            Arg1: xAxisLabel_textStyle        Val1:  blue 

     We can set the number of extension point for setting Advance Property of the CCC Component

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

Sumit Bansal