[Mondrian] how to integrate mondrian to jetspeed?

Sherman Wood swood at jaspersoft.com
Tue Jul 15 09:42:31 EDT 2008

See below


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of wzx
Sent: Tuesday, July 15, 2008 1:56 AM
To: Mondrian developer mailing list; 'Mondrian developer mailing list
Subject: Re: RE: RE: [Mondrian] how to integrate mondrian to jetspeed?

Hi, Sherman

Although JPivot works for JBoss Portal2.0.1 but i really need it works for

Did you ever have JPivot and JetSpeed integrated?

[Sherman Wood] No ¨C have never tried

As you said I shoul change the code and configurations to make it work in

But i don't know how to do it. Is there any document i can follow up or is
there any suggestions you can give me?

[Sherman Wood] There is no documentation apart from the readme.

There is only a small amount of JBoss specific code. This is commented.
Apart from that, the work needed will be specific to JetSpeed config and






·¢¼þÈË£º Sherman Wood

·¢ËÍʱ¼ä£º 2008-07-14  21:07:39

ÊÕ¼þÈË£º 'Mondrian developer mailing list'


Ö÷Ì⣺ RE: RE: [Mondrian] how to integrate mondrian to jetspeed?

Did you try to do the build instructions in the readme?

Like I said before, this was working for an older version of JPivot (early
2005, v1.4?) and JBoss Portal 2.0.1. I don¡¯t know how it will go for
current versions of JPivot and JBoss Portal.

You will have to change the code and configurations to make it work in



From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of wzx
Sent: Monday, July 14, 2008 2:32 AM
To: Mondrian developer mailing list
Subject: Re: RE: [Mondrian] how to integrate mondrian to jetspeed?

Hi, Sherman

Sorry to disturb you again

Do you mean that the latest vertion of JPivot can integrate with JetSpeed?
But i still failed.

Also, i have read the readme.txt in JPivot. From which it seems that
JPivot can integrate with Jboss Portlet very well , but i don't know the
way. Can you give some detailed info.Following is the readme.txt file's
content. Thanks

1. Overview

The JPivot portlet shows how to integrate JPivot into a portal server
implementing the
JSR 168 specification. The current version only works with JBoss Portal,
due to some
specific JBoss Portal code, but the dependencies on JBoss Portal are
minimal in the code,
so porting to other portal servers should be relatively straight forward.

As packaged, the portlet works with JBoss Portal 2.X and JBoss 4.0.2.
Testing has been
done against JBoss Portal 2.0.1 RC1.

The test/demonstration database assumes Microsoft Access, but can be
easily changed to
other major open source and commercial RDBMSs.

2. Installation

* Get the WCF, JPivot and jpivot_repository projects out of the JPivot

* Build WCF

* Install a binary version of JBoss 4.0.2 and JBoss Portal. The JBoss
Portal distribution
  should be unzipped into ${jboss.home}/server/default/deploy. You will
see a
  jboss-portal.sar there.

* Edit the JBoss Portal file in


  An example of this is in:


* Set the jboss.home Ant property in your ${user.home}/build.properties

* Build and deploy the jpivot-portlet-1.4.0.war and
jpivot-portlet-theme.war with
  the portlet-dist target

* Build the demo Foodmart datatbase.

* If your database is not the default Access one, change the query tags in
  jpivot-portlet-1.4.0.war/WEB-INF/queries appropriately

* Start JBoss

* Hit http://localhost:8080/portal/index.html

* Select JPivotPortlet from the menu. The index screen for the portlet

3. Design and Implementation Notes

The WCF framework that the JPivot framework uses has  a RequestFilter as
part of
the core JPivot servlet configuration, that serves as a controller to
route user
interface operations to Listeners. The JSR 168 Portal server specification
not allow for something like servlet filters in a portlet. The
reimplements the RequestFilter in the portal server environment to allow
WCF and
JPivot to function.

The charting, Excel and PDF functions in JPivot use servlets. The
JPivotPortlet and
supporting classes reimplement those functions as portlet actions.

JPivot relies on specific stylesheets to display screens. The JPivotTheme
a template that includes the needed stylesheets. This new theme needs to
be made the
default theme for the whole portal environment for JPivot to work.

Minimal changes were required to JPivot and WCF in order to make this
portlet work.
Several tags had their definitions changed to allow JSP expression
language parameters.

4. Known Issues

Clickable members are not working. You can see this with the options for
Parameters with
Builtin Testdata and Parameters with Mondrian

5. Acknowledgements

JPivot was created by Andreas Muller of Tonbeller, Germany
Mondrian was created by Julian Hyde of San Francisco, USA
JBoss Portal was created by Julien Viet, Roy Russo and team, JBoss Inc


·¢¼þÈË£º Sherman Wood

·¢ËÍʱ¼ä£º 2008-07-14  10:29:18

ÊÕ¼þÈË£º 'Mondrian developer mailing list'


Ö÷Ì⣺ RE: [Mondrian] how to integrate mondrian to jetspeed?

You can¡¯t have filters in a portlet server.

If you check out the JPivot source, there is old code there for a JPivot
portlet. It worked for JBoss Portal 2.0, but you should be able to adapt
it to the latest JPivot and JetSpeed.




From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of wzx
Sent: Sunday, July 13, 2008 6:11 PM
To: Mondrian developer mailing list; mondrian at pentaho.org
Subject: [Mondrian] how to integrate mondrian to jetspeed?

Hi, all

I am now working on integration from mondrian to jetspeed. But currently I
meet a serious problem.

Following is added in my web.xml










And it works very well if this project is not worked as a portlet in
jetspeed. But if it works as a portlet in jetspeed, it always fails. The
error message shows

that the JPivotController doesn¡¯t work. But I don¡¯t know why. I think
may be I have written the wrong url-pattern.

Is there any body have integrated Mondrian to jetspeed successfully? Or
have good idea for me.

Very  appreciated.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080715/60ad47da/attachment.html 

More information about the Mondrian mailing list