Categories
- All Categories
- 86 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 48 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Creating Interdependent Parameters in BIP Report in SAAS Enviornment
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
Comments
-
Hi Ashish,
Yes, The business unit, LDG, Division and Deartment are the parametrers which are mostly used across business. It should be available in the BI Reports.
Regards,
Varun Kota
0 -
Hi Varun,
Thanks for the reply.
A lil bit confused when you say 'It should be available in BI Reports"
Does it means they already exist or a desired feature.
0 -
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
Raghu0 -
Hi Raghu,
Yup am aware this is possible in OTBI Analysis but the query is more from a BI Data Model perspective.
Is this feature available in BI too ?
If yes, please provide some sample doc/links . if not wondering whether there are any possibility of having this in upcoming releases?
Kind Regards
Ashish
0 -
Ashish,
did you mean, a BIP report?
if yes, then it is not available by default
you need to try if you can filter the department list of values query based on the BU selected
yes, this can be an enhancement in BIP
Thanks
Raghu0 -
Yes, I am referring to BIP Report.
I know in EBS we could refer to first parameter using $FLEX$ feature and apply filter on LOV for second parameter, not sure if similar functionality can be achieved (in SaaS)
Wondering if I would need an SR to get this as an enhancement( the issue being I am not working with any client right now so probably would not be able to lodge an SR )
Kind Regards
Ashish
0 -
Interesting idea.
0
