Posts

Showing posts from October, 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;

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 }

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/

D3JS Dashboard

http://bl.ocks.org/diethardsteiner/3287802

Stylesheets with Pentaho Report Designer

http://diethardsteiner.blogspot.in/2012/11/stylesheets-with-pentaho-report-designer.html