Add a Transaction Table Group to a Model

To add a transaction table group, do the following:

  1. Activate the Transactions workspace, and select a model.
  2. Click the Add Table Group icon. The Add Table Group window opens.
  3. Name the table group, and click Next.
  4. Select the transaction table whose layout defines the layout (the required fields) for this group.
  5. Click Next.
  6. Associate each source column (in the transaction table) with its corresponding dimension table.

    Note: The following names are reserved for use by Profitability Management as the names of columns created as a result of calculation:

    Behavior
    Quantity
    Value
    Period
  7. Click Finish.
  8. The transaction table group is added to the model.