Semantic model modifications allowed without reprocess

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

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

Once you have processed a semantic model, you may want to modify the entities, partition strategy, or aggregation strategy in the design. For example, you may want to add new columns (dimension, measure, etc.) as per the business requirements, or you may want to remove entities as suggested by the Kyvos recommendation engine to improve the semantic model and query performance or/and reduce associated costs, and other such scenarios. To minimize the impact and cost of reprocessing semantic models on every modification, Kyvos allows you to update the following without requiring a full process.

Note

It is recommended to use the Validate design and its impact on subsequent processes link on the semantic model designer and validate design after changing the semantic model design and saving the design.

You can revert changes using the manage semantic model job instances feature.

Dataset

Action	Supported

Action	Supported
Delete dataset
Modify source connection
Renaming column
Modify column data type
Modify column sub type
Add new column
Delete column

Semantic model

	Name	Add	Reorder	Delete

	Name	Add	Reorder	Delete
Measure
Attribute
Dimension
Hierarchy
Level
Member Property
Display Field			N.A.
Custom Rollup			N.A.
Sort Field			N.A.

Relationships

	Supported

	Supported
Delete relationship (DRD)
Switch relationship (DRD)
Modify Join key relation
Is Fact Table
Add new node
Delete node

Partition Strategy

	Add	Delete	Reorder

	Add	Delete	Reorder
Base partition
Sub partition
Sliding window			N.A.
Sliding window range			N.A.
Base partition size			N.A.

Aggregation Strategy

	Add	Delete	Modify

	Add	Delete
Mode (Expert/Smart)	N.A.	N.A.
Selective dimension materialization (kyvos.build.dimensions.materialize)
Selective hierarchy materialization (kyvos.build.precompute.hierarchy.levels)
Degree of materialization (kyvos.build.precompute.degree)
Precompute level threshold (kyvos.build.precompute.level.threshold)

Exceptions

The following table provides information on the specific scenarios, designs, and modifications that will require a full semantic model reprocess.

	Addition	Deletion	Other Settings

	Addition	Deletion	Other Settings
Measure	Distinct Count Semi-Additive Measure addition from a source dataset that was not already used in the semantic model to create a measure NOTE: From Kyvos 2023.2 onwards, the reprocessing of the semantic model is necessary only when you choose the Accurate distinct count option. The reprocessing of the semantic model is not necessary when opting for the Approximate distinct count. This requirement applies exclusively when the semantic model's compatibility version is 3.	All measures for a fact table	Accuracy Type Mutually exclusive values checkbox (Boundary Distinct Count) Count On Function
Attribute	Star to snowflake Dimension which does not have any existing attribute Attribute having the same name as a deleted attribute in the same dimension	Snowflake to Star	NA
Dimension	Not supported	Used in semantic model partition or sub-partition Root dimension for a fact table Root dimension whose lower-order dimensions are not materialized Delete a dimension that is the only related dimension for a fact table Dimension having Custom Rollup	Dimension type - Regular <-> Time Dimension type - Location <-> Time) SCD type 1
Hierarchy	Not supported	Not supported	Has Alternate Paths Has Parent Child Relation Hierarchy Type (Predef-Custom) Predef Hierarchy Type Custom Calendar
Level	Not supported	Not supported	Date Data Type Parent-Child Additional Settings

HTTP Status 429 – Too Many Requests