The DataSource property of the Dimension interface specifies the source of the data to be used by a dimension object.
| clsAggregationDimension | clsDatabaseDimension (excluding virtual dimensions) |
| clsCubeDimension (excluding virtual cube dimensions) |
clsPartitionDimension (excluding virtual dimensions) |
clsDataSource
The access type depends on the class of the dimension object.
| Class | Access |
|---|---|
| clsDatabaseDimension | R/W |
| clsCubeDimension | R |
| clsPartitionDimension | R |
| clsAggregationDimension | R |
'Assume an object (dsoDB) of ClassType clsDatabase exists
'Add new data source to database
Dim dsoDS as DSO.DataSource
Set dsoDS = dsoDB.DataSources.AddNew("FoodMart")
dsoDS.Name = "FoodMart"
dsoDS.ConnectionString = "Provider=MSDASQL.1;" &_
"Persist Security Info=False;" &_
"Data Source=FoodMart; " &_
"Connect Timeout=15"
'Update the database
dsoDB.Update
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |