Thursday, October 24, 2013

max_allowed_packet error in mysql



Caused by: java.sql.BatchUpdateException: Packet for query is too large (1434172 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.


The max_allowed_packet variable can be set globally by running a query.
However, if you do not change it in the my.ini file (as dragon112 suggested), the value will reset when the server restarts, even if you set it globally.

To change the setting for everyone until the server restarts:
SET GLOBAL max_allowed_packet=1073741824;

Wednesday, October 23, 2013

CDE CCC charts

http://redmine.webdetails.org/projects/ccc/wiki/FAQ_Main_Changes_New_Features_CCC_v2

http://forums.pentaho.com/showthread.php?150582-Bar-chart-colors-dynamically-changed-based-on-data-value-Along-with-JavaScript-vars/page2

http://www.webdetails.pt/ctools/charts/jsdoc/symbols/pvc.options.charts.Chart.html#clickAction



Property       Type Description
scene pvc.visual.Scene A scene is a node in a rendering hierarchy. Rendering generally follows the shape of a scene hierarchy. Each scene contains participating datums and vars (see below).

 function a(scene){
 this.scene.vars.series.value                  //for retrieving series value
this.scene.vars.category.value               //for retrieving category value
}

Tuesday, October 22, 2013

Creating Dashboards with CDE

Creating Dashboards with CDE

  http://helicaltech.com/blogs/tag/pentaho-cde/

Date Input Controls/ Components in Pentaho CDE with a working example

          http://helicaltech.com/blogs/175/

http://type-exit.org/adventures-with-open-source-bi/2011/06/creating-dashboards-with-cde/ 

 

http://pentahohispano.blogspot.in/2011/07/como-hacer-cuadros-de-mando-v.html

 

http://translate.google.co.in/translate?hl=en&sl=es&u=http://pentahohispano.blogspot.com/2011/07/como-hacer-cuadros-de-mando-v.html&prev=/search%3Fq%3Dcde%2Bdashboards.firechange%26client%3Dfirefox-a%26rls%3Dorg.mozilla:en-US:official%26biw%3D1024%26bih%3D674

 

http://mbostock.github.io/protovis/


http://www.osbi.fr/vos-tableaux-de-bords-pentaho-avec-les-ctools/

Dynamic coloring of PRD Charts

http://type-exit.org/adventures-with-open-source-bi/2011/05/dynamic-coloring-of-prd-charts/


Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...