We have requirement for a specific report not hitting cache and data in the report should come directly from database tables.
Use the following syntax for the query
SET VARIABLE DISABLE_CACHE_HIT=1;SELECT “Paint”.”Year” FROM Paint order by “Paint”.”Year” ASC
SET VARIABLE syntax can be directly coded into Dashboard prompt as SQL.
For a specific report it can be included in the Advanced section under Prefix.
For a specific report it can be included in the Advanced section under Prefix.
Posts
