Partition Source Dialog Box (Analysis Services - Multidimensional Data)

Use the Partition Source dialog box in SQL Server Data Tools (SSDT) to specify the source of fact table data for a partition. You can display the Partition Source dialog box by:

• Clicking the ... button on a cell from the Partitions grid of a selected measure group in the Measure Groups pane on the Partitions tab in Cube Designer.

• Clicking the ... button on the Source property value of a Partition object in the Properties window in SQL Server Data Tools (SSDT).

Options

Option	Definition
Binding type	Select the binding type to use for the source of the specified partition. The following options are available: Option Definition Table binding Select to display the Table Binding Detail pane and indicate that the partition is bound to the contents of a table in a data source or data source view. For more information about the Table Binding Detail pane, see Table Binding Detail (Partition Source Dialog Box) (Analysis Services - Multidimensional Data). Detail Select to display the Query Binding Detail pane and indicate that the partition is bound to the contents of a query executed on a data source. For more information about the Query Binding Detail pane, see Query Binding Detail (Partition Source Dialog Box) (Analysis Services - Multidimensional Data).
Detail	Displays either the Table Binding Detail dialog box or the Query Binding Detail dialog box, depending on the value of the Binding type option.

See Also

Reference

Partitions (Cube Designer) (Analysis Services - Multidimensional Data)

Analysis Services Designers and Dialog Boxes (Multidimensional Data)