Cached Filter Displaying All Options After Automated Refresh
I have a bit of a situation that I am unsure about: I have a Source Access Filter setup linking a user to employers which they should see. All works great there, the filter is applied to the employer_id at the view, then applied to the report subqueries. There where clause applies appropriately (where employer_id IN 1, 2, 3, 5) in the SQL, but the Cached Filter that shows the Employer Names is acting very wonky.
It seems that every time the automated filter refresh goes off, the filter values are set back to an unfiltered, i.e. Source Access Filter is not applied, state. I have it set to automatically refresh every 1 minute for testing. I can literally kick off a manual refresh on the particular filter and 6 values show appropriately, wait one minute until the automated refresh takes place and then 260 values are cached.
I apologize in advance but I do not yet have access to the log server or the yellowfin database. With that said, do you have any ideas for me?
Some facts about the content:
1. The filter resides on a subquery and has a second subquery which is Link to Filter type.
2. The master query is an hours dimension view to give access to all dates regardless of data
I have also attached some photos for you to see the setup. I would appreciate any help you might have. This client is using the 11252015 version of 7.1.
Whit (yes, same Whit :) )