Custom Query does not work in filter
I have a big view with cross joins etc that creates million of records. I want to cache some values in the report and I do so through Custom Queries selecting distinct values from the tables I want (to avoid querying the whole db).
Most of them work fine but for some, I get "No values cached".
When I test the query I see the desired results (see the attached picture) but when I click 'refresh now' none of them are returned.
Could you help me? It is critical for a report I am building :)
I use yellowfin 7.3.