FromClause (Dimension Interface)
Observação |
---|
Esse recurso será removido na próxima versão do Microsoft SQL Server. Não utilize esse recurso em desenvolvimentos novos e modifique, assim que possível, os aplicativos que atualmente o utilizam. |
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 |
Exemplo
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