Enable/Disable Writeback Dialog Box (SSAS)

The Enable/Disable Writeback dialog box enables or disables writeback for a measure group in a cube. Enabling writeback on a measure group defines a writeback partition and creates a writeback table for that measure group. Disabling writeback on a measure group removes the writeback partition but does not delete the writeback table, to avoid unanticipated data loss. The Enable/Disable Writeback dialog box is displayed by:

  • Clicking Writeback Settings in the Measure Groups pane on the Partitions tab in Cube Designer.
  • Right-clicking a partition in the Partitions grid in the Measure Groups pane on the Partitions tab in Cube Designer and selecting Writeback Settings from the context menu.

Options

  • Table name
    Type the name of the writeback table to create for the selected partition. The writeback table stores the changes made to the measure group from a client application.

    Note

    This option is disabled if writeback is not enabled.

  • Data source
    Select the data source to contain the writeback table.

    Note

    This option is disabled if writeback is not enabled.

  • New
    Click to display the Connection Manager dialog box and define a new data source to contain the writeback table. For more information about the Connection Manager dialog box, see Connection Manager Dialog Box (SSAS).

    Note

    This option is disabled if writeback is not enabled.

See Also

Reference

Partitions (Cube Designer) (SSAS)
Analysis Services Designers and Dialog Boxes (SSAS)

Help and Information

Getting SQL Server 2005 Assistance