Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user NIDHI BHANDARI

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 job instances feature.

Dataset 

 Action

Action

Supported

Delete dataset

Image Removed

(error)

Modify source connection

Image Removed

(error)

Renaming column

Image Removed

(error)

Modify column data type

Image Removed

(error)

Modify column sub type

Image Removed

(error)

Add new column

Image Removed

(tick)

Delete column

Image Removed

(tick)

Semantic model

...

Name

Add

Reorder

Delete

Measure

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

Attribute

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

Dimension

Image Removed

(tick)

Image Removed

(error)

Image Removed

(tick)

Image Removed

(tick)

Hierarchy

Image Removed

(tick)

Image Removed

(error)

Image Removed

(error)

Image Removed

(error)

Level

Image Removed

(tick)

Image Removed

(error)

Image Removed

(error)

Image Removed

(error)

Member Property

Image Removed

(tick)

Image Removed

(error)

Image Removed

(error)

Image Removed

(error)

Display Field

Image RemovedImage Removed

(tick)

Image Removed

NA

(error)

N.A.

(error)

Custom Rollup

Image RemovedImage Removed

(tick)

Image Removed

NA

(error)

N.A.

(error)

Sort Field

Image RemovedImage Removed

(tick)

Image Removed

NA

(error)

N.A.

(error)

Relationships

 

Supported

Delete relationship (DRD)

Image Removed

(error)

Switch relationship (DRD)

Image Removed

(error)

Modify Join key relation

Image Removed

(error)

Is Fact Table

Image Removed

(tick)

Add new node

Image Removed

(error)

Delete node

Image Removed

(error)

Partition Strategy

 

Add

Delete

Reorder

Base partition

Image Removed

(error)

Image Removed

(error)

Image Removed

(error)

Sub partition

Image Removed

(error)

Image Removed

(error)

Image Removed

(error)

Sliding window

Image Removed

(error)

Image Removed

NA

(error)

N.A.

Sliding window range

Image RemovedNA

(tick)

Image Removed

(tick)

N.A.

Base partition size

Image RemovedNA

(error)

Image Removed

(error)

N.A.

Aggregation Strategy

 

Add

Delete

Modify

Mode (Expert/Smart)

NA

NA

Image Removed

N.A.

N.A.

(error)

Selective dimension materialization

(kyvos.build.dimensions.materialize)

Image Removed

(error)

Image Removed

(error)

Image Removed

(error)

Selective hierarchy materialization

(kyvos.build.precompute.hierarchy.levels)

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

Degree of materialization

(kyvos.build.precompute.degree)

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

Precompute level threshold 

(kyvos.build.precompute.level.threshold)

Image Removed

(tick)

Image Removed

(tick)

Image Removed

(tick)

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