ODI Parameter
Target Report
Adding ODI Parameter
1. Add ODI parameter
Go to the Data window
Right-click USER-DEFINED PARAMETER
Select Add Parameter Field
Add an ODI parameter "orderID" to the member pane.
2. Use parameter in Query
Add WHERE clause with ODI parameter
You can run the query by providing a value for the parameter orderID (for example, 63222).
Using Parameter in Report
1. Put the parameter value
Datainfo > DataTree > order > OZParam > Select order ID
Properties > Data > set Field Value to "63222".
Preview
2. Set the ParameterToolbar
Components > right click ParameterToolbar > Refresh Toolbar Wizard
Move order.orderID to the Selected parameter from the Selectable Parameter.
Set options as below.
Preview the report. You can try a new value for order ID. (ex: "69550")
Last updated
Was this helpful?