FromClause (Dimension Interface)

Примечание.
В следующей версии Microsoft SQL Server эта возможность будет удалена. Не используйте ее при работе над новыми приложениями и как можно быстрее измените приложения, в которых она в настоящее время используется.

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

Пример

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

См. также

Справочник

Dimension Interface

Справка и поддержка

Получение помощи по SQL Server 2005