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.

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 Guides 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

Topics in this section: