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.
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 220.127.116.11.150120 version.
Thanks in advance
Would not expect this behavior from cache to be honest. Could you share some SQL statements?