[Mondrian] how to integrate mondrian to jetspeed?
Dejan.Gambin at coin.hr
Dejan.Gambin at coin.hr
Mon Jul 14 16:35:45 EDT 2008
Hi,
I am just one of the guys who need to integrate JPivot into JBoss Portal.
I am using Pentaho PCI, I have all the stuff (reporting, dasboards) done
in portal but I don't know (and can't find anyone who knows) how to
integrate the analysis/OLAP part of Pentaho (based on JPivot) with JBoss
portal.
I would appreciate any information that could help me try this. I am using
the newese 1.7.0-GA version of Pentaho
thanks very much
regards, dejan
mondrian-bounces at pentaho.org wrote on 14.07.2008 15:07:15:
> 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.
>
> Sherman
>
>
> 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.
>
> <property>
> <name>org.jboss.portal.property.layout</name>
> <value>2ColumnLayout</value>
> </property>
> <property>
> <name>org.jboss.portal.property.renderSet</name>
> <value>divRenderer</value>
> </property>
>
> An example of this is in:
>
>
src/jboss-portlet/jboss-portal/jboss-portal-war/WEB-INF/default-portal.xml
>
>
> * 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.
>
>
> Sherman
> Jaspersoft
>
>
> 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
> <filter>
> <filter-name>JPivotController</filter-name>
> <filter-class>com.tonbeller.wcf.controller.RequestFilter</filter-class>
> <init-param>
> </filter>
> <filter-mapping>
> <filter-name>JPivotController</filter-name>
> <url-pattern>/testpage.jsp</url-pattern>
> </filter-mapping>
> 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.
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080714/7c0bc0cc/attachment.html
More information about the Mondrian
mailing list