How to create prompts with values changing depending on another prompt values?

Vanessa kientega

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

cesar.advincula.o

Using a presentation variables and logical sql

Christian Berg-0racle

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)

Vanessa kientega

My issue is that the rate is not in a table the user will enter the rates . It<s a small what if scenario.

Robert Angel

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 ;-)

Robert Angel

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.

Vanessa kientega

Thank you, I will try the write back option it seems to be the most promissing. Thanks again for the idea.

Robert Angel

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.

Christian Berg-0racle

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"

Robert Angel

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...

Christian Berg-0racle

One of those things which got added "because they had to".

Hasnt changed one iota since version 7