Oracle Transactional Business Intelligence Idea Lab

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

Creating Interdependent Parameters in BIP Report in SAAS Enviornment

1
Views
1
Comments
AshishERPCloud
AshishERPCloud Rank 5 - Community Champion

Description

It is a common requirement for many customers to have the parameters interdependent

Use Case and Business Need

Say suppose I want to create a report to find the woker headcount, Here we may create a report which would comprise of following setup:

 

Parameter1 : BU ( List of all Valid Business Units)

Parameter2 : Department (List of All Department which should get filtered basis business unit)

I know we can achieve this using Dashboard Prompts but is it possible via BI Report and can we have this feature on a ESS Job

 

I guess having this functionality in SAAS model would be really helpful

 

Thanks

Ashish

Original Idea Number: 1bd804330e

1
1 votes

Submitted · Last Updated

Comments

  • Ashish,
    from what i could understand, you need report prompt on 'Department' that filters based on the already selected value based on 'Business Unit' prompt
    This can be done using the 'Prompts' tab in the analyses itself
    let me know if you meant anything else?
    for now, i would mark it as already existing
    Thanks
    Raghu