Versions Compared

Old Version 1

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user DocReviewer

Saved on

Key

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

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

...

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 reprocessing 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 processes link on the semantic model designer and validate design after changing the semantic model design and saving the design.

...

 

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