Restrict Rows (Partition Wizard)
Use the Restrict Rows page to restrict the rows that will be retrieved from the specified table and will be aggregated and included in the partition.
Note
This page is appears only if you selected a single table in the Specify Source Information page.
Warning
If you specified a table in Available Tables on the Specify Source Information page that is used by another partition, you must provide a query in the Restrict Rows page or risk duplicating data in the cube. For more information, see Defining and Configuring a Partition.
Options
Specify a query to restrict rows
Select to enter a query that restricts rows into the Query box.If Supply a WHERE clause is empty when this option is selected, that option is populated with an SQL statement that retrieves all columns and all rows from the previously selected table.
Query
Type or modify the SQL statement used when retrieving rows from the table when the partition is processed.Important
By specifying a WHERE clause, a subset of records can be used for this partition. This is essential to prevent duplication of data when multiple partitions are based on a single fact table. For more information, see Defining and Configuring a Partition.
- Check
Verifies that the statement in Query is a valid SQL statement.
See Also
Reference
Partition Wizard F1 Help (SSAS)
Other Resources
Partitions (Analysis Services)
Defining and Configuring a Partition