1. User's Guide
  2. Working with Detailed Profitability
  3. Managing Detailed Profitability Models
  4. Registering Detailed Profitability Model Data
  5. Joining Lookup Tables
  6. Joining Tables to a Lookup Table

Joining Tables to a Lookup Table

To join tables to a lookup table:

  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.


    On the Table Joins tab, select a Stage Table, and view the Joined Lookup tables.
  5. Click Create a Table Join Create a Table Join icon.

    From the Lookup Table drop-down list, select a lookup to join to the selected Stage Table.
  6. On the Select Lookup Table wizard, under Available Lookup Tables, from the Lookup Table drop-down list, select the lookup table that you want to join to the selected stage table, and then click Next.

    From the Stage Table and Columns, select a stage table, and then select a lookup table under Lookup Table and Columns.
  7. On the Join Lookup Table to Stage Table wizard, under Join Details, click Add a new condition Add new condition iconto add another table join to the stage table.
  8. From the Stage Table and Columns, select a stage table column, and then select a lookup table column under Lookup Table and Columns.
  9. Optional: Under Join Details, select some join condition and click Remove the condition Remove the condition iconto remove the selected condition.
  10. Click Finish.