nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

List of value (Filter LOV) is defferent for a user

Youssef_B_82

Hi,

I am using

Oracle Business Intelligence 12.2.1.1.0

One user is unable to see the same list of value as other users with same role.

What can cause the lov not to refresh for a particular user (I tried on different computers and browsers.)

Thanks

Youssef

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Look at the queries generated to populate the lists and you get your answer.

There are multiple possible reasons, so look directly at what does the job and you get the answer.

Youssef_B_82

The queries are very basic.

I tired "Refresh" data, I tried "Clear All" from the filters view, I tried re-creating the user.

I resolved the problem as follow:

Administration >Maintenance and Troubleshooting > Issue SQL > enter in the box Call SAPurgeAllCache()

@Gianni Ceresa I noticed this occurs more often now that we upgraded from 11g to 12c. Do you have any idea why the purge cache is required here?

Thanks

Gianni Ceresa

So you are saying it's a per-user cache issue?

You have another thread where cache was already a problem (with agents maybe, can't remember).

Sounds like somebody did a really dirty job on your system. They turned on cache everywhere randomly to desperately try to hide poor performance (which is generally the result of poor modelling and implementation of the tool).

Cache can be one of your worse nightmares if it isn't enabled only after defining a proper cache management strategy.

I believe @Christian Berg already suggested you do a review of that environment to find out what has been enabled, where and why.

[Deleted User]

Beaten by Gianni but seriously you should review your system to comprehend WHAT is going on, WHY it is behaving like it does and HOW things are implemented.

Twisting unknown knobs in the dark is a recipe for disaster

Youssef_B_82

Thank you for the advice Christian I will gladly refer you, but I don't take this kind of decision.

Since this issue does not seem to occur on all environments, it would make sense to troubleshoot and research first.

Youssef_B_82

Yes I initially opened another thread, scheduled analysis were returning cached data. This thread here was about the filters. I don't know why this is happening, you must be right about the configuration, do you have any advice on how to define a proper cache management strategy?

What are the main key elements to pay attention to ?

Thanks

Gianni Ceresa

There is a lot that cache management strategy must pay attention to.

The first thing is to identify why do you want to turn cache on: what is the reason behind using cache? Is cache the real solution or you hope it will just hide the real problem?

Before to turn cache on you must ask yourself how long must the cache be valid, what/when/why must refresh it.

You never turn cache on without having in place a process refreshing it when it is needed.

And you never turn on cache on everything! It's a object by object approach, you generally turn on cache on single tables or maximum at a business model level to have a clearly defined scope the cache is going to impact and the user experience will be consistent when in that scope.