Is this Pentaho-Screenshot fake?

[roth]

Hi

http://www.pentaho.com/products/dashboards/

In the rightmost screenshot on the above page, we can see a pivot portlet. Is this a mash-up?

Most examples on the portlet page of the PCI open a new window. The exception is the Dashboard example, which looks almost like the above screenshot, but without the integration of the pivot table. The pivot table is opened in a separate window, so I guess that doesn't count as a portlet then.

All other links that do not open a new window show now content, that is, they show an empty portlet window.

I so far managed to display a html report in a portlet, but I didn't get a filter+report or a pivot table to work as portlets. Is this at all possible, and how?

Thanks,
Tobias

[roth]

For the filter part, I have found a solution described here:

http://wiki.pentaho.org/display/Pent...a+Filter+Panel

That leaves open the question about the pivot portlet and why most of the portal examples in the PCI aren't really portlets, but links to external content.

[mtarallo]

There are a variety of methods for delivering content in to a portal. In addition to using an .xaction sequence portlet (the ActionPortlet), some examples of reporting content can be as simple as using the portal's web portlet, iframe portlet or .jsp portlet to display external content.

The way I achieved this same example was by using a technique utlizing the message template process action component of design studio.

I used iframe code calling the Jpivot xaction url in the message template component.

Then used the ActionPortlet configured to that xaction.

<portlet>
<portlet-name>PivotActionPortlet</portlet-name>
<portlet-class>
org.pentaho.ui.portlet.ActionPortlet
</portlet-class>
<supports>
<mime-type>text/html</mime-type>
<portlet-mode>VIEW</portlet-mode>
</supports>
<resource-bundle>
org.pentaho.locale.portlet
</resource-bundle>
<portlet-info>
<title>PivotActionPortlet</title>
</portlet-info>
<portlet-preferences>
<preference>
<name>action</name>
<value>
samples/generic/pivot/mypivot.xaction
</value>
</preference>
</portlet-preferences>
</portlet>


As one continues to explore and use the Pentaho platform one will find that the only limits that are encountered are those of one's imagination.

I have worked with proprietray BI tools for over 10 years and am continually amazed at what can be accomplished with the Pentaho BI Suite.

[lfaustino]

Hello mtarallo,

You're the one that create this wonderful documentation.
Can you please explain how the integration with Liferay portal can be accomplished.
How can i add Pentaho portlets to Liferay.

Thanks in advance.

Luis Faustino

[mtarallo]

Hello Luis,

Currently, the simple and fastest method is to use the current Iframe Liferay portlet calling one of the action sequences via a URL. You could also use a JSP portlet with the Pentaho embedded content.

The programmatic way would to be use the portlets (such as the ViewAction portlet) over from the PCI (JBoss) installation and add them to the Liferay installation. There are a number of steps involved. This is something that an IT person who is familiar with Liferay and creating portlets in general would be doing.

I believe I answered a similar post of yours. Just to reiterate I believe the Liferay portlets will be available out of the box, like it is with JBoss in a future release.

Regards,

Mike Tarallo

[mbyanfei]

There are a variety of methods for delivering content in to a portal. In addition to using an .xaction sequence portlet (the ActionPortlet), some examples of reporting content can be as simple as using the portal's web portlet, iframe portlet or .jsp portlet to display external content.

The way I achieved this same example was by using a technique utlizing the message template process action component of design studio.

I used iframe code calling the Jpivot xaction url in the message template component.

Then used the ActionPortlet configured to that xaction.

<portlet>
<portlet-name>PivotActionPortlet</portlet-name>
<portlet-class>
org.pentaho.ui.portlet.ActionPortlet
</portlet-class>
<supports>
<mime-type>text/html</mime-type>
<portlet-mode>VIEW</portlet-mode>
</supports>
<resource-bundle>
org.pentaho.locale.portlet
</resource-bundle>
<portlet-info>
<title>PivotActionPortlet</title>
</portlet-info>
<portlet-preferences>
<preference>
<name>action</name>
<value>
samples/generic/pivot/mypivot.xaction
</value>
</preference>
</portlet-preferences>
</portlet>


As one continues to explore and use the Pentaho platform one will find that the only limits that are encountered are those of one's imagination.

I have worked with proprietray BI tools for over 10 years and am continually amazed at what can be accomplished with the Pentaho BI Suite.

mtarallo, thanks for this posting, it is exactly what I am trying to do: to have live JPivot view as portlet in portal.

I am very new to Pentaho action sequence and message template, after reading your answers

The way I achieved this same example was by using a technique utlizing the message template process action component of design studio.

I used iframe code calling the Jpivot xaction url in the message template component.

I kind of know which direction I should go, but not exactly, could you give more details(sample code snippet would be wonderful) on how you do this?

I do have following action definition for TemplateComponent, could you show me how to modify it to use the iframe and action sequence?

<action-definition>
<component-name>TemplateComponent</component-name>
<action-type>Message Template</action-type>
<action-inputs>
<base-url type="string"/>
<chart-filename type="string"/>
</action-inputs>
<action-outputs>
<output-message type="string" mapping="imgtag"/>
</action-outputs>
<component-definition>
<template><![CDATA[<img src="{base-url}/getImage?image={chart-filename}" />]]></template>
</component-definition>
</action-definition>

[mtarallo]

Hello mbyanfei,

Let me see what I can round up. I have been swamped in closing revenue generating business. The Pentaho Open Business Intelligence Suite is generating such a great interest, its hard to keep up.

Hope to respond shortly.

Regards,

Mike Tarallo
Senior Pre-Sales Engineer
Pentaho Corporation

[aschurman]

Hello,

I have worked with liferay and Pentaho's integration could be great.. I saw it and it is wonderful

I would like to try it out and wanted to ask a basic simple question.

Would you say Pentaho PCI and Liferay should run on separated servers? or together?

If it is together, Should Liferay be installed in Pentaho PCI or should Pentaho be installed in Liferay Bundle?

In either case please consider the User authentication part. and implications on each one.

Thanks

[dgambin]

Hi,

Can someone explain how to exactly utilize the message template component to call .xaction file with PivotViewComponent inside?

I would really like to know how to show the Pivot view in JBoss portal...

thanks very much on any information

regards, dejan

[malyvelky]

I also hope that Mike will find the time to post the .xaction fragment defining the message template action and combining it with JPivot, I§d love to see it. Regards, JH