Udostępnij za pośrednictwem


Object Binding Dialog Box (SSAS)

Use the Object Binding dialog box in Business Intelligence Development Studio to define bindings between the property of an Analysis Services object and a table or column in a data source view. You can display the Object Binding dialog box by selecting (new) from the drop-down list for the value of the following properties of an Analysis Services object in the Properties window of Business Intelligence Development Studio:

  • NameColumn
  • ValueColumn
  • CustomRollupColumn
  • CustomRollupPropertiesColumn
  • UnaryOperatorColumn

Options

  • Binding type
    Select the binding to use for the Analysis Services object. The following types of binding can be used:

    • Column binding
      Binds the object to an existing table and column within a data source view.
    • Generate column
      Indicates that a new column is to be defined in the data source view, and a column binding is then associated with it.

      Note

      If this option is selected, you must run the Schema Generation Wizard before deploying the Analysis Services object.

    • Row binding
      Binds the object to a row in a fact table and is used to facilitate count measures based on the number of rows processed in the fact table.
  • Source table
    Displays a list of tables in the data source view associated with the Analysis Services object.
  • Source column
    Displays a list of columns in the table selected in Source table.

See Also

Reference

Analysis Services Designers and Dialog Boxes (SSAS)

Help and Information

Getting SQL Server 2005 Assistance