FromClause (Dimension Interface)

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 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

Beispiel

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

Siehe auch

Verweis

Dimension Interface

Hilfe und Informationen

Informationsquellen für SQL Server 2005