Adding scenarios

To add a scenario:

  1. On the Analysis Services computer, start SQL Server Management Studio.
  2. Go to the Tables folder under the appropriate database folder.
  3. Select the Scenario table and edit the rows.
  4. Click in the last empty row.
  5. In the MEM_ID column, specify the next largest integer. For example, the first row will have a MEM_ID of 0 and the second row is 1. If you are adding the next row, specify 2.
  6. In the MEM_NAME column, specify the scenario name and in the MEM_DESC column, specify a description.
  7. Do not specify a value in the MEM_USAGE column.
  8. In the MEM_ORDER column, you can change the numbers of any of the rows. This affects the order in which members are displayed.
  9. Do not specify values in the CALC and MEM_OPTIONS columns.
  10. In Analysis Services Analysis Manager or SQL Server Management Studio, process the database.
  11. Exit the application.

You can delete scenarios by deleting the rows but there must be at least one scenario in a plan.