[Mondrian] how to integrate mondrian to jetspeed?

wzx wzx112233 at 163.com
Tue Jul 15 04:56:10 EDT 2008

Hi, Sherman

Although JPivot works for JBoss Portal2.0.1 but i really need it works for JetSpeed.
Did you ever have JPivot and JetSpeed integrated?
As you said I shoul change the code and configurations to make it work in JetSpeed.
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 
发送时间: 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 JetSpeed.

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 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/20080715/bc331fd8/attachment.html 

More information about the Mondrian mailing list