Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
BI Report ESS Job Does not support parameter with Dependent LOV
Organization Name
Hutchison International Limited
Description
On BI Report parameter list of values available to user can be setup base on another report parameter user selected. However, when we define a ESS Job to run the BI Report, parameter on ESS Job does not support List of value from custom SQL that depend on value of another ESS Job parameter.
Use Case and Business Need
It is common that the parameter list of value is filtered base on value selected from another parameter. This is to ensure correct List of value is filtered and return for user selection. Without the same feature available on ESS Job, this type of BI Report cannot trigger through ESS Job.
More details
We need to use ESS Job to setup a sequence of process to meet our business. This limit the type of BI Report we can use to setup ESS job set to meet business needs.
Original Idea Number: af2cd23b88