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.

   
   
   
5. Click Create a Table Join .
   
   
   
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.
   
   
   
7. On the Join Lookup Table to Stage Table wizard, under Join Details, click Add a new condition to 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 to remove the selected condition.
10. Click Finish.