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. ^_^