Friday, 28 March 2014

Pentaho Report (PRPT) Component in CDE



Hi Guys…

In this section I am here by explaining you how to render a simple Report within our dashboard.

The Layout

Create your layout
Set the row height to 800 for this sample

The Data Source

We do not have to define a Data Source this time as it is already defined within the Pentaho
Report itself

The Report Component
Open the Components Tab
Expand the Other Component Group
Add the PRPT Component to the dashboard
Set the HTML Object

Time to select what report we want to render. Our report is stored in:
steel-wheels/reports/Product Sales.prpt

Set Action to Order Status.prpt
Set Solution to steel-wheels
Set Path to reports
Save and Preview

We should be looking at our Product Sales Report rendering within a CDE dashboard.

OutPut:


Hope this post helps someone and feel free to give comments and suggestion

 Sumit Bansal
 

Posted by at
Labels: , ,

6 comments :

  1. Sam15 April 2014 at 01:25

    Hi Sumit,

    Can you please elaborate and explain with examples. Like some sample values for the properties defined. This will help alot. Thanks in advance

    ReplyDelete
  2. Sam15 April 2014 at 02:23

    Hi Sumit,
    I have created 1 pie chart & a data table in pentaho report designer and successfully published on server(biserver-ce 5.0.1 stable).Now, I need to make it like this: In that pie chart, it shows 2 records. Let me call it as Status A & Status B. When I click a slice named status A, it should update data table of list related to status A.

    For this to implement i have installed CDE in pentaho user console. Now, how can i put prpt file in CDE and how clicking on slice functionality be implemented?

    Can you please help me out? Thanks in advance.

    ReplyDelete
    Replies
    1. Unknown15 April 2014 at 02:49

      Read all the step as i explain already and under action option u need to define your prprt file name and also you need to define proper folder path..it should work..

      Delete
    2. Sam16 April 2014 at 02:29

      Thank you very much for your answer Sir.

      Actually i was trying to put my PRPT file in the CDE dashboard and i want to edit it by implementing click functionality to the pie chart. Is it possible to do that?

      As you mentioned that under action option it should be a prpt file name i did that. But i'm confused with the folder path options. I have no idea where to keep my PRPT file and how it should be defined in solution and path options. For now i have added PRPT file in home/admin/file.prpt. Is this a correct location to keep?

      Thanks in advance.

      Delete
  3. Unknown15 April 2014 at 02:24

    Hi Sam..
    I have already explain step step procedure how to do...Also for your reference i will be provide you example soon..

    ReplyDelete
  4. Kuldeep Dwivedi10 October 2014 at 04:32

    > Create a prpt report without parameters and publish in /home/xyz repository.
    > Run the report from PUC works fine.
    > Create dashboard by using CDE.
    > Call the prpt from Execute prpt component having solution: home, path: xyz , action: test.prpt.
    > Run the dashboard in any browser and click on execute button.

    ReplyDelete

Subscribe to: Post Comments ( Atom )