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

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

When you first open a semantic model that has been processed, a dialog box alerts you if Kyvos determines that the semantic model can be optimized. You can view and accept or reject the recommendations or dismiss the dialog box. Over time, you may need to re-optimize a semantic model based on how it's being used.

You can also click the Actions menu (...) near the top right of the semantic model Process tab and click Get Recommendations for any semantic model that has been processed. 

The optimization recommendations are based on query patterns and data profiles, and some recommendations are based on your responses to options on the recommendation pages. Depending on your data, you may see that no recommendations are available. 

You can optimize based on the following categories:

• Input

• Physical view

• Partitioning strategy

• Aggregation strategy

As you go through each page of the dialog box, you can view recommendations and make changes. After reviewing each page, click Accept & Next. You can go back to previous pages at any time by clicking Previous.

You can also get recommendations on an already-processed semantic model to improve the performance of slow-running queries. It uses your query history to optimize the data in the semantic model. Use the option to overwrite the semantic model to apply the new recommendations. When you schedule the process, choose the option to Update Aggregates. You don't need to do a full reprocessing of the semantic model.

Input

This page shows you what information the recommendations are based on. 

You can view the design summary, the date of the data profiles used, and query information. The Analyze historical queries link takes you to a dashboard in a different tab.
The Add additional query patterns link allows you to add additional patterns to group by, summarize on, or filter by.

• Select an aggregation mode: Expert (user-driven) or Smart (system-driven). 

• Set a Materialization level (low, medium, high) or click the i symbol to learn more.

Physical view

This page shows a summary of the recommendations and descriptions for each one. At a glance, you can see what dimensions or attributes are added, moved, modified, or deleted.

These recommendations are based on how the data is being used. If content such as a hierarchy or attribute has not been used, Kyvos recommends deleting it to reduce the process time and size. If you know that this data will be used, you don't need to follow the recommendations. Click Show Reasons to see why each recommendation is made or click Hide Reasons once you have finished reading them.

Click Show all dimensions to see the full semantic model structure, including areas where recommendations are not made.

Partitioning strategy

This page shows a summary and recommends a partitioning strategy based on optimizing semantic model query performance. 

These recommendations are based on how the data is being used. Use the Current and Recommendation radio buttons to toggle between viewing the current partition settings and the recommended strategy.

You can view the options for base partition and subpartition recommendations. The recommendation details explain some of the logic behind the recommendation. There may also be recommendations for other things to do if you don't apply the recommended partitions. 

Click Show Reasons to see why each recommendation is made or click Hide Reasons once you have finished reading them. Click Show Complete View to see the entire view, including where recommendations are not made.

When you use the partition strategy recommendations, the resulting semantic model is initially created with "sliding window will be disabled".

To enable the sliding window while viewing the semantic model, in the Refine tab, click the Partition Strategy tab, and then select the Enable sliding window and keep data for partitions checkbox.

Aggregation Strategy

This page shows a summary of the recommendations and descriptions for each one. At a glance, you can see how many aggregates will be added, modified, moved, or deleted.

Open

Icon key

These recommendations are based on how the data is being used for querying. Kyvos automatically recommends aggregates based on its internal logic, which will improve performance and displays the number of recommendations. 

• Click Show Recommended Aggregates in the Recommendations column to see details of the recommended aggregates in a separate browser tab, to better understand the recommendations.

• Click Show Current Aggregates to see the existing aggregates available in the semantic model in a separate browser tab. This option is displayed only if you have aggregates defined on the semantic model.

• Click Show Reasons to see the reasons for recommendations, or click Hide Reasons once you have finished reading them.

Summary

On the summary page, you will see a summary of recommendations. You can apply the recommendations to the current semantic model by overwriting the current semantic model or selecting the checkbox Create a copy of the semantic model and apply recommendations to the new semantic model. You need to reprocess the semantic model for these changes to take effect. When you specify to create a copy, the copy is created with recommendations appended to the name of the semantic model.

Click Apply to finish. Then do a full data process to apply the recommendations.  

Related topics

• Analyzing queries

• Using aggregates

• Additional Query Patterns

• Migrating Queries