Inserting a Column in the Plan Table

To insert a column:

  1. Open the plan scenario in which you want to insert the column.

  2. Do one of the following:

    • In the plan table toolbar, click Show menu.
    • Right-click the header of an existing column.
  3. Click Insert Column. The Insert Column window displays. The window contains a field for each of the column-level dimensions defined for the plan. If the plan is configured to display measures as columns, the Measure field is also displayed.

  4. Specify a dimension value for the first dimension. Under the name of the dimension, do one of the following:

    • If the dimension value already exists in the plan, search for and select the dimension value.

    • If the dimension value does not exist in the plan, do the following:

      1. Enter the dimension value.
      2. Select the new value from the drop-down list.
  5. Repeat the previous step to specify values for the remaining dimensions.
  6. If the plan is configured to display measures as columns, search for and select a measure.
  7. Click Insert. The column is now inserted in the rightmost position within the relevant column group. If a new column group is created because the top-level dimension value did not previously exist, the column is inserted in the rightmost position of the table.
Warning:

You must populate at least one cell in the new column before saving the plan table. When you save the table, any columns that only contain empty cells are automatically removed.