Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Publishing Report to BI Server

  1. #1
    Join Date
    Jun 2012

    Default Publishing Report to BI Server


    We are following the below steps to publish a report to bi server:
    1. create a simple report in report designer(version 3.8) with oracle query as a datasource.
    2. Clicked on File->Publish to the local bi server.
    3. Though data is visible in report designer, only report header is visible in Pentaho User Console( no data is visible).

    Are we missing any intermediate steps while publishing the report?? Does datasource configuration/definition need to be exported explicitly?

    Thanks & Regards,

  2. #2
    Join Date
    Mar 2012


    Hi Basil,

    I got the same problem. A blank report was generated after I published the report. Can you publish your report now? Could you please some me some tips? Many thanks.


  3. #3
    Join Date
    Jun 2012


    Hi Alex,

    The problem was with the version of Reporting Developer. The oracle datasources doesnt get exported with version 3.8. When we used the version 3.9 of Reporting Developer, the report was displaying data on Pentaho User Console.
    Also you need to configure the datasources correctly.


  4. #4
    Join Date
    Jul 2012


    I'm having this same issue, except with external MySQL. I'm using the latest version of Designer. This is the error showing in the log:

    13:14:41,779 WARN [CascadingDataFactory] Deprecated behavior: None of the data-factories was able to handle the query 'Membership'. Returning empty tablemodel instead of failing hard.

    Membership of course is the name of the Query I'm using in Report Designer. I've created the DataSource on the Server, called it Membership, using the same SQL statement as I used in Designer.

    Can you help with "correctly define data source" ideas ??

  5. #5
    Join Date
    Mar 2003


    You are using Pentaho Report Designer 3.9 on a server that runs Pentaho Reporting 3.8.3.

    If you use the latest PRD (3.9) then you have to use the latest BI-Server (4.5). Anything short of that will fail with the server not recognizing the queries defined in the report definition file. After all, a server released in November 2011 cannot cope with features added in May 2012.

    Time-travel is still not part of the development budget here at Pentaho, but we work hard to solve that problem.*

    *) We may end up sending ourselves lottery numbers instead of code for the first few centuries or so, but eventually we will be able to release a software package that contains all past and future features and bug-fixes. Promised!
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  6. #6


    First open the pentaho server configuration. Login in to the username and password in pentaho server. Then publish your report go to menu file publishing wizard. In that localhost at type pentaho url then username and password enter. Then view report for pentaho server.

Tags for this Thread

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.