Database Reference
In-Depth Information
After creating and testing the query, we can change the Partition Source to Create Binding and add the SQL
statement to the query textbox, as shown in Figure
12-10
.
Figure 12-10.
Using query binding to filter a partition source
Now the partition will only hold data that is associated with the year 1994. No other data in that fact table will
be included in the cube with this current configuration. For data to be included for years other than 1994, you will
have to create another partition.
The Partition Wizard
To create another partition, click the New Partition hyperlink, as shown in Figure
12-11
. This launches the
Partition Wizard.
As you navigate through the Partition Wizard, the third screen allows you to restrict the rows by entering a
SQL query. The SQL statement you will use will be quite similar to the one shown in Listing 12-2, but this time we
include the argument
Where Not DimDates.Year
=
1994
, as shown in Figure
12-11
.
