Editing Lookup Table Joins

To edit table joins:

  1. From Oracle Hyperion Enterprise Performance Management Workspace, select Navigate, then Applications, then Profitability, and then select the application that you want to view.
  2. From Task Areas, select Manage Model, and then Model Data Registration.
  3. Select the Table Joins tab.
  4. From Stage Table, select the stage table to which you want to join the lookup table.

    A list of tables that are currently joined to the stage table are displayed.

  5. Click Edit a Table Join Edit Table Join icon.
  6. On the Select Lookup Table wizard, review the selected lookup table, and then click Next.
  7. Optional: On the Join Lookup Table to Stage Table wizard, under Join Details, modify the selections for the Stage Table and Columns or the associated Lookup Table and Columns, as required.
  8. Click Finish.