DSVs and Object Bindings - Microsoft SQL Server 2008 Analysis Services - page 321

LISTING 18.6 DSVTableBinding

<Partition>
<ID>Sales Fact 1997</ID>
<Name>Sales Fact 1997</Name>
<State>Unprocessed</State>
<Source xsi:type=”DsvTableBinding”>
<DataSourceViewID>FoodMart 2008</DataSourceViewID>
<TableID>dbo_sales_fact_1997</TableID>
</Source>
<StorageMode>Molap</StorageMode>
<CurrentStorageMode>Molap</CurrentStorageMode>
<ProcessingMode>Regular</ProcessingMode>
</Partition>

All partitions in a measure group have the same structure: Their structure is defined by
granularity attributes and measures in the measure group. When a measure group has
many partitions, it becomes impractical to create a table in DSV for each partition. In
addition to the DSVTableBinding , Analysis Services supports TableBinding , which allows
mapping of a multidimensional object, such as partition, to a relational table.
TableBinding supports the following properties: DataSourceID , DbTableName , and
DbSchemaName . Figure 18.3 shows the way Analysis Services uses TableBinding to load data
from a relational engine into a partition.

Data Source View Sales Measure Group

SQL Server

SQL Server

Sales 1997 Table

Sales 1997 Table Partition Sales 1997

Default
DSVTableBinding

Sales 1998 Table DataSourceID=DataSource Partition Sales 1998

TableBinding

DataSource

Provider=SQLOLEDB;
Server=mysqlserver;database=Foodmart 2008;

FIGURE 18.3

Partition is bound to relational table.