Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: how to build a drill-down report without using a cube

  1. #1

    Default how to build a drill-down report without using a cube

    Hi everyone. I'm new on Pentaho and I'd like to know if it is possible to build a drill-down report directly wih a query, not building a cube.

    for example: I've got my query

    select country, region, city, sum(amount)
    from table1
    group by country, region, city

    and I'd like to get a report that allows me to drill between the different fields.
    Could anyone tell me if it is possible and how can I do that?

    THANKS a lot in advance.

  2. #2
    rhasija Guest

    Default Using Mondrian (cubes) to get multiple level data

    As per my knowledge, Mondrian provides an easy way to perform what you are really aiming at. I do not think there is any other way besides cubes to do what you are aiming at!

    Is there any specific reason why you do not want to use Mondrian? I have a simple example that I can attach if you would like?


  3. #3
    Join Date
    Dec 2005

    Default Drill report with Pentaho Reporting

    Hello Carolina,

    you can do that with the reporting engine, too, but you need to create three reports. With links and paramters you mimick the drill-down functionallity.

    You need one report each for country, region (gets country as parameter) and city (gets region as parameter) respectively.

    The items in the country and region report need links to their drill-down report.

    The region and city report need to use the parameter, which is passed from the parent report, in their SQL and maybe in the title.

    Here are links to some related forum entries:

    As rhasija already said, this all comes out-of-the-box using a cube. Using the above approach comes in handy, when the drill down reports have a totally different report layout or you want to show additional data.

    Best regards,
    Last edited by ingo.klose; 10-18-2007 at 05:07 AM.

  4. #4
    Join Date
    Nov 2008



    I am new to pentaho and the reporting tools. I want to create a drill down in my reports. Is design studio is the place where we can create the drill down?

    I have been experiencing problems in connecting the schema workbench to the MYSQL database....

    Is there any problems with JDBC driver connectivity???

    kindly look into the issue......

    Thanks in advance

  5. #5

    Smile Drilldown in Pentaho Reporting

    Hi Can any one help me in implementing the drilldown by step wise, cleary


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.