Custom Query does not work in filter

Dim Pap shared this question 2 years ago
Answered

Hi,


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.


Thanks,

Dim

Files: yel.png

Comments (2)

photo
1

Hi,


the problem is solved :)

However, I cannot delete the topic.


Thanks,

Dim

photo
1

Hi Dim,


Thanks for notifying us of this. I will now mark this case as "Answered"


Regards,

Mark