How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as Source
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.
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: