OBIEE Prompt cache issue

3232721

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

Gianni Ceresa

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.

3232721

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

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

did u check the cache?

3232721

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

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

Is this issue resolved?

3326235

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.