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

A strange scenarion in BI Answer

Received Response
13
Views
3
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics Lead
edited Aug 13, 2024 5:16PM in Oracle Analytics Cloud and Server

Hello Experts,

I am facing one very strange situation and I am not able to explain why:

in Snapshot month at analysis I see only 3 values:

pastedImage_0.png

However there are 5 values in this table, please not that I have not applied any filter:

pastedImage_1.png

If I select one more column then I see all 5 values at analysis:

pastedImage_2.png

I am surprised and clue less why column snapshot shows only 3 values when selected alone.

Answers

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    I got the answer and sharing with hope that it may be useful for others with similar issue:

    I need to click on refresh as below circled:

    pastedImage_0.png

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    On testing you might want to look to the advanced tab and clear the option that uses cache, it can save a lot of this kind of pain.

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Thanks Robert,

    It is already cleared as per below screenshot- Bypass cache is disabled.

    pastedImage_0.png