FromClause (Dimension Interface)
[!REMARQUE]
Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.
The FromClause property of the Dimension interface contains the SQL FROM clause for the dimension.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
String
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/W |
Exemple
A database contains the following tables:
Sales_Facts
Customer
Product
Product_Class
Promotion
Store
Calendar
The following diagram illustrates the relationships of these tables.
Use the following code to create a dimension, assign a data source, and set the FromClause property:
Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore
Dim dsoDS As DSO.DataSource
Dim dsoDim As DSO.Dimension
' Connect to local Analysis server.
dsoServer.Connect "LocalHost"
' Open TestDB database.
Set dsoDB = dsoServer.MDStores("TestDB")
' Create a Product dimension for the database.
Set dsoDim = dsoDB.Dimensions.AddNew("Products")
' Create a data source.
Set dsoDS = dsoDB.DataSources.AddNew("FoodMart 2000")
dsoDS.ConnectionString = "Provider=MSDASQL.1;" & _
"Persist Security Info=False;" & _
"Data Source=FoodMart;" & _
"Connect Timeout=15"
' Assign the data source to the dimension.
Set dsoDim.DataSource = dsoDS 'Set the dimension data source.
dsoDim.FromClause = "product" 'Set the source dimension table.
' Update the database.
dsoDB.Update