Setting up and using cache rules

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

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

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

1. From the Toolbox, click Semantic Models.

2. Select a semantic model or create a new one.

3. Click the Refine tab.

4. Click the Auto Cache Strategy tab.

5. For Cache strategy on every semantic model build and Cache strategy on every cache build job, choose cache strategy when it's rebuilt from:

   1. Purge and Populate Cache

   2. Purge Cache

6. You can now set cache rules.

7. Select the types of queries to cache from:

   1. Metadata Queries: Select this when 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, 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.

   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.

You can also specify a cache build schedule for specific semantic models.

To apply a cache rule to specific semantic models, perform the following steps.

1. Click a semantic model from the list and click the Process tab.

2. Click the Actions menu (...)  menu and choose Add Other Jobs.

3. Select Cache Build and specify when it should run.

4. Click Schedule to schedule or start the build.

Related topics

• Improving query performance using caches

• Job history

• Sliding window