Versions Compared

Version Old Version 4 New Version 5
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

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. 

...

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

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

  • A column in multiple relations with the same target node.

...