Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Parameter datasource?

  1. #1

    Default Parameter datasource?

    Hi!

    I would like to choose a specific datasource with a parameter in my xaction (same queries for each datasource, thus I need just to change the datasource),

    exemples:

    I want to use the datasource "datasource1" with parameter "datasource"
    http://localhost:8080/pentaho/ViewAc...Report.xaction&datasource=datasource1

    Or i want to use datasource "datasource2" with parameter "datasource"
    http://localhost:8080/pentaho/ViewAc...Report.xaction&datasource=datasource2

    Can i do something like that without to use several xaction?

    Thanks in advance!

  2. #2
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    yes, just use an if element in your xaction to decide which query to run. Make sure both queries return a result set of the same name. Your prompt/secure filter will also need to prompt for datasource.

  3. #3

    Default

    I found, i use a parameter and in "Database connection", i put the parameter (exemple {datasource}) and he uses correctly the database that i need.

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.