Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Prompt cache issue

Received Response
42
Views
8
Comments
3232721
3232721 Rank 1 - Community Starter
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

Hi All,

I am using two column prompts by using single column 'Column1' at two different pages within the same dashboard with different default value.

but after navigation it preserves the older default value.

please help.

Thanks

oracle.jpg

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Did you set the scope of your prompts?

    Because what you see is the default behaviour for a prompt with a scope wider than just the page.

    Capture.PNG

  • 3232721
    3232721 Rank 1 - Community Starter

    Hi Gianni,

    Thanks for replying.

    Yeah I have set the scope of prompts to 'Page' only.

    Is it fetching the prompt default value from cache?

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    From cache it will load the values of the prompt (all the values) if something is in cache ...

    Do you maybe set a presentation variable or something?

  • a7f04803-224e-4bc5-9a96-6ef7dbeb42cf
    a7f04803-224e-4bc5-9a96-6ef7dbeb42cf Rank 1 - Community Starter

    did u check the cache?

  • 3232721
    3232721 Rank 1 - Community Starter

    Hi Gianni,

    I used presentation variable for the default values, and it worked.

    But the problem came when I selected desired value in the prompt, this time the prompt preserved the selected value... any suggestion?

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    Same variable for both prompts?

    Which version of OBIEE?

    There are ways to make it works, I just prefer to avoid suggesting the most random possible solutions

  • sami123
    sami123 Rank 1 - Community Starter

    Is this issue resolved?

  • 3326235
    3326235 Rank 1 - Community Starter

    What happens when you hit "Refresh" option in dashboard dropdown menu? Do the values become expected?

    If the answer is yes, try the following:

    1. Set page2 as hidden to exclude navigation through tabs.
    2. Generate URL link to Page2 using dashboard text block and it's 'HTML markup' feature. Something like <a href = "http://localhost:9704 .. .. . .. . . .">  Go to Page2 </a>

    3.When you type that URL, replace "&Action=Navigate" with "&Action=RefreshAll"

    4. Place link somewhere on Page1 and try it

    This is the only magic that worked for me when I was integrating my dashboard into frame. Prompt was returning cached values when cache was disabled for physical tables, all the analyses, it was disabled on session variables disable_cache_hit/seed and even in Enterprise Management.