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!

Issue with Dashboard Prompts in OBIEE 11g (Cache Issue)

Siva Prasad G NApr 5 2014 — edited Apr 17 2014

Hi All,

I am using a dashboard prompt in my dashboards.

For Example Country is my dashboard prompt.

When I change the values in my country table(In Database). It is reflecting in my report but the new updated data is not visible in dashboard prompts.

The dashboard prompt still showing the same old values.

I tried to put "set variable disable_cache_hit=1;" in dashboard prompt's SQl Statement box.

It worked fine for 1st time then again the same issue came back.

How to remove this dashboard prompts cache??

Any help/suggestions is much appreciated.

Thanks and Regards,

Siva Prasad.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2014

Added on Apr 5 2014

#11g, #analytics, #applications, #bi, #business-intelligence-applications, #data, #obiee, #oracle

4 comments

7,742 views