Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Using Different Queries from same Transformation

  1. #1

    Default Using Different Queries from same Transformation

    We created a transformation in Spoon that goes through multiple steps. At a number of steps, we want to make some charts from the data at that specific step. We tried making 1 report, but found that each report could only use 1 query, so we could not take data from different steps. To get around this, we just made multiple sub reports that each use a specific query from the transformation. However, we are now running into the problem that each sub report runs the transformation itself. So now instead of running the transformation once and getting 10 reports, we run the transformation 10 times in total. Is there a way to run the transformation once, but use different queries for each of the reports, or charts?

  2. #2
    Join Date
    Jan 2012



    I am facing the same situation. Did you solve it? or at least did you find a workaround?

    Best regards

  3. #3
    Join Date
    Mar 2003


    This is built in into how Kettle works. Kettle always starts all steps of a transformation in parallel. If the steps are independent, you can simply move them into their own transformations.

    Otherwise: Implement caching. Pass the report's date ("" field) down to Kettle, and when the transformation runs the first time for a given date, let it generate the data as CSV files in a cache/tmp-directory. Subsequent calls can then simply read the files as needed. The date passed in will be the same for the whole lifetime of the report-process.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

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.