Content Comparison

...

You can set up cache rules to improve the performance of queries.

From Kyvos 2025.2 onwards, auto cache support for SQL generated through Kyvos Dialogues is available.

To set up cache rules for a single semantic model, perform the following steps.

...

7. Select the types of queries to cache from:

   1. Metadata Queries: Select thiswhen raw data querying is enabled, and the semantic model or its dimensions are not materialized. By default, metadata will be populated for all non-materialized columns. To populate metadata for specific columns, click the Choose columns link and select the columns.

   2. Historical Queries: Select to generate and cache linked filter queries, and choose one of the options from Auto, Yes, or No.
      By default, Auto is selected.  

8.  To set cache population rules for historical queries, do the following:

   1. Select the field, criteria, and value:

      1. For Query Type: Select MDX, SQL, Kyvos Worksheet, Kyvos Chat Session, or Select All, and specify whether they are in or not in the list. By default, the Worksheet comes under MDX.

      2. For Query Status: Select the status from Success, Failure, or Canceled, and specify whether they are in or not in the list.

      3. For Query Completion time: Specify whether it is in the last hour, today, or set the value, such as the number of days/months/weeks/hours/minutes.

      4. For Query Elapsed time: Specify whether the value is greater than, less than, in between, or equal to the value you select in hours, minutes, or seconds.

      5. For User: Specify whether the account you seek starts with, is, contains, or ends with the value you specify.

         Image Added

   2. Use the parenthesis with And or Or to develop more complex criteria.

   3. Click the Plus icon to add more rules or the Minus icon to remove a rule. 

9. Click Save.

...