Modifying Column Mappings

To modify column mappings:

  1. From Oracle Hyperion Enterprise Performance Management Workspace, select Navigate, then Applications, then Profitability, and then select an application.
  2. From Task Areas, select Manage Model, and then Model Data Registration.
  3. Select the Column Mapping tab.
  4. In Select Table, select the stage table for which you want to modify the column mapping.
  5. Select a column, and then click Edit Column Mapping Edit Column Mapping icon..
  6. In the Rename Special Columns dialog box, under Column Name, modify the column names for each dimension to be changed, and then click Next. If the application does not contain unmanaged dimensions, this screen will be blank.
  7. In the Map and Rename Dimension Columns dialog box, under Column Name, modify each column name that you want to change, and the click Next.

    Under Dimension/POV you can modify the selected dimension, if required.

  8. In the Map and Rename Measure Columns dialog box, under Measure, select the actual member to be used for each column, and then click Finish.

    All column modifications are applied.