Friday, 28 March 2014

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

Monday, 3 March 2014

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