Apex Luis

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(). See http://jira.pentaho.com/browse/MONDRIAN-2284 To achieve old functionality I've modified 2 files in saiku-query library: src/main/java/org/saiku/query/NodeConverter.java and src/main/java/org/saiku/query/Olap4jNodeConverter.java NodeConverter.java 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 C...

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.

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: < div id = "deprecatedWarning" style = "margin: auto; width: 100%" >   < table width = "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 >         < img src = "./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 > ...