Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Report ESS Job Does not support parameter with Dependent LOV

Submitted
452
Views
14
Comments
User_MTBY7
User_MTBY7 Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence Idea Lab

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

34
Up
34 votes

Submitted · Last Updated

«1

Comments

  • Hany Ebrahim
    Hany Ebrahim Rank 3 - Community Apprentice

    you talk about DFF or what ?

  • Adeeba Siddiqui
    Adeeba Siddiqui Rank 1 - Community Starter

    This would be useful for CK Hutchinson group of companies

  • AnneHelenHayden
    AnneHelenHayden Rank 1 - Community Starter

    Users need to generate 1 report for 1 company code, then use Excel to manual manipulate data for multiple companies separately. Expected Change : Allow users to select multiple value of parameter.

    This would be a useful addition for all the CK Hutchison Group companies.

  • Sahil Makhiza
    Sahil Makhiza Rank 3 - Community Apprentice

    Would definitely help overcome the limitation of ESS job and help user with ease of access.

  • User_38PWS
    User_38PWS Rank 1 - Community Starter

    This is also relevant for our business.

  • KDR
    KDR Rank 3 - Community Apprentice

    Upvoted - This is needed functionality to trigger BIP Reporting from the ESS Job side.

  • Anchal Srivastava
    Anchal Srivastava Rank 1 - Community Starter

    UpVoted- Its a much needed functionality

  • Raj Jain-Oracle
    Raj Jain-Oracle Rank 1 - Community Starter

    UpVoted. needed.

  • Saurabh Kumar
    Saurabh Kumar Rank 1 - Community Starter

    Its much needed functionality

  • Sabrina Bernardi
    Sabrina Bernardi Rank 1 - Community Starter

    This is a highly desired functionality. Please include the ability to add filters on a custom ESS jobs in future releases.