Add a New Period to the Period Dimensions Table

  1. Use SAS Table Editor, or SAS Enterprise Guide, or another editor to add the period to the dimension table.

    Note: After modifying the table, you must use SAS Management Console to re-import it into your input directory. Importing does not copy the file itself — it updates the metadata maintained by the SAS Management Console.


  2. Activate the Transactions workspace.
  3. Select the model that contains the period dimension table.
  4. Select Actions Refresh to add the period to the list.


  5. Click Change analysis settings and verify that the new period is listed in the Analysis Settings window.

    Note: The periods listed under analysis settings are the periods that are to be included in a cube. Any period that is selected for inclusion in a cube must have been selected at some point when you calculate the model (see step 8 below).


  6. Add rows for the new period to the behavior table.


  7. Add transaction tables to all of the table groups.

    When you add a transaction table to a transaction table group, you must assign a period to the transaction table.

    Note: Each transaction table in a model can have only one period. And, each period in a model can have only one transaction table. (If you encounter the error Several transaction tables are assigned to the same period, it is because a transaction table exists in the table group that is assigned to that period.)
  8. Calculate the model.

    Only new periods need to be calculated.
  9. Calculate the summary cubes.

    Clicking Generate cube will process all periods because the cubes are made across multiple periods.