Table Binding Detail (Partition Source Dialog Box) (SSAS)

Use the Table Binding option in the Partition Source dialog box to specify the fact table that provides the data for the partition. You can display this pane by selecting Table Binding from the Binding type option in the Partition Source dialog box.

Options

  • Measure group
    Displays the measure group for this partition.
  • Look in
    Select the data source or data source view that contains the source tables for this partition. The data source view used by the selected measure group is selected by default.
  • Filter tables
    Type the string used to restrict, by table name, the tables displayed in Available tables.
  • Find tables
    Select to refresh the list of tables in Available tables, further restricting the list if a string was specified in Filter tables.
  • Available tables
    Click to select the table to use as a source table for the partition.

    If no filter is specified in Filter tables, all tables in the data source or data source view specified in Look in that are similar in structure to the fact table used by the measure group specified in Measure group are listed.

    If a filter is specified in Filter tables, the list is further restricted by comparing the filter against the table names that meet the above criteria. Only those tables that contain the string specified in Filter tables are displayed.

See Also

Reference

Partition Source Dialog Box (SSAS)

Help and Information

Getting SQL Server 2005 Assistance