DirectQueryMode Enumeration

 

Applies To: SQL Server (starting with 2016)

Indicates whether a tabular model is enabled for use in Direct Query mode.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices.Core (in Microsoft.AnalysisServices.Core.dll)

public enum DirectQueryMode

Member nameDescription
DirectQuery

Indicates that queries against the model should reference only the relational data source.

DirectQueryWithInMemory

Indicates that queries against the model should reference primarily the relational data source but can use the cache if available.

InMemory

Indicates that queries against the model should use only the in-memory data store.

InMemoryWithDirectQuery

Indicates that queries against the model should reference the xVelocity in-memory analytics engine (VertiPaq) cache first, and then the relational data source.

Return to top
Show: