[Mondrian] how to integrate mondrian to jetspeed?

wzx wzx112233 at 163.com
Mon Jul 14 05:31:58 EDT 2008

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 CVS.

* 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 jboss-portal.sar/portal-core.war/WEB-INF/default-portal.xml.


  An example of this is in:

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

* 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 JSPS 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 appears

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 does 
not allow for something like servlet filters in a portlet. The JPivotPortlet 
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 provides
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/20080714/643667b7/attachment.html 

More information about the Mondrian mailing list