Custom Query does not work in filter

Dim Pap shared this question 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:

The same question

Replies (2)

Dim Pap ●

Hi,

the problem is solved :)

However, I cannot delete the topic.

Thanks,

Dim

Reply URL

Mark McGuire ●

Hi Dim,

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

Regards,

Mark

Reply URL