Pentaho Saiku CE plugin - Change Asterisk CrossJoin in CrossJoin Classic

Saiku plugin is (maybe) the most used plugin in Pentaho CE. I like this plugin, but in 3.x version the developers, use for CrossJoin the asterisk (*) operator as a shorthand for crossjoin. It's easy, clean, but when i put more then 4 dimensions the query takes to much time against the classic CROSSJOIN().


To achieve old functionality I've modified 2 files in saiku-query library: src/main/java/org/saiku/query/ and src/main/java/org/saiku/query/
protected static CallNode generateCrossJoin(List selections, boolean nonEmpty, boolean asterisk) { String crossJoinFun = "CrossJoin"; ParseTreeNode sel1 = selections.remove(0); if (sel1 instanceof MemberNode) { sel1 = generateSetCall(sel1); } if (selections.size() == 1) { ParseTreeNode sel2 = selections.get(0); if (sel2 instanceof MemberNode) { sel2 = generateSetCall(sel2); } return new CallNode( …

SmokePing integrate with Observium

Observium is a low-maintenance auto-discovering network monitoring platform supporting a wide range of device types, platforms and operating systems including Cisco, Windows, Linux, HP, Juniper, Dell, FreeBSD, Brocade, Netscaler, NetApp and many more. Observium focuses on providing a beautiful and powerful yet simple and intuitive interface to the health and status of your network.

SmokePing keeps track of your network latency:
Best of breed latency visualisation.Interactive graph explorer.Wide range of latency measurement plugins.Master/Slave System for distributed measurement.Highly configurable alerting system.Live Latency Charts with the most 'interesting' graphs.Free and OpenSource Software written in Perl written by Tobi Oetiker, the creator of MRTG and RRDtool

JsonExport - plugin to generate XLS/XLSX from EXTJS Grid

JsonExportis a helper class who help you to generate data to use with PHPExcel to generate XLS/XLSX files.

Is based on Ext.ux.grid.Printer .

I create this plugin because i needed to export xls/xlsx from a ExtJS grid generated from a json feed.

JsonExportare two parts: client side (JsonExport.js) and server side (export_xls.php)

To setup you must define a button in your with a handler and an url to server-side file (export_xls.php)

Let's start with an example.

1. Setup path to Ext.ux location in your javascript.

Ext.Loader.setConfig({ enabled: true, paths: { Ext: '.', 'Ext.ux': '../ux' } });
2.  Add Ext.Require Before the Grid code.
Ext.require([ 'Ext.ux.grid.JsonExport' ]);

3. Create your grid.
var grid = Ext.create('Ext.grid.Panel', { store: store, stateful: true, stateId: 'stateGrid', columns: [ {text: 'Company',dataIndex: 'company'}, …

Alfresco Add User In Sites with cURL

Sometime you need to add a user or more to one or many site in your Alfresco Share without web interface or without sending invitation.
Every site have some predefined roles:  "SiteManager", "SiteCollaborator", "SiteContributor", "SiteConsumer" . (
1. site ID 2. username(s) 3. role type 4. cURL

I want to add an user test_user in site "My Test Site" with site ID "mytestsite" with Consumer role:
curl -X POST -uadmin:password "http://alfresco:8080/alfresco/service/api/sites/mytestsite/memberships" -H"content-type: application/json" -d "{"role":"SiteConsumer","person":{"userName" : "test_user"}}"

If all is OK the server respond with:
        "role": "SiteConsumer",

Multiple selection in Pentaho CDE Dashboard, part 1

There are many ways to create a selector with multiple selections în Pentaho 5 with CDE, but this one works well for what i want.

JPivot Deprecation Warning

In this post i'll show you how to hide the JPivot deprecation warning message in Pentaho Community Edition.

For Pentaho CE 4.5 - 4.8 edit [pentaho_path]/biserver-ce/tomcat/webapps/pentaho/jsp/Pivot.jsp

Find this text:

<divid="deprecatedWarning"style="margin: auto; width: 100%">   <tablewidth="580px"align="center"style="background-color: #fffdd5; border-style: solid; border-color: #dcb114; border-width= 1px; font: normal .85em Tahoma, 'Trebuchet MS', Arial">    <tr>     <td>       <imgsrc="./jpivot/navi/warning.png"/>      </td> <td> JPivot has been replaced by Pentaho Analyzer.<br/> It is provided as a convenience but will no longer be enhanced or offically supported by Pentaho. </td>    </tr> </table> </div>
Comment or remove.

For Pentaho 5.x edit [pentaho_path]/biserver-ce/pentaho-solutions/system/pentaho-jpivot-plugin/settings.xml

Find this text:


Extjs 4 TreePanel - PHP - MYSQL (Simple Tutorial)

This article will cover the use of the tree.Panel object with PHP and MySQL. This is a simple tutorial.

 1. MySQL table with examples data
 2. Javascript code for tree
 3. PHP code for take the data from database
 4. HTML