You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as Source

Summary:

I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source.

Content (required):

Below is my User Defined LOV Source I created for a custom ESS job that calls a BIP Report/Data Model. This works fine on it's own and fetches the values I would expect to see, however I would like to make another parameter's displayed values based on what the user selects in this parameter.

Org_ID Parameter that would control what values are displayed in the 2nd (P_HeaderID) parameter below:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!