DataSource

The DataSource property of the Dimension interface specifies the source of the data to be used by a dimension object.

Applies To
clsAggregationDimension clsDatabaseDimension
(excluding virtual dimensions)
clsCubeDimension
(excluding virtual cube dimensions)
clsPartitionDimension
(excluding virtual dimensions)

Data Type

clsDataSource

Access

The access type depends on the class of the dimension object.

Class Access
clsDatabaseDimension R/W
clsCubeDimension R
clsPartitionDimension R
clsAggregationDimension R

Example

'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

See Also
About Decision Support Objects Using Decision Support Objects
Properties Cross-Reference  

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.