Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 4

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: Image Removed (tick) Kyvos Enterprise   Image RemovedKyvos Cloud (Managed Services (tick) Kyvos Cloud (SaaS on AWS)   Image Removed (tick) Kyvos Azure AWS MarketplaceImage Removed

(tick) Kyvos AWS Marketplace  Image RemovedKyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) Kyvos Single Node Installation (Kyvos SNI)  Image RemovedKyvos Free (Limited offering for AWS)

...

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 rebuilding semantic models on every modification, Kyvos allows you to update the following without requiring a full process.

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

It is recommended to use the Validate design and its impact on subsequent builds builds 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 build instances feature.

Dataset 

 Action

Supported

Delete dataset

Image Removed
Image Added

Modify source connection

Image Removed
Image Added

Renaming column

Image Removed
Image Added

Modify column data type

Image Removed
Image Added

Modify column sub type

Image Removed
Image Added

Add new column

Image Removed
Image Added

Delete column

Image Removed
Image Added

Semantic model

 

Name

Add

Reorder

Delete

Measure

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Attribute

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Dimension

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Hierarchy

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Level

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Member Property

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Display Field

Image Removed
Image Added
Image Removed
Image Added

NA

Image Removed
Image Added

Custom Rollup

Image Removed
Image Added
Image Removed
Image Added

NA

Image Removed
Image Added

Sort Field

Image Removed
Image Added
Image Removed
Image Added

NA

Image Removed
Image Added

Relationships

 

Supported

Delete relationship (DRD)

Image Removed
Image Added

Switch relationship (DRD)

Image Removed
Image Added

Modify Join key relation

Image Removed
Image Added

Is Fact Table

Image Removed
Image Added

Add new node

Image Removed
Image Added

Delete node

Image Removed
Image Added

Partition Strategy

 

Add

Delete

Reorder

Base partition

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Sub partition

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Sliding window

Image Removed
Image Added
Image Removed
Image Added

NA

Sliding window range

Image Removed
Image Added
Image Removed
Image Added

NA

Base partition size

Image Removed
Image Added
Image Removed
Image Added

NA

Aggregation Strategy

 

Add

Delete

Modify

Mode (Expert/Smart)

NA

NA

Image Removed
Image Added

Selective dimension materialization

(kyvos.build.dimensions.materialize)

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Selective hierarchy materialization

(kyvos.build.precompute.hierarchy.levels)

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Degree of materialization

(kyvos.build.precompute.degree)

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

Precompute level threshold 

(kyvos.build.precompute.level.threshold)

Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added

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

  • 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