TableBinding Data Type (ASSL)

Defines a derived data type that represents a binding to a table.

Syntax


<TableBinding>  
   <!-- The following elements extend TabularBinding -->  
   <DataSourceID>...</DataSourceID>  
   <DbTableName>...</DbTableName>  
   <DbSchemaName>...</DbSchemaName>  
</TableBinding>  

Data Type Characteristics

Characteristic Description
Base data types TabularBinding
Derived data types None

Data Type Relationships

Relationship Element
Parent elements None
Child elements DataSourceID, DbSchemaName, DbTableName
Derived elements See Binding

Remarks

Note that referencing other tables in the filter expression by use of a subselect could have performance implications in some data sources. However, the designer can totally control the SQL expression by defining a named query in the data source view, and then referencing that.

The method of defining the bindings for a partition are independent of the use of partitioned tables in the data source view.

As an example, consider a measure group whose default table is "Sales," with columns Date, Product ID, Qty, Price, and Amount (calculated in the data source view). Then the partition "Sales97" could use the table "Sales97" with filter "Year(Sales.Date) = 97."

The effective query is:

SELECT Date, Product ID, Qty, Price, Qty * Price AS Amount   
   FROM Sales97 As Sales  
   WHERE Year(Sales.Date) = 97  

The calculated expression still applies, even if the expression used qualified table names (for example, Sales.Qty). The same applies if instead the table were replaced by some query "SELECT…" The FROM clause above would become "FROM SELECT ... As Sales."

For more information about the Binding type, including tables of Analysis Services Scripting Language (ASSL) objects of type Binding and the inheritance hierarchy of Binding types, see Binding Data Type (ASSL).

For an overview of data bindings in ASSL, see Data Sources and Bindings (SSAS Multidimensional).

The corresponding element in the Analysis Management Objects (AMO) object model is TableBinding.

See Also

Binding Data Type (ASSL)
Data Sources and Bindings (SSAS Multidimensional)
Analysis Services Scripting Language XML Data Types (ASSL)