ALTER DATABASE DWH
SET READ_COMMITTED_SNAPSHOT ON
GO

ALTER DATABASE DWH
SET ALLOW_SNAPSHOT_ISOLATION ON
GO

ALTER DATABASE DWH
SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT ON
GO

Error: 0xC1060000 at Time, Analysis Services Execute DDL Task: Ошибка OLE DB: Ошибка OLE DB или ODBC : Memory optimized tables and natively compiled modules cannot be accessed or created when the session TRANSACTION ISOLATION LEVEL is set to SNAPSHOT.; 42000.

CREATE VIEW [updatable].[view_dimTimeLossCause]
AS
	SELECT tlCause.IsTimeLossCauseArchive		AS IsTimeLossCauseArchive
		, tlArchiveYN.Name						AS IsTimeLossCauseArchiveName
		, tlCause.TimeLossCauseDWID				AS TimeLossCauseDWID
		, tlCause.TimeLossCauseName				AS TimeLossCauseName
		FROM updatable.dictTimeLossCause	AS tlCause (nolock)
			LEFT JOIN const.[YesNo]			AS tlArchiveYN (nolock)
				ON tlCause.IsTimeLossCauseArchive = tlArchiveYN.DWID
GO

Ошибки модуля хранения OLAP: При обработке dimension с идентификатором "View Dim Time Loss Cause" и именем "Причина списания" произошла ошибка.