SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Analysis Services)

Microsoft.AnalysisServices

Account Class

AccountCollection Class

AccountTypes Class

Action Class

ActionCollection Class

ActionInvocation Enumeration

ActionTargetType Enumeration

ActionType Enumeration

AddEventArgs Class

Aggregation Class

AggregationAttribute Class

AggregationAttributeCollection Class

AggregationCollection Class

AggregationDesign Class

AggregationDesignAttribute Class

AggregationDesignAttributeCollection Class

AggregationDesignCollection Class

AggregationDesignDimension Class

AggregationDesignDimensionCollection Class

AggregationDimension Class

AggregationDimensionCollection Class

AggregationFunction Enumeration

AggregationInstance Class

AggregationInstanceAttribute Class

AggregationInstanceAttributeCollection Class

AggregationInstanceCollection Class

AggregationInstanceDimension Class

AggregationInstanceDimensionCollection Class

AggregationInstanceMeasure Class

AggregationInstanceMeasureCollection Class

AggregationType Enumeration

AggregationUsage Enumeration

AlgorithmParameter Class

AlgorithmParameterCollection Class

Alignment Enumeration

AllowedBindingsHelper Class

AmoException Class

AnalysisState Enumeration

Annotation Class

AnnotationCollection Class

AnnotationVisibility Enumeration

AssemblyCollection Class

AssemblyReferencesHelper Class

AttributeBinding Class

AttributeBindingType Enumeration

AttributePermission Class

AttributePermissionCollection Class

AttributeRelationship Class

AttributeRelationshipCollection Class

AttributeTranslation Class

AttributeTranslationCollection Class

AttributeType Enumeration

AttributeUsage Enumeration

BackupInfo Class

BackupLocation Class

BackupLocationCollection Class

Binding Class

BindingCollection Class

CalculatedMeasureBinding Class

CalculationProperty Class

CalculationPropertyCollection Class

CalculationPropertyVisualizationProperties Class

CalculationType Enumeration

CalendarType Enumeration

Cardinality Enumeration

CellPermission Class

CellPermissionAccess Enumeration

CellPermissionCollection Class

CertUtils Class

ClrAssembly Class

ClrAssemblyFile Class

ClrAssemblyFileCollection Class

ClrAssemblyFileType Enumeration

CollectionChangeEventArgs Class

CollectionChangeEventHandler Delegate

ColumnBinding Class

ComAssembly Class

Command Class

CommandCollection Class

ConnectionException Class

ConnectionExceptionCause Enumeration

ConnectionInfo Class

ConnectionStringSecurity Enumeration

ConnectionType Enumeration

ContextualNameRule Enumeration

Cube Class

CubeAttribute Class

CubeAttributeBinding Class

CubeAttributeCollection Class

CubeCollection Class

CubeDimension Class

CubeDimensionBinding Class

CubeDimensionCollection Class

CubeDimensionPermission Class

CubeDimensionPermissionCollection Class

CubeHierarchy Class

CubeHierarchyCollection Class

CubePermission Class

CubePermissionCollection Class

DataAggregationMode Enumeration

DatabaseCollection Class

DatabasePermission Class

DatabasePermissionCollection Class

DataEmbeddingStyle Enumeration

DataItemCollection Class

DataMiningMeasureGroupDimension Class

DataSource Class

DataSourceCollection Class

DataSourceIsolation Enumeration

DataSourcePermission Class

DataSourcePermissionCollection Class

DataSourceView Class

DataSourceViewBinding Class

DataSourceViewCollection Class

DefaultAggregateFunction Enumeration

DegenerateMeasureGroupDimension Class

DependenciesCalculator Class

DependencyResult Class

DependencyType Enumeration

DesignAggregationsResult Class

Dimension Class

DimensionAttribute Class

DimensionAttributeCollection Class

DimensionAttributeVisualizationProperties Class

DimensionBinding Class

DimensionCollection Class

DimensionPermission Class

DimensionPermissionCollection Class

DimensionStorageMode Enumeration

DimensionType Enumeration

DirectQueryMode Enumeration

DirectQueryUsage Enumeration

DiscretizationMethod Enumeration

DismissedValidationResult Class

DismissedValidationResultCollection Class

DismissedValidationRule Class

DismissedValidationRuleCollection Class

DrillThroughAction Class

DropOptions Enumeration

DsvTableBinding Class

ErrorConfiguration Class

ErrorOption Enumeration

ErrorPriority Enumeration

ExpressionBinding Class

FiscalYearName Enumeration

FoldingParameters Class

Group Class

GroupCollection Class

GroupingBehavior Enumeration

HideIfValue Enumeration

Hierarchy Class

HierarchyCollection Class

HierarchyStructureType Enumeration

HierarchyUniqueNameStyle Enumeration

HierarchyVisualizationProperties Class

IConnectionStringHolder Interface

IdentityProvider Enumeration

IDeserializationStartCallback Interface

IMajorObject Interface

IModelComponent Interface

IModelComponentCollection Interface

ImpactAnalysisType Enumeration

ImpactDetail Class

ImpactDetailCollection Class

ImpersonationInfo Class

ImpersonationInfoSecurity Enumeration

ImpersonationLevel Enumeration

ImpersonationMode Enumeration

INamedComponent Interface

INamedComponentCollection Interface

IncrementalProcessingNotification Class

IncrementalProcessingNotificationCollection Class

InheritedBinding Class

InstanceSelection Enumeration

IntegratedSecurity Enumeration

InvalidXmlCharacters Enumeration

IProcessable Interface

ITrace Interface

KeyErrorAction Enumeration

KeyErrorLimitAction Enumeration

Kpi Class

KpiCollection Class

Level Class

LevelCollection Class

MajorObject Class

MajorObjectCollection Class

ManyToManyMeasureGroupDimension Class

MdxMissingMemberMode Enumeration

MdxScript Class

MdxScriptCollection Class

Measure Class

MeasureBinding Class

MeasureCollection Class

MeasureDataType Enumeration

MeasureEnumerator Class

MeasureGroup Class

MeasureGroupAttribute Class

MeasureGroupAttributeCollection Class

MeasureGroupAttributeType Enumeration

MeasureGroupBinding Class

MeasureGroupCollection Class

MeasureGroupDimension Class

MeasureGroupDimensionBinding Class

MeasureGroupDimensionCollection Class

MeasureGroupType Enumeration

MemberKeysUnique Enumeration

MembersWithData Enumeration

MemberUniqueNameStyle Enumeration

MiningModel Class

MiningModelAlgorithms Class

MiningModelCollection Class

MiningModelColumn Class

MiningModelColumnCollection Class

MiningModelColumnUsages Class

MiningModelingFlags Class

MiningModelPermission Class

MiningModelPermissionCollection Class

MiningStructure Class

MiningStructureCacheMode Enumeration

MiningStructureCollection Class

MiningStructureColumn Class

MiningStructureColumnCollection Class

MiningStructureColumnContents Class

MiningStructureColumnDiscretizationMethods Class

MiningStructureColumnDistributions Class

MiningStructureColumnTypes Class

MiningStructurePermission Class

MiningStructurePermissionCollection Class

ModelComponent Class

ModelComponentCollection Class

ModelType Enumeration

MoveEventArgs Class

Multiplicity Enumeration

NamedComponent Class

NamedComponentCollection Class

NotificationTechnique Enumeration

NullProcessing Enumeration

ObjectReference Class

OlapDataSource Class

OleDbTypeConverter Class

OperationException Class

OptimizationType Enumeration

Optionality Enumeration

OrderBy Enumeration

OutOfSyncException Class

OverrideBehavior Enumeration

Partition Class

PartitionCollection Class

PartitionType Enumeration

Permission Class

PermissionSet Enumeration

PersistenceType Enumeration

Perspective Class

PerspectiveAction Class

PerspectiveActionCollection Class

PerspectiveAttribute Class

PerspectiveAttributeCollection Class

PerspectiveCalculation Class

PerspectiveCalculationCollection Class

PerspectiveCalculationType Enumeration

PerspectiveCollection Class

PerspectiveDimension Class

PerspectiveDimensionCollection Class

PerspectiveHierarchy Class

PerspectiveHierarchyCollection Class

PerspectiveKpi Class

PerspectiveKpiCollection Class

PerspectiveMeasure Class

PerspectiveMeasureCollection Class

PerspectiveMeasureGroup Class

PerspectiveMeasureGroupCollection Class

ProactiveCaching Class

ProactiveCachingAggregationStorage Enumeration

ProactiveCachingBinding Class

ProactiveCachingIncrementalProcessingBinding Class

ProactiveCachingInheritedBinding Class

ProactiveCachingObjectNotificationBinding Class

ProactiveCachingOnlineMode Enumeration

ProactiveCachingQueryBinding Class

ProactiveCachingTablesBinding Class

ProcessableMajorObject Class

ProcessingGroup Enumeration

ProcessingMode Enumeration

ProcessingRecommendation Enumeration

ProcessingState Enumeration

ProcessType Enumeration

PropertyOrderAttribute Class

ProtectionLevel Enumeration

ProtocolFormat Enumeration

QueryBinding Class

QueryNotification Class

QueryNotificationCollection Class

ReadAccess Enumeration

ReadDefinitionAccess Enumeration

ReadSourceDataAccess Enumeration

ReadWriteMode Enumeration

ReferenceDimensionMaterialization Enumeration

ReferenceMeasureGroupDimension Class

RefreshPolicy Enumeration

RefreshType Enumeration

RegularMeasureGroupDimension Class

RelationalDataSource Class

Relationship Class

RelationshipCollection Class

RelationshipEnd Class

RelationshipEndAttribute Class

RelationshipEndAttributeCollection Class

RelationshipEndVisualizationProperties Class

RelationshipType Enumeration

RemoveEventArgs Class

ReportAction Class

ReportingWeekToMonthPattern Enumeration

ReportParameter Class

ReportParameterCollection Class

ResponseFormatException Class

RestoreDataSourceType Enumeration

RestoreFolder Class

RestoreFolderCollection Class

RestoreInfo Class

RestoreLocation Class

RestoreLocationCollection Class

RestoreSecurity Enumeration

Role Class

RoleCollection Class

RoleMember Class

RoleMemberCollection Class

RootIfValue Enumeration

RowBinding Class

RowNumberBinding Class

ScalarMiningStructureColumn Class

ScriptAction Enumeration

ScriptCacheProcessingMode Enumeration

ScriptErrorHandlingMode Enumeration

ScriptInfo Class

ScriptOptions Enumeration

Server Class

ServerEdition Enumeration

ServerLocation Enumeration

ServerMode Enumeration

ServerProperty Class

ServerPropertyCategory Enumeration

ServerPropertyCollection Class

SessionTrace Class

SortDirection Enumeration

StandardAction Class

StorageEngineUsed Enumeration

StorageMode Enumeration

StorageSharingMode Enumeration

TableBinding Class

TableMiningStructureColumn Class

TableNotification Class

TableNotificationCollection Class

TabularBinding Class

TimeAttributeBinding Class

TimeBinding Class

Trace Class

TraceCollection Class

TraceColumn Enumeration

TraceColumnCollection Class

TraceEvent Class

TraceEventArgs Class

TraceEventClass Enumeration

TraceEventCollection Class

TraceEventHandler Delegate

TraceEventSubclass Enumeration

TraceEventSuccess Enumeration

TraceStopCause Enumeration

TraceStoppedEventArgs Class

TraceStoppedEventHandler Delegate

Translation Class

TranslationCollection Class

TransportCompression Enumeration

Trimming Enumeration

UnknownMemberBehavior Enumeration

UpdateMode Enumeration

UpdateOptions Enumeration

UserDefinedGroupBinding Class

Utils Class

ValidationError Class

ValidationErrorCodes Class

ValidationErrorCollection Class

ValidationOptions Enumeration

ValidationResult Class

ValidationResultCollection Class

ValidationRule Class

ValidationRulePriority Enumeration

ValidationRuleType Enumeration

WriteAccess Enumeration

WriteBackTableCreation Enumeration

XmlaError Class

XmlaLocationReference Class

XmlaMessage Class

XmlaMessageCollection Class

XmlaMessageLocation Class

XmlaRequestType Enumeration

XmlaResult Class

XmlaResultCollection Class

XmlaWarning Class

XmlaWarningCollection Class

XmlSerializationException Class

Minimize

This topic has not yet been rated - Rate this topic

DirectQueryUsage Enumeration

SQL Server 2012

Specifies the current DirectQuery usage of the partition.

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

public enum DirectQueryUsage

	Member name	Description
	DirectQueryOnly	Indicates that queries on the partition should use only the relational data source.
	InMemoryOnly	Indicates that queries on the partition should use only the in-memory data store.
	InMemoryWithDirectQuery	Indicates that queries against the model can use either the xVelocity in-memory analytics engine (VertiPaq) cache, or the relational data store. The in-memory data store is preferred if both are available.

Only one partition can be enabled for DirectQuery access at a time. To use a partition in Direct Query mode, the storage mode of the model must have been previously changed to enable DirectQuery mode. For more information, see Partitions and DirectQuery Mode (SSAS Tabular).

Reference

Microsoft.AnalysisServices Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.