Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to create prompts with values changing depending on another prompt values?
I have a requirement to have prompts that will change depending on what the user selects! For example I will have columb prompt Class (value: A B C) and prompt Increase Rate that willl be intered depending on Class. The user need to be able to assign a rate for each class Class A 1% Class B2% Class C 5%. Is there a way to do this in obiee knowing that the interest rates for each class will be applied at the same time
Answers
-
Using a presentation variables and logical sql
0 -
While presentation variables might be a doable way....it's definitely not the first one you should try. Simply because it involves customizations rather than using out-of-the-box functionalities!
If you have the information for classes and rates in a table which you model into your BM then you can use the standard functionality of dependent prompts:
https://blogs.oracle.com/proactivesupportepm/obiee-11g-creating-cascading-constrained-prompts
tl;dr - always look to the standard first before going off and writing code (even if "just" LSQL)
0 -
My issue is that the rate is not in a table the user will enter the rates . It<s a small what if scenario.
0 -
You could use write back functionality to put it in a table.
Or if table / database is out of the question then just create three prompts on a dashboard with freetext input, each of which populate a presentation variable.
Your answers report then references them in a formula as @{C}{1} x WhateverYourMeasureIsHere etc...
Failing all that persuade your client they need PBCS for real modelling ;-)
0 -
By the way, I have used the exact method I describe previously to facilitate % and absolute uplift of values, selected by other prompts so you could model sub-sets of the entire budget in this fashion.
It works, but as advertised it is what it is, very limited.
0 -
Thank you, I will try the write back option it seems to be the most promissing. Thanks again for the idea.
0 -
With write back you can make your A, B, C values differ at row level, so facilitating modelling that differs at whatever level of detail you deem appropriate, however, kindly note that write back is not the most flexible tool however, if you really want flexible insert functionality then you might want to also consider Apex.
0 -
Was about to say "if you REALLY need this then go for something proper like APEX and write it into a table which then become your source"
0 -
Indeed!
Was at first surprised by write back in OBIEE, then when I knew more excited by the concept, finally when I understood the execution deeply disappointed...
So it goes...
0 -
One of those things which got added "because they had to".
Hasnt changed one iota since version 7
0
