• Article

Enable/Disable Writeback Dialog Box (Analysis Services - Multidimensional Data)

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 (Analysis Services - Multidimensional Data).

    Note

    This option is disabled if writeback is not enabled.