Table of contents
- Programming Analysis Services Applications
- Analysis Services Architecture
- Analysis Services Component Tools
- SQL in Analysis Services
-
Decision Support Objects
- Introducing Decision Support Objects
- Redistributing Decision Support Objects
-
Decision Support Objects Architecture
- Server (Decision Support Objects)
- Database (Decision Support Objects)
- DataSource (Decision Support Objects)
- Cube (Decision Support Objects)
- Dimension (Decision Support Objects)
- Data Mining Model (Decision Support Objects)
- Role (Decision Support Objects)
- Aggregation (Decision Support Objects)
- Command (Decision Support Objects)
- Level (Decision Support Objects)
- Measure (Decision Support Objects)
- Member Property (Decision Support Objects)
- Partition (Decision Support Objects)
- Column (Decision Support Objects)
- Cube Analyzer (Decision Support Objects)
- Partition Analyzer (Decision Support Objects)
- Using Decision Support Objects
-
Decision Support Objects Programmer's Reference
-
Interfaces
-
Command Interface
- Collections, Command Interface
- Methods, Command Interface
-
Properties, Command Interface
- ClassType (Command Interface)
- CommandType (Command Interface)
- Description (Command Interface)
- IsValid (Command Interface)
- Name (Command Interface)
- OrdinalPosition (Command Interface)
- Parent (Command Interface)
- ParentObject (Command Interface)
- Statement (Command Interface)
- SubClassType (Command Interface)
-
Dimension Interface
- Collections, Dimension Interface
- Methods, Dimension Interface
-
Properties, Dimension Interface
- AggregationUsage (Dimension Interface)
- AllowSiblingsWithSameName (Dimension Interface)
- AreMemberKeysUnique
- AreMemberNamesUnique (Dimension Interface)
- ClassType (Dimension Interface)
- DataMemberCaptionTemplate (Dimension Interface)
- DataSource (Dimension Interface)
- DefaultMember (Dimension Interface)
- DependsOnDimension (Dimension Interface)
- Description (Dimension Interface)
- DimensionType (Dimension Interface)
- EnableRealTimeUpdates (Dimension Interface)
- FromClause (Dimension Interface)
- IsChanging (Dimension Interface)
- IsReadWrite (Dimension Interface)
- IsShared (Dimension Interface)
- IsTemporary (Dimension Interface)
- IsValid (Dimension Interface)
- IsVirtual (Dimension Interface)
- IsVisible (Dimension Interface)
- JoinClause (Dimension Interface)
- LastProcessed (Dimension Interface)
- LastUpdated (Dimension Interface)
- MembersWithData (Dimension Interface)
- Name (Dimension Interface)
- OrdinalPosition (Dimension Interface)
- Parent (Dimension Interface)
- SourceTable (Dimension Interface)
- SourceTableAlias (Dimension Interface)
- SourceTableFilter (Dimension Interface)
- State (Dimension Interface)
- StorageMode (Dimension Interface)
- SubClassType (Dimension Interface)
-
Level Interface
- Collections, Level Interface
-
Properties, Level Interface
- AreMemberKeysUnique (Level Interface)
- AreMemberNamesUnique (Level Interface)
- ClassType (Level Interface)
- ColumnSize (Level Interface)
- ColumnType (Level Interface)
- CustomRollupColumn (Level Interface)
- CustomRollupExpression (Level Interface)
- CustomRollupPropertiesColumn (Level Interface)
- Description (Level Interface)
- EnableAggregations (Level Interface)
- EstimatedSize (Level Interface)
- FromClause (Level Interface)
- Grouping (Level Interface)
- HideMemberIf (Level Interface)
- IsDisabled (Level Interface)
- IsValid (Level Interface)
- IsVisible (Level Interface)
- JoinClause (Level Interface)
- LevelNamingTemplate (Level Interface)
- LevelType (Level Interface)
- MemberKeyColumn (Level Interface)
- MemberNameColumn (Level Interface)
- Name (Level Interface)
- Ordering (Level Interface)
- OrderingMemberProperty (Level Interface)
- OrdinalPosition (Level Interface)
- Parent (Level Interface)
- ParentKeyColumn (Level Interface)
- RootMemberIf (Level Interface)
- SkippedLevelsColumn (Level Interface)
- SliceValue (Level Interface)
- SubClassType (Level Interface)
- UnaryOperatorColumn (Level Interface)
-
MDStore Interface
- Collections, MDStore Interface
- Methods, MDStore Interface
-
Properties, MDStore Interface
- AggregationPrefix (MDStore Interface)
- AllowDrillThrough (MDStore Interface)
- Analyzer (MDStore Interface)
- ClassType (MDStore Interface)
- DefaultMeasure (MDStore Interface)
- Description (MDStore Interface)
- DrillThroughColumns (MDStore Interface)
- DrillThroughFilter (MDStore Interface)
- DrillThroughFrom (MDStore Interface)
- DrillThroughJoins (MDStore Interface)
- EnableRealTimeUpdates (MDStore Interface)
- EstimatedRows (MDStore Interface)
- EstimatedSize (MDStore Interface)
- FromClause (MDStore Interface)
- IsDefault (MDStore Interface)
- IsReadWrite (MDStore Interface)
- IsTemporary (MDStore Interface)
- IsValid (MDStore Interface)
- IsVisible (MDStore Interface)
- JoinClause (MDStore Interface)
- LastProcessed (MDStore Interface)
- LastUpdated (MDStore Interface)
- LazyOptimizationProgress (MDStore Interface)
- Name (MDStore Interface)
- OlapMode (MDStore Interface)
- Parent (MDStore Interface)
- ProcessingKeyErrorLimit (MDStore Interface)
- ProcessingKeyErrorLogFileName (MDStore Interface)
- ProcessOptimizationMode (MDStore Interface)
- RemoteServer (MDStore Interface)
- Server (MDStore Interface)
- SourceTable (MDStore Interface)
- SourceTableAlias (MDStore Interface)
- SourceTableFilter (MDStore Interface)
- State (MDStore Interface)
- SubClassType (MDStore Interface)
-
Measure Interface
- Collections, Measure Interface
-
Properties, Measure Interface
- AggregateFunction (Measure Interface)
- ClassType (Measure Interface)
- Description (Measure Interface)
- FormatString (Measure Interface)
- IsValid (Measure Interface)
- IsVisible (Measure Interface)
- Name (Measure Interface)
- OrdinalPosition (Measure Interface)
- Parent (Measure Interface)
- SourceColumn (Measure Interface)
- SourceColumnType (Measure Interface)
- SubClassType (Measure Interface)
- Role Interface
-
Command Interface
- Events
-
Objects
- clsAggregation
- clsAggregationDimension
- clsAggregationLevel
- clsAggregationMeasure
- clsCollection
-
clsColumn
- Collections, clsColumn
-
Properties, clsColumn
- AreKeysUnique (clsColumn)
- ClassType (clsColumn)
- ContentType (clsColumn)
- DataType (clsColumn)
- Description (clsColumn)
- Distribution (clsColumn)
- Filter (clsColumn)
- FromClause (clsColumn)
- IsDisabled (clsColumn)
- IsInput (clsColumn)
- IsKey (clsColumn)
- IsParentKey (clsColumn)
- IsPredictable (clsColumn)
- JoinClause (clsColumn)
- ModelingFlags (clsColumn)
- Name (clsColumn)
- Num (clsColumn)
- Parent (clsColumn)
- RelatedColumn (clsColumn)
- SourceColumn (clsColumn)
- SourceOlapObject (clsColumn)
- SpecialFlag (clsColumn)
- SubClassType (clsColumn)
- clsCube
- clsCubeAnalyzer
- clsCubeCommand
- clsCubeDimension
- clsCubeLevel
- clsCubeMeasure
- clsCubeRole
- clsDatabase
- clsDatabaseCommand
- clsDatabaseDimension
- clsDatabaseLevel
- clsDatabaseRole
-
clsDataSource
- Collections, clsDataSource
- Methods, clsDataSource
-
Properties, clsDataSource
- ClassType (clsDataSource)
- CloseQuoteChar (clsDataSource)
- Connection (clsDataSource)
- ConnectionString (clsDataSource)
- Description (clsDataSource)
- IsReadOnly (clsDataSource)
- IsValid (clsDataSource)
- Name (clsDataSource)
- OpenQuoteChar (clsDataSource)
- Parent (clsDataSource)
- SubClassType (clsDataSource)
- SupportedTxnDDL (clsDataSource)
-
clsMemberProperty
- Collections, clsMemberProperty
-
Properties, clsMemberProperty
- Caption (clsMemberProperty)
- ClassType (clsMemberProperty)
- ColumnSize (clsMemberProperty)
- ColumnType (clsMemberProperty)
- Description (clsMemberProperty)
- IsVisible (clsMemberProperty)
- Language (clsMemberProperty)
- Name (clsMemberProperty)
- OrdinalPosition (clsMemberProperty)
- Parent (clsMemberProperty)
- PropertyType (clsMemberProperty)
- SourceColumn (clsMemberProperty)
- SubClassType (clsMemberProperty)
-
clsMiningModel
- Collections, clsMiningModel
- Methods, clsMiningModel
-
Properties, clsMiningModel
- AreKeysUnique (clsMiningModel)
- CaseDimension (clsMiningModel)
- CaseLevel (clsMiningModel)
- ClassType (clsMiningModel)
- Description (clsMiningModel)
- Filter (clsMiningModel)
- FromClause (clsMiningModel)
- IsVisible (clsMiningModel)
- JoinClause (clsMiningModel)
- LastProcessed (clsMiningModel)
- LastUpdated (clsMiningModel)
- MiningAlgorithm (clsMiningModel)
- Name (clsMiningModel)
- Parameters (clsMiningModel)
- Parent (clsMiningModel)
- SourceCube (clsMiningModel)
- State (clsMiningModel)
- SubClassType (clsMiningModel)
- TrainingQuery (clsMiningModel)
- XML (clsMiningModel)
- clsMiningModelRole
- clsPartition
- clsPartitionAnalyzer
- clsPartitionDimension
- clsPartitionLevel
- clsPartitionMeasure
- clsRoleCommand
- clsServer
- Property Object
-
Enumerations
- AggregatesTypes
- ClassTypes
- CloneOptions
- CommandTypes
- DimensionAggUsageTypes
- DimensionTypes
- ErrorCodes
- GroupingValues
- HideIfValues
- LanguageValues
- LevelTypes
- MembersWithDataValues
- OlapEditions
- OlapLockTypes
- OlapStateTypes
- OlapStorageModes
- OrderTypes
- ProcessOptimizationModes
- ProcessTypes
- PropertyTypeValue
- RootIfValues
- ServerStates
- StorageModeValues
- SubClassTypes
- Collections
-
Interfaces
- Add-ins
-
PivotTable Service
- Overview of PivotTable Service
- Key Concepts in PivotTable Service
- Client Operations in PivotTable Service
-
PivotTable Service Programmer's Reference
-
PivotTable Service Properties
- ArtificialData Property
- Authenticated User Property
- Auto Synch Period Property
- Cache Policy Property
- Cache Ratio Property
- Client Cache Size Property
- CompareCaseNotSensitiveStringFlags Property
- CompareCaseSensitiveStringFlags Property
- Connect Timeout Property
- CreateCube Property
- Data Source Property
- Datasource Connection Type Property
- Default GUID Dialect Property
- Default Isolation Mode Property
- Default MDX Visual Mode Property
- Distinct Measures By Key Property
- Do Not Apply Commands Property
- Execution Location Property
- Initial Catalog Property
- InsertInto Property
- Large Level Threshold Property
- Locale Identifier Property
- Log File Property
- MDX Calculated Members Mode Property
- MDX Compatibility Property
- MDX Object Qualification Property
- MDX Unique Name Style Property
- Mining Execution Location Property
- Mining Location Property
- Mining Persistence Format Property
- OLE DB for OLAP Version Property
- Password Property
- Provider Property
- Read Only Session Property
- Roles Property
- Safety Options Property
- Secured Cell Value Property
- Show Hidden Cubes Property
- Source_DSN Property
- Source_DSN_Suffix Property
- SQL Compatibility Property
- SSPI Property
- UseExistingFile Property
- User ID Property
- Writeback Timeout Property
-
Data Definition Language
- ALTER CUBE Statement
- CREATE ACTION Statement
- CREATE CACHE Statement
- CREATE CELL CALCULATION Statement
- CREATE CUBE Statement
- CREATE MEMBER Statement
- CREATE MINING MODEL Statement
- CREATE SET Statement
- DROP ACTION Statement
- DROP CUBE Statement
- DROP CELL CALCULATION Statement
- DROP LIBRARY Statement
- DROP MEMBER Statement
- DROP MINING MODEL Statement
- DROP SET Statement
- REFRESH CUBE Statement
- USE LIBRARY Statement
- Data Manipulation Language
- Function Reference
- Schema Rowsets
-
PivotTable Service Properties
- Analysis Services Programming Samples