Share via


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

Help and Information

Getting SQL Server 2005 Assistance