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.

[!UWAGA]

This page is appears only if you selected a single table in the Specify Source Information page.

Przestroga
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 Multidimensional Model Partition Management.

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.

  Ważne:
  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 Multidimensional Model Partition Management.

• Check
  Verifies that the statement in Query is a valid SQL statement.

Zobacz także

Odwołanie

Partition Wizard F1 Help (Analysis Services - Multidimensional Data)

Koncepcje

Partitions (SSAS)

Inne zasoby

Multidimensional Model Partition Management