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

Date Prompt hitting Cache in Obiee 11g

Received Response
1
Views
3
Comments
986359
986359 Rank 4 - Community Specialist
edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

Hi All,

There are two date fields Eff_Frm and Eff_to  used in prompts with  Eff_from >=   and  Eff_To as <=

1. when Eff_to date is passed some value and run the dashboard it results the data.  (eg: Eff_To <= 9/13/2016 )

2. After which clearing this date field value and adding a value to Eff_Frm date and than click on apply,  the report picks previous value of Eff_to date even though i had deleted the value.

Looks like Eff_to date is hitting cache. (eg: Eff_Frm >= 7/7/2016  and Eff_To <= Null ) -> Apply

On clicking Apply the report displays filters as Eff_Frm >= 7/7/2016 and Eff_To <= 9/13/2016 . (Note i had deleted the value for Eff_To date)

How to remove this cache issue for dashboard prompts?

Please help!

Thanks,

LonaD

Answers

  • 986359
    986359 Rank 4 - Community Specialist

    I now could debug on above explained behavior as why the dates hit cache, because every time when the report results data in table or pivot format.

    The report on mouse hover the column has a ascending/descending option.

    If for any Eff_to date value i do an ascending/ descending in the report, and then clear the prompt value and select Eff_Frm date value. It somehow used to take Eff_to date value in the report and used to return data with and condition. Like explained above. (even in the prompt clearing Eff_to value)

    Can anyone suggest solution for this scenario ? Is there a way to avoid this type of caching issue.

    Note: I have even tested by disable cache properties for the respective table and also by pass presentation cache.

    Please help!!

    Thanks,

    LonaD

  • 986359
    986359 Rank 4 - Community Specialist

    Hi All,

    Can any one please help if there is a workaround for this cache issue during sorting or is it OBI BUG.

    I am working on OBI 11.1.1.7.150120  version.

    Thanks in advance

    LonaD

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Would not expect this behavior from cache to be honest. Could you share some SQL statements?