Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

DirectQueryMode Enumeration

 

Applies To: SQL Server 2016 Preview

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

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.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.

After the model has been enabled for Direct Query access, you must also set a property on the data source that specifies whether to use Direct Query only, or to use a hybrid mode. For more information, see DirectQuery Mode (SSAS Tabular).

Return to top

Community Additions

Show:
© 2015 Microsoft