Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: subquery in CDA?

  1. #1

    Default subquery in CDA?

    Hello,
    anyone knows if there is a way to define a subquery in CDA?
    I'm facing with a dataset with many rows to be reported in several charts, after specific aggregations and I want to avoid using postFetch client side, to limit the network load.
    Thanks, Luciano

  2. #2

    Default

    No one knows?

  3. #3
    Join Date
    Sep 2017
    Posts
    18

    Default

    You could try passing parameters to PDI using selectors and whatnot and from there query the database in a transformation.

    I would like to post a "small tutorial" as I just learned this the other day but I've been quite busy.

    Tell me if you need any help and I'll see what I can do

  4. #4

    Default

    I see the logic you refer to.
    I will try your way.
    And of course, I hope I can read your post on this topic.
    Luckily, at the moment, this issue is not urgent for me.
    Thankyou very much.
    Luciano

  5. #5

    Default

    Following your hint, I've been able to get a valuable solution to my issue.
    Hope going deeper on this topic, when you can share your post.
    Thank you very much again.
    Luciano

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.