You can direct the Browse servlet to run a job stored in EPM Workspace by simply invoking a URL and passing the input parameters as part of the SmartCut run.
Passing parameters in the SmartCut works for Oracle's Hyperion® SQR® Production Reporting jobs and generic jobs, but not for Interactive Reporting jobs. For Interactive Reporting jobs, see Limit and LimitValue. |
To run the report or job, use the run SmartCut, which has this syntax:
http://hostname:portNumber/workspace/browse/run/folderPath/JobName[?dbuser=dbUser&dbpass=dbPassword][&Param_1=param_1&Param_2=param_2][&AskParam_1=askparam1]...
Optionally, you can include these variables in the SmartCut run:
These variables are used to establish the database connection for running a report. They are optional in the SmartCut because they can alternatively be configured when importing a job.
Param_1, Param_2, ... (or ASKparam_1, ... for ASK parameters)
Note the initial capital letters.
These parameters are used to execute the report or job. If a report does not require parameters, the SmartCut need not contain parameters. If the report or job requires parameters, and some or all required parameters are omitted in the SmartCut or POST operation, the parameter form displays.
This example is a SmartCut that specifies a report to be run but includes no parameters. Because no parameters are specified, the input parameter form is retrieved and presented for the user to provide the necessary input parameters prior to running the job.
http://apollo/workspace/browse/run/SampleContent/Sales/Sales%20Charts
This example shows a URL that specifies a report to be run. Input parameters are specified as part of the SmartCut run. This example directly invokes the job and return the report output.
http://apollo/workspace/browse/run/SampleContent/Production/Inventory_Information/Supplier_Exception_Re-port?Param_1=ALL
This example shows a SmartCut that fills in all required parameters. Using this URL results in Explore running the report using the parameters entered. Explore then displays the report output.
http://apollo/workspace/browse/run/SampleContent/Sales/Sales%20Charts?user=sanderson&pass=sa357sf607&server=mercury&Param_1=SouthEastern&Param_2=4&Param_3=LINE&Param_4=YES