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

LISTING 18.8

A Partition Defined with Query Binding

<Partition>
<ID>sales_fact_dec_1998</ID>
<Name>sales_fact_dec_1998</Name>
<State>Unprocessed</State>
<Source xsi:type=”QueryBinding”>
<DataSourceID>FoodMart 2008</DataSourceID >
<QueryDefinition>
SELECT
[dbo].[sales_fact_dec_1998].[product_id],
[dbo].[sales_fact_dec_1998].[time_id],
[dbo].[sales_fact_dec_1998].[customer_id],
[dbo].[sales_fact_dec_1998].[promotion_id],
[dbo].sales_fact_dec_1998].[store_id],
[dbo].[sales_fact_dec_1998].[store_sales],
[dbo].[sales_fact_dec_1998].[store_cost],
[dbo].[sales_fact_dec_1998].[unit_sales]
FROM [dbo].[sales_fact_dec_1998]
WHERE [dbo].[sales_fact_dec_1998].[time_id]=373</QueryDefinition>
</Source>
</Partition>

In this example, you can see that the partition is defined on top of a SQL query that pulls
data from the sales_fact_dec_1998 table. You can modify the WHERE condition to restrict
the data for your partition to a specific range of rows.

NOTE
During data processing, Analysis Services enables you to specify additional data bind-
ing information—out-of-line bindings. You can provide DataSource , DataSourceView ,or
Binding objects as part of the Process or Batch commands. (For more information
about the commands, see Chapter 26, “Server Architecture and Command Execution.”)
Out-of-line bindings override bindings specified as part of the metadata and apply only
while Analysis Services executes the command.