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

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

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

Received Response
21
Views
7
Comments
Youssef_B_82
Youssef_B_82 Rank 5 - Community Champion
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    Youssef_B_82 Rank 5 - Community Champion

    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
    Gianni Ceresa Mod

    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]
    [Deleted User] Rank 2 - Community Beginner

    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
    Youssef_B_82 Rank 5 - Community Champion

    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
    Youssef_B_82 Rank 5 - Community Champion

    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
    Gianni Ceresa Mod

    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.