Programming Analysis Services Applications
Analysis Services Architecture
Analysis Services Component Tools
SQL in Analysis Services
Executing an SQL Query
Exposed Schema
Supported SQL SELECT Syntax
Passing Queries from SQL Server to a Linked Analysis Server
Adding a Linked Server
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
Development Environments
Common Operations and Examples
OLAP Examples
Working with Servers
Working with Databases
Working with Data Sources
Working with Dimensions and Levels
Working with Cubes and Measures
Data Mining Examples
Building Data Mining Models
Advanced Examples
Working with Virtual Cubes
Working with Linked Cubes
Working with Virtual Dimensions
Working with Roles
Incremental Updates
Additional Considerations
Considerations For Naming Decision Support Objects
Object Locking with Decision Support Objects
Tips for Creating Member Properties for Multiple Languages
Using Earlier Versions of Analysis Services
Decision Support Objects Programmer's Reference
Interfaces
Command Interface
Collections, Command Interface
Methods, Command Interface
Clone (Command Interface)
LockObject (Command Interface)
UnlockObject (Command Interface)
Update (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
CustomProperties (Dimension Interface)
Levels (Dimension Interface)
Methods, Dimension Interface
Clone (Dimension Interface)
LockObject (Dimension Interface)
Process (Dimension Interface)
UnlockObject (Dimension Interface)
Update (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
BeginTrans (MDStore Interface)
Clone (MDStore Interface)
CommitTrans (MDStore Interface)
LockObject (MDStore Interface)
Merge (MDStore Interface)
Process (MDStore Interface)
Rollback (MDStore Interface)
UnlockObject (MDStore Interface)
Update (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
Collections, Role Interface
Methods, Role Interface
Clone (Role Interface)
LockObject (Role Interface)
SetPermissions (Role Interface)
UnlockObject (Role Interface)
Update (Role Interface)
Properties, Role Interface
ClassType (Role Interface)
Description (Role Interface)
IsValid (Role Interface)
Name (Role Interface)
Parent (Role Interface)
ParentObject (Role Interface)
Permissions (Role Interface)
SubClassType (Role Interface)
UsersList (Role Interface)
Events
ReportAfter (clsDatabase)
ReportBefore (clsDatabase)
ReportError (clsDatabase)
ReportProgress (clsDatabase)
Objects
clsAggregation
Collections, clsAggregation
Methods, clsAggregation
Properties, clsAggregation
clsAggregationDimension
Collections, clsAggregationDimension
Properties, clsAggregationDimension
clsAggregationLevel
Collections, clsAggregationLevel
Properties, clsAggregrationLevel
clsAggregationMeasure
Collections, clsAggregationMeasure
Properties, clsAggregationMeasure
clsCollection
Methods, clsCollection
Add (clsCollection)
AddNew (clsCollection)
Find (clsCollection)
Item (clsCollection)
Remove (clsCollection)
Properties, clsCollection
ClassType (clsCollection)
ContainedClassType (clsCollection)
Count (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
Collections, clsCube
Methods, clsCube
Properties, clsCube
clsCubeAnalyzer
Methods, clsCubeAnalyzer
OpenQueryLogRecordset (clsCubeAnalyzer)
clsCubeCommand
Collections, clsCubeCommand
Properties, clsCubeCommand
clsCubeDimension
Collections, clsCubeDimension
Properties, clsCubeDimension
clsCubeLevel
Collections, clsCubeLevel
Properties, clsCubeLevel
clsCubeMeasure
Collections, clsCubeMeasure
Properties, clsCubeMeasure
clsCubeRole
Collections, clsCubeRole
Methods, clsCubeRole
Properties, clsCubeRole
clsDatabase
Collections, clsDatabase
Events, clsDatabase
Methods, clsDatabase
Properties, clsDatabase
clsDatabaseCommand
Collections, clsDatabaseCommand
Methods, clsDatabaseCommand
Properties, clsDatabaseCommand
clsDatabaseDimension
Collections, clsDatabaseDimension
Methods, clsDatabaseDimension
Properties, clsDatabaseDimension
clsDatabaseLevel
Collections, clsDatabaseLevel
Properties, clsDatabaseLevel
clsDatabaseRole
Collections, clsDatabaseRole
Methods, clsDatabaseRole
Properties, clsDatabaseRole
clsDataSource
Collections, clsDataSource
Methods, clsDataSource
Clone (clsDataSource)
IsConnected (clsDataSource)
LockObject (clsDataSource)
UnlockObject (clsDataSource)
Update (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
Clone (clsMiningModel)
LockObject (clsMiningModel)
Process (clsMiningModel)
UnlockObject (clsMiningModel)
Update (clsMiningModel)
ValidateStructure (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
Collections, clsMiningModelRole
Methods, clsMiningModelRole
Properties, clsMiningModelRole
clsPartition
Collections, clsPartition
Methods, clsPartition
Properties, clsPartition
clsPartitionAnalyzer
Collections, clsPartitionAnalyzer
DesignedAggregations (clsPartitionAnalyzer)
Methods, clsPartitionAnalyzer
AddExistingAggregation (clsPartitionAnalyzer)
AddGoalQuery (clsPartitionAnalyzer)
CloseAggregationsAnalysis (clsPartitionAnalyzer)
InitializeDesign (clsPartitionAnalyzer)
NextAnalysisStep (clsPartitionAnalyzer)
PrepareGoalQueries (clsPartitionAnalyzer)
Properties, clsPartitionAnalyzer
AggregationAnalysisInitialized (clsPartitionAnalyzer)
Parent (clsPartitionAnalyzer)
clsPartitionDimension
Collections, clsPartitionDimension
Properties, clsPartitionDimension
clsPartitionLevel
Collections, clsPartitionLevel
Properties, clsPartitionLevel
clsPartitionMeasure
Collections, clsPartitionMeasure
Properties, clsPartitionMeasure
clsRoleCommand
Collections, clsRoleCommand
Properties, clsRoleCommand
clsServer
Collections, clsServer
Methods, clsServer
CloseServer (clsServer)
Connect (clsServer)
CreateObject (clsServer)
LockObject (clsServer)
Refresh (clsServer)
UnlockAllObjects (clsServer)
UnlockObject (clsServer)
Update (clsServer)
Properties, clsServer
ClassType (clsServer)
ConnectTimeout (clsServer)
Description (clsServer)
Edition (clsServer)
IsValid (clsServer)
LockTimeout (clsServer)
Name (clsServer)
Parent (clsServer)
ProcessingLogFileName (clsServer)
ServiceState (clsServer)
State (clsServer)
Timeout (clsServer)
Version (clsServer)
Property Object
Properties, Property Object
DataType (Property Object)
Name (Property Object)
Value (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
Nested Collections
Commands Collection
CustomProperties Collection
Methods, CustomProperties
Add (CustomProperties Collection)
Clear (CustomProperties Collection)
Item (CustomProperties Collection)
Remove (CustomProperties Collection)
Properties, CustomProperties
Count (CustomProperties Collection)
Columns Collection
DataSources Collection
Dimensions Collection
Levels Collection
MDStores Collection
Measures Collection
MemberProperties Collection
MiningModels Collection
Roles Collection
Add-ins
About Add-ins
Building Add-ins
Tutorial - Creating a Sample Add-in
Example - Report Add-In
Programmer's Reference (Add-ins)
Interfaces
IOlapAddIn Interface
Methods, IOlapAddIn Interface
ExecuteMenuItem (IOlapAddIn Interface)
GetObject (IOlapAddIn Interface)
ProvideChildNodes (IOlapAddIn Interface)
ProvideHTML (IOlapAddIn Interface)
ProvideIcon (IOlapAddIn Interface)
ProvideMenuItems (IOlapAddIn Interface)
Properties, IOlapAddIn Interface
Name (IOlapAddIn Interface)
Objects
OlapMenuItem
Properties, OlapMenuItem
Caption (OlapMenuItem)
Disabled (OlapMenuItem)
Flags (OlapMenuItem)
HelpContextId (OlapMenuItem)
HelpFileName (OlapMenuItem)
Key (OlapMenuItem)
OwnerAddInName (OlapMenuItem)
OwnerAddInProgID (OlapMenuItem)
ParentKey (OlapMenuItem)
OlapTreeNode
Properties, OlapTreeNode
Caption (OlapTreeNode)
HelpContextId (OlapTreeNode)
IconClosed (OlapTreeNode)
IconOpen (OlapTreeNode)
LinkedObject (OlapTreeNode)
OwnerAddInName (OlapTreeNode)
OwnerAddInProgID (OlapTreeNode)
Parent (OlapTreeNode)
Enumerations
errDSSAddinErrorNumbers
OlapMenuFlags
OlapMenuTypes
RefreshTreeTypes
Collections
OlapMenuItems
Methods, OlapMenuItems
Add (OlapMenuItems)
Remove (OlapMenuItems)
Properties, OlapMenuItems
Count (OlapMenuItems)
Item (OlapMenuItems)
OlapTreeNodes
Methods, OlapTreeNodes
Add (OlapTreeNodes)
Remove (OlapTreeNodes)
Properties, OlapTreeNodes
Count (OlapTreeNodes)
Item (OlapTreeNodes)
PivotTable Service
Overview of PivotTable Service
What's New in PivotTable Service
Redistributing Components
Developing Client Applications
Development Environments
Using Visual C++
Using Visual Basic
Using ADO MD
Using ADO
Using Active Server Pages
Key Concepts in PivotTable Service
Context of Connections
Connected to Analysis Services
Connected to an OLE DB Provider
Connected to a Local Cube File or Data Mining Model
Organization of Multidimensional Data
Balanced Hierarchies
Ragged Hierarchies
Unbalanced Hierarchies
Using the MDX Compatibility Property
Advanced Data Mining and Analysis
Building a Local Data Mining Model
Training a Local Data Mining Model
Predictions and Results of Data Mining
Working with OLAP Data
Calculated Members
Managing the Client Cache
Transactions in Analysis Services
Updating Cubes
Transaction Scope
Synchronization of Client and Server
Cumulative Effect of Transactions on Data
Isolation Levels
Committing a Transaction
Commit Time-out
Security in PivotTable Service
Client Operations in PivotTable Service
Error and Exception Handling
Connecting to a Data Source
Using the Connection String
Using the OLE DB Connection Dialog Box
Connecting Using HTTP
Retrieving Schema Information
Using the CubeDef Object
Using the OpenSchema Method
Retrieving Data
Using the Cellset Object
Using the Recordset Object
Updating Information in a Cube
Writing a Value Back to a Cell
Transaction Processing
Building Local Cubes
Using the CREATE CUBE Statement
Using the INSERT INTO Statement
Processing a Local Cube
Defining Calculated Members
Refreshing Local Cubes
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
DRILLTHROUGH Statement
INSERT INTO Statement
SELECT Statement
UPDATE CUBE Statement
Function Reference
OLAP Functions
Data Mining Functions
BottomCount
BottomPercent
BottomSum
Cluster
ClusterDistance
ClusterProbability
Predict
PredictAdjustedProbability
PredictHistogram
PredictProbability
PredictStdev
PredictSupport
PredictVariance
RangeMax
RangeMid
RangeMin
Sub-SELECT
TopCount
TopPercent
TopSum
Schema Rowsets
OLAP Schema Rowsets
MDSCHEMA_ACTIONS
MDSCHEMA_CELL_FORMULAS
MDSCHEMA_CUBES
MDSCHEMA_DIMENSIONS
MDSCHEMA_FUNCTIONS
MDSCHEMA_HIERARCHIES
MDSCHEMA_LEVELS
MDSCHEMA_MEASURES
MDSCHEMA_MEMBERS
MDSCHEMA_PROPERTIES
MDSCHEMA_SETS
Data Mining Schema Rowsets
MINING_COLUMNS
MINING_MODEL_CONTENT
MINING_MODEL_CONTENT_PMML
MINING_MODELS
MINING_SERVICE_PARAMETERS
MINING_SERVICES
Analysis Services Programming Samples
Simple Cube Creation
Cube Query and Result Set Manipulation
Cube Schema Retrieval and Manipulation
Complex Cube Creation and Manipulation