Export (0) Print
Expand All
Expand Minimize

DirectQueryMode Enumeration

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
DirectQueryIndicates that queries against the model should reference only the relational data source.
DirectQueryWithInMemoryIndicates that queries against the model should reference primarily the relational data source but can use the cache if available.
InMemoryIndicates that queries against the model should use only the in-memory data store.
InMemoryWithDirectQueryIndicates 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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft