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 |