Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

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

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

Kyvos does not allow you to run incremental processes on semantic models where changes made are in the SCD Type 1 dimensions prior to the Kyvos 2021.1 release. You need to first run a full process job, and thereafter, you can use incremental processes.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

You will see informational messages when using this feature, along with third-party tools for data analysis.

  • Tableau shows the following message: “The worksheet contains errors. The following will be removed: There is no field named [Dimension_Name].[Hierarchy_Name].[Level_Name]”, and then removes that level from the worksheet.

  • Excel shows the message: “The organization or content of the OLAP semantic model has changed and, as a result, no data items are available for display in this PivotTable report”, and then removes that level from the worksheet.

SCD Type 2
Anchor
SCD-2
SCD-2

SCD Type 2 includes historical data along with current data.  It includes another dimension record to track the full history of values and uses keys to identify each one. Each change includes an effective and expiration time. 

...

For example, date <> start date and end date. 

From Kyvos 2025.1 onwards, Kyvos now supports the following for No-Spark:

  • The 'is between' non-equi join in semantic model processing.

  • The ‘is between’ operator for the Snowflake dataset relation.