Spotfire Ideas Portal
For dynamic queries the information link / SQL query contain " and <condition>" at the end of query to add the dynamic values (based on on-demand setting). When multiple users access the same data the query gets executed multiple times. Caching these queries will help in improving dashboard performance and also memory usage on the server.