<br><font size=2 face="sans-serif">Hi,</font>
<br>
<br><font size=2 face="sans-serif">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.</font>
<br><font size=2 face="sans-serif">I would appreciate any information that
could help me try this. I am using the newese 1.7.0-GA version of Pentaho</font>
<br>
<br><font size=2 face="sans-serif">thanks very much</font>
<br>
<br><font size=2 face="sans-serif">regards, dejan</font>
<br>
<br>
<br><tt><font size=2>mondrian-bounces@pentaho.org wrote on 14.07.2008 15:07:15:<br>
<br>
> Did you try to do the build instructions in the readme?</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Like I said before, this was working for an older
version of JPivot <br>
> (early 2005, v1.4?) and JBoss Portal 2.0.1. I don’t know how it will<br>
> go for current versions of JPivot and JBoss Portal.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> You will have to change the code and configurations
to make it work <br>
> in JetSpeed.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Sherman</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> From: mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org]
<br>
> On Behalf Of wzx<br>
> Sent: Monday, July 14, 2008 2:32 AM<br>
> To: Mondrian developer mailing list<br>
> Subject: Re: RE: [Mondrian] how to integrate mondrian to jetspeed?</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Hi, Sherman</font></tt>
<br><tt><font size=2>> Sorry to disturb you again</font></tt>
<br><tt><font size=2>> Do you mean that the latest vertion of JPivot
can integrate with <br>
> JetSpeed? But i still failed.</font></tt>
<br><tt><font size=2>> Also, i have read the readme.txt in JPivot. From
which it seems that<br>
> JPivot can integrate with Jboss Portlet very well , but i don't know<br>
> the way. Can you give some detailed info.Following is the readme.txt<br>
> file's content. Thanks</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> 1. Overview<br>
> -----------</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> The JPivot portlet shows how to integrate JPivot
into a portal <br>
> server implementing the<br>
> JSR 168 specification. The current version only works with JBoss <br>
> Portal, due to some <br>
> specific JBoss Portal code, but the dependencies on JBoss Portal are<br>
> minimal in the code,<br>
> so porting to other portal servers should be relatively straight forward.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> As packaged, the portlet works with JBoss Portal
2.X and JBoss 4.0.<br>
> 2. Testing has been<br>
> done against JBoss Portal 2.0.1 RC1.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> The test/demonstration database assumes Microsoft
Access, but can be<br>
> easily changed to<br>
> other major open source and commercial RDBMSs.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> 2. Installation<br>
> ---------------</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Get the WCF, JPivot and jpivot_repository projects
out of the JPivot CVS.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Build WCF</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Install a binary version of JBoss 4.0.2 and
JBoss Portal. The <br>
> JBoss Portal distribution<br>
> should be unzipped into ${jboss.home}/server/default/deploy.
You will see a <br>
> jboss-portal.sar there.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Edit the JBoss Portal file in jboss-portal.sar/portal-core.<br>
> war/WEB-INF/default-portal.xml.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <property><br>
> <name>org.jboss.portal.property.layout</name><br>
> <value>2ColumnLayout</value><br>
> </property><br>
> <property><br>
> <name>org.jboss.portal.property.renderSet</name><br>
> <value>divRenderer</value><br>
> </property></font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> An example of this is in:<br>
> <br>
> src/jboss-portlet/jboss-portal/jboss-portal-war/WEB-INF/default-portal.xml</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> * Set the jboss.home Ant property in your ${user.home}/build.properties
file</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Build and deploy the jpivot-portlet-1.4.0.war
and jpivot-portlet-<br>
> theme.war with <br>
> the portlet-dist target<br>
> <br>
> * Build the demo Foodmart datatbase.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * If your database is not the default Access
one, change the query <br>
> tags in JSPS in<br>
> jpivot-portlet-1.4.0.war/WEB-INF/queries appropriately<br>
> <br>
> * Start JBoss</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Hit http://localhost:8080/portal/index.html</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> * Select JPivotPortlet from the menu. The index
screen for the portlet appears</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> 3. Design and Implementation Notes<br>
> ----------------------------------</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> The WCF framework that the JPivot framework uses
has a <br>
> RequestFilter as part of <br>
> the core JPivot servlet configuration, that serves as a controller
<br>
> to route user <br>
> interface operations to Listeners. The JSR 168 Portal server <br>
> specification does <br>
> not allow for something like servlet filters in a portlet. The JPivotPortlet
<br>
> reimplements the RequestFilter in the portal server environment to
<br>
> allow WCF and <br>
> JPivot to function.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> The charting, Excel and PDF functions in JPivot
use servlets. The <br>
> JPivotPortlet and<br>
> supporting classes reimplement those functions as portlet actions.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> JPivot relies on specific stylesheets to display
screens. The <br>
> JPivotTheme provides<br>
> a template that includes the needed stylesheets. This new theme <br>
> needs to be made the<br>
> default theme for the whole portal environment for JPivot to work.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Minimal changes were required to JPivot and WCF
in order to make <br>
> this portlet work.<br>
> Several tags had their definitions changed to allow JSP expression
<br>
> language parameters.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> 4. Known Issues<br>
> ---------------</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Clickable members are not working. You can see
this with the options<br>
> for Parameters with<br>
> Builtin Testdata and Parameters with Mondrian</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> 5. Acknowledgements<br>
> -------------------</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> JPivot was created by Andreas Muller of Tonbeller,
Germany<br>
> Mondrian was created by Julian Hyde of San Francisco, USA<br>
> JBoss Portal was created by Julien Viet, Roy Russo and team, JBoss
Inc </font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> 发件人： Sherman Wood </font></tt>
<br><tt><font size=2>> 发送时间： 2008-07-14 10:29:18 </font></tt>
<br><tt><font size=2>> 收件人： 'Mondrian developer mailing list'
</font></tt>
<br><tt><font size=2>> 抄送： </font></tt>
<br><tt><font size=2>> 主题： RE: [Mondrian] how to integrate mondrian
to jetspeed? </font></tt>
<br><tt><font size=2>> You can’t have filters in a portlet server.
</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> If you check out the JPivot source, there is
old code there for a <br>
> JPivot portlet. It worked for JBoss Portal 2.0, but you should be
<br>
> able to adapt it to the latest JPivot and JetSpeed.</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Sherman</font></tt>
<br><tt><font size=2>> Jaspersoft</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> <br>
> From: mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org]
<br>
> On Behalf Of wzx<br>
> Sent: Sunday, July 13, 2008 6:11 PM<br>
> To: Mondrian developer mailing list; mondrian@pentaho.org<br>
> Subject: [Mondrian] how to integrate mondrian to jetspeed?</font></tt>
<br><tt><font size=2>> </font></tt>
<br><tt><font size=2>> Hi, all</font></tt>
<br><tt><font size=2>> I am now working on integration from mondrian
to jetspeed. But <br>
> currently I meet a serious problem. </font></tt>
<br><tt><font size=2>> Following is added in my web.xml</font></tt>
<br><tt><font size=2>> <filter></font></tt>
<br><tt><font size=2>> <filter-name>JPivotController</filter-name></font></tt>
<br><tt><font size=2>> <filter-class>com.tonbeller.wcf.controller.RequestFilter</filter-class></font></tt>
<br><tt><font size=2>> <init-param></font></tt>
<br><tt><font size=2>> </filter></font></tt>
<br><tt><font size=2>> <filter-mapping></font></tt>
<br><tt><font size=2>> <filter-name>JPivotController</filter-name></font></tt>
<br><tt><font size=2>> <url-pattern>/testpage.jsp</url-pattern></font></tt>
<br><tt><font size=2>> </filter-mapping></font></tt>
<br><tt><font size=2>> And it works very well if this project is not
worked as a portlet in<br>
> jetspeed. But if it works as a portlet in jetspeed, it always fails.<br>
> The error message shows</font></tt>
<br><tt><font size=2>> that the JPivotController doesn’t work. But
I don’t know why. I <br>
> think may be I have written the wrong url-pattern. </font></tt>
<br><tt><font size=2>> Is there any body have integrated Mondrian to
jetspeed successfully?<br>
> Or have good idea for me.</font></tt>
<br><tt><font size=2>> Very appreciated.</font></tt>
<br><tt><font size=2>> _______________________________________________<br>
> Mondrian mailing list<br>
> Mondrian@pentaho.org<br>
> http://lists.pentaho.org/mailman/listinfo/mondrian<br>
</font></tt>