I have a report/analysis in OAC that just won't update to the current data in the database. Things I've tried
- Set the cache in RPD to not expire
- On advanced tab in analysis set to bypass presentation cache for entire report
- Added SET VARIABLE DISABLE_CACHE_HIT=1; to the prefix section in advanced tab
- Checked the selection steps for anomalies
- Checked every single filter to see if it was causing the failure to update
- Clicked on refresh a bazillion times
- Created a new analysis with the same data and same filters (it works fine but really don't want to redo the entire thing)
Why is this happening? How can I fix it?
Snapshot of report that won't update
Snapshot of new analysis notice that this one has 2 rows. The above screenshot is missing the second row.
They both are using same filters and same subject area.