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 |
---|---|
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 |
---|---|---|---|---|
Measure |
|
|
|
|
Attribute |
|
|
|
|
Dimension |
|
|
|
|
Hierarchy |
|
|
|
|
Level |
|
|
|
|
Member Property |
|
|
|
|
Display Field |
|
| N.A. |
|
Custom Rollup |
|
| N.A. |
|
Sort Field |
|
| N.A. |
|
Relationships
 | Supported |
---|---|
Delete relationship (DRD) |
|
Switch relationship (DRD) |
|
Modify Join key relation |
|
Is Fact Table |
|
Add new node |
|
Delete node |
|
Partition Strategy
 | 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 |
---|---|---|---|
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 |
---|---|---|---|
Measure |
NOTE:
| All measures for a fact table |
|
Attribute |
| Snowflake to Star | NA |
Dimension | Not supported |
|
|
Hierarchy | Not supported | Not supported |
|
Level | Not supported | Not supported |
|
Copyright Kyvos, Inc. All rights reserved.