DataSource (Dimension Interface)
.gif "ms132827.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein. |
The DataSource property of the Dimension interface specifies the source of the data to be used by a dimension object.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
clsDatabaseDimension |
R/W* |
clsCubeDimension |
R** |
clsPartitionDimension |
R** |
clsAggregationDimension |
R |
* Not implemented for virtual dimensions created in Microsoft® SQL Server™ 7.0 OLAP Services. ** Not implemented for virtual dimensions.
Beispiel
Use the following code to add a data source to a database object:
'Assume an object (dsoDB) of ClassType clsDatabase exists.
'Add a new data source to database.
Dim dsoDS as DSO.DataSource
Set dsoDS = dsoDB.DataSources.AddNew("FoodMart 2000")
dsoDS.Name = "FoodMart"
dsoDS.ConnectionString = "Provider=MSDASQL.1;" &_
"Persist Security Info=False;" &_
"Data Source=FoodMart; " &_
"Connect Timeout=15"
'Update the database.
dsoDB.Update