Tranparent Pentaho Dialog in Pentaho Administration Console

I am glad to know that the latest edition Pentaho BI Server – Community Edition today, 3.9.0, have a new visual interface (check and download the latest Pentaho BI server from

Here the screenshot on Pentaho User Console (PUC), pentaho bi server 3.9

But Pentaho Administration Console (PAC) not updated, even now pentaho dialog box display transparently when I adding new database connection, pandazen-pentaho pac

I try to do some experiments (ie. check the html code in the PAC) to outsmart the above problem,

  1. add 1 line css style

    .pentaho-dialog { background-color: #00ccff;}

    to PentahoAdminConsole.html

    the result,

  2. use Onyx style,
    1. copy folder “onyx” from “pentaho-solutions\system\common-ui\resources\themes\onyx” to “administration-console\www\org.pentaho.pac.PentahoAdminConsole”
    2. <link rel=”stylesheet” href=”onyx/globalOnyx.css” type=”text/css”>

the result,

Pentaho – Steel Wheels – Analysis – Market Analysis By Year Error

When I click Market Analysis By Year on Steel Wheels | Analysis, I got this error message :

Error Occurred While getting Resultset
An error occurred while rendering Pivot.jsp. Please see the log for details.

So the solution I found :
1. use “Pentaho Schema Workbench”
2. open “steelwheels.mondrian.xml” on “D:\pentaho\pentaho-solutions\steel-wheels\analysis”
3. fix all invalid error messages, like : “Schema must be set, Table DIM_TIME is invalid, Hierarchy is invalid, Table ORDERFACT is invalid, Cube SteelWheelsSales is invalid”
4. publish to
url = http://localhost:8123/pentaho/
location = /steel-wheels/analysis
name = analysis_customers.analysisview.xaction

Then I click again the link, it’s work now, so the “Product Line Analysis”

Tomcat – Pentaho : ‘docbase’ did not find a matching property

I’ve been using Pentaho “biserver-ce-3.8.0-stable” run on Tomcat 7. But everytime I start Tomcat, show some message like this:

May 11, 2011 3:02:13 PM org.apache.catalina.startup.SetContextPropertiesRule begin
WARNING: [SetContextPropertiesRule]{Context} Setting property ‘docbase’ to ‘webapps/pentaho/’ did not find a matching property.

So to get rid of this warning message, I delete



<Context path=”/pentaho” docbase=”webapps/pentaho/”>

in “webapps\pentaho\META-INF\context.xml”. Now, I see Tomcat run smoothly (“INFO: Deploying web application directory pentaho”). ^_^

Warning On Startup Tomcat – Pentaho

Whenever I start Tomcat to work with Pentaho, I always got like this warning error :

May 11, 2011 1:50:48 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles

INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role>

The solution is to add <security-role> to ” tomcat\webapps\pentaho\WEB-INF\web.xml”,after the <security-constraint> tag.


<description>security role assignment for Non-Existent Role – this prevents direct access to JSPs</description>



Pentaho User Console Login Bug on Firefox 4

After I simply login, I get this error message

Error generating XUL: Failed to parse: <?xml version=”1.0″ encoding=”UTF-8″?>
<?xml-stylesheet href=”chrome://global/skin/” type=”text/css”?>
<window width=”400″ hei

The temporary solution I found is to use firefox addon Remote Xul Manager, after installation, restart firefox and then add pentaho-host to the list of “Domains with remote XUL permission”.

I will try to find another solution from the server side. ^_^

Error on Mondrian – JPivot pivot table by XMLA

I have installed Mondrian with environments :
– Apache Tomcat 6.0.26 on port 8123 (D:\oss\apache-tomcat-6.0.26)
– Java version 1.6.0_17 (C:\Program Files\Java\jdk1.6.0_17)
– Access Database with ODBC MondrianFoodMart (D:\pentaho\mondrian\demo\access\MondrianFoodMart.mdb)

I run on http://localhost:8123/mondrian/, i see :
Mondrian examples:

* JPivot pivot table
* JPivot pivot table by XMLA
* JPivot with 4 hierarchies
* JPivot with role ‘California Manager’ set
* JPivot with arrows
* JPivot with colors
* Various queries formatted using the Mondrian tag-library
* Basic interface for ad hoc queries
* XML for Analysis tester

Other links:

* Mondrian home page
* Mondrian project page
* JPivot home page
* JPivot project page

Every Mondrian examples link is OK, except JPivot pivot table by XMLA

I’ve search and found a lot of discussion about this issue, but the most help are the following link :

rem for JDK 1.6 – force the use of Axis for SOAP not the internal JDK web services implementation

rem for JDK 1.6 – use xalan, not JDK 1.6 internal Xalan implementation


add the following jars into mondrian web app library :
– axis-1.4.jar
– commons-discovery-0.4.jar
– jaxrpc-api-1.1.jar
– wsdl4j-1.6.2.jar

Below the error when i click JPivot pivot table by XMLA

Continue reading