Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 12c prompt default value issue

Chandra M. G.Sep 19 2017 — edited Sep 22 2017

I am using OBIEE 12C, facing below challange would be great if somebody able to help me.

Having 3 prompt on my dashboard having values depending on each other like P1, P2, P3. Choose value from P1 then using SQL query to fetch value under P2 then again using SQL query fetching value for P3 prompt which taking input from previous prompt.

Now issue which i am facing is, like i choose P2 then apply then choose value from P3 then apply it shows data but now i am changing value P2 again and apply then in this case P3 has default value which i choose earlier so shows wrong data. Then in this case again i need to choose P3 & then apply.

Is this possible when i am changing value for Prompt P2 & apply then P3 old value should be wipe out so that it does not show wrong picture of data.

Thanks

Chandra M.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2017

Added on Sep 19 2017

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

17 comments

4,214 views