Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Single Node Installation (Kyvos SNI) Kyvos Free ( Limited offering for AWS)
Several aspects can impact the performance of your Kyvos semantic models. Some problems could be related to raw data, some due to the poor design of the semantic model and related entities, and others may arise due to inefficient queries. This guide provides information about some of the best practices, which you should consider during the design and development of your Kyvos semantic models. The guide also offers tips to fine-tune your existing semantic model designs in case of performance issues.
Note
In addition to the best practices explained in this guide, refer to the Kyvos Properties Guide to know more about the advanced properties that you can use for designing semantic models to optimize query performance and reduce semantic model process time.
Before you begin
As a semantic model designer, you should be familiar with processes and understand the Kyvos functionality. This document is an add-on to the Kyvos User Guide. Before starting with the best practices, we recommend you go through the Kyvos User Guide to understand how the tool works.
You must have a thorough understanding of your use case before starting the design process. To keep your design optimized for semantic model building and querying performance, analyze the following characteristics of your use case, and design the semantic models accordingly.
The cardinality of dimensions and attributes
The number of dimensions, attributes, and measures
The number of distinct count measures
Who should read this guide
The target audiences for the guide are the people working in the systems operation groups, semantic model designers, or Kyvos administrators responsible for designing and implementing semantic models in Kyvos.
After reading these guidelines, you will know the following.
Best practices and general guidelines for designing semantic models in a Kyvos environment
Best practices and general guidelines for fine-tuning and optimizing semantic models
Advanced properties that you can use for designing semantic models to optimize query performance