Condividi tramite


FromClause (Dimension Interface)

[!NOTA]

  Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.

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

Esempio

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

Vedere anche

Riferimento