Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Automating a manual report that has data pulled from here there and everywhere!

  1. #1
    Join Date
    Apr 2007
    Posts
    2,009

    Default Automating a manual report that has data pulled from here there and everywhere!

    Hi,

    I am looking at automating a current manual report, and at the moment i can only see messy ways of doing it!

    Basically the data is currently sourced from several other oracle reports and I need to combine values from all of those into 1.

    The problem is that i need to replicate the current manual report syntax. So i'll be picking values from query 1,2,3 etc.

    How can I do that? Or how should I do that Is it best to try to create some uber query that does it all in one go, and then pick the values accordingly, or is there some cleverer way i can do it?

    I am vaguely wondering whether or not i should do it in kettle combined with an excel template. Or at least arrange the data in a suitable order within kettle for Jfree?

    Thanks!
    Dan
    Last edited by codek; 06-08-2009 at 04:46 AM.

  2. #2

    Default

    Quote Originally Posted by codek View Post
    I am vaguely wondering whether or not i should do it in kettle combined with an excel template. Or at least arrange the data in a suitable order within kettle for Jfree?
    Don't forget you could always trigger the ktr/kjb from within an xaction and pass the data back once the transformation has finished, I do that for some stuff. So you get the power of kettle with the uses being none the wiser(or caring).
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    Join Date
    Apr 2007
    Posts
    2,009

    Default

    yup, i do that already in some cases.

  4. #4
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    If your requirements are complex, I tend to tell people to go to a specialist.

    So if your query/data-processing is a hell of a beast, go to a data-specialist to get the result for reporting. Go Kettle. Although you may be able to create that monster-query in SQL only, always consider changing requirements in a year or two. Your nightmare-factor will be much lower with Kettle than with the plain query alone.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  5. #5
    Join Date
    Apr 2007
    Posts
    2,009

    Default

    Ok, thanks. I'll start down that route now.

    Update: It works a treat, a very simple 7 table inputs all going into a cartesian product join rows and then picked up by the report through the xaction.
    ( Works in my case because each query is only ever returning 1 row ) Now just to parameterise the thing and away it can go!
    Last edited by codek; 06-09-2009 at 04:47 AM.

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.