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 11g Pivot Table sometimes not refresh automatically

Received Response
41
Views
8
Comments
3396145
3396145 Rank 2 - Community Beginner
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi all,

When I open an analysis in view mode my problem is the following:

This analysis has a dinamic table. When I try to change some dinamics partition (ex: year) sometimes it does nor refresh by itself and I have to manually refresh the analysis.

Do I need to modify some settings?

Any help will be appreciated.

Thanks in advance,

Adrian.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What do you call a "dynamic table"?

    And what actions and where you do to "change some dynamic partition" ?

    Just trying to figure out what you are asking

  • 3396145
    3396145 Rank 2 - Community Beginner

    Hi Gianni,

    When I create a new analysis, I have these differents kind of views and I use dinamic table:

    2.png

    In view mode, when I change between the diferents options (the year in the image) sometimes it does not refresh automatically and I have to do it manually

    3.png

    Thanks in advance,

    Greetings

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    So the "dynamic table" is a pivot (that's actually one of the most "exotic" translations I saw ).

    And the value you change are columns you placed in the "pivot table prompts" section of the view.

    And when you execute the analysis (so in preview mode or in a page, and not in the "Results" tab when building it) and change values from the prompts the pivot some time doesn't refresh until you click on the "refresh" link underneath it.

    What's your exact version of OBIEE? Is the pivot really big? (lot of columns and rows)

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    You mean to say "Pivot View" report for which display name gets converted to "Tabla Dinámica" in spanish.

    What is the complete version of OBIEE that you are using?

    Do you face issue with all Pivot View(Tabla Dinámica) reports?

    are you facing report refresh issue when placed on dahboard and filtered using dashboard prompts?

    OR

    are you facing report refresh issue when filtered using report prompts?

    Edit: Gianni was faster to post a reply

  • Sunny86
    Sunny86 Rank 6 - Analytics Lead

    Get the below 4 steps done and check.

    1)go to the 4th tab (advanced)

    2)add below statement in prefix

    SET VARIABLE DISABLE_CACHE_HIT=1;

    3)APPLY SQL

    4)SAVE

    pastedImage_0.png

  • 3396145
    3396145 Rank 2 - Community Beginner

    Hi Gianni and Syed,

    Thanks for your replies. Yes It was a literal translation from google translate, sorry for the misunderstanding . I will edit the title.

    My OBIEE version is 11.1.1.9.0, and the bundle Patch 25797429: BI BUNDLE PATCH 11.1.1.9.170418

    The pivot tables have  between 10-20 rows, and 5-10 columns But they came from pyshical tables with 200.000 rows or more and 10-20 columns. We display aggregated values.

    I face this problem with some pivot table not with all. And I face this problem when I open the analysis in view mode (not editing). I don't use any dashboard or report prompts.

    Thanks for helping,

    Adrian.

  • 3396145
    3396145 Rank 2 - Community Beginner

    Thanks 3295595, I will try this solution

  • 3396145
    3396145 Rank 2 - Community Beginner

    Hi,

    I tried the solution proposed by 3295595 but it didn't work.

    I have seen that this problem only occurs in Firefox but not in Chrome.

    Is there some setting in Firefox wich is forcing to don't refresh?

    Thanks in advance,

    Greetings,

    Adrian.