Adding Lookup Dimensions

Lookup dimensions can be created and assigned with data columns for target applications, and are used for mapping and reference.

Lookup dimensions can only be used in Oracle Hyperion Financial Data Quality Management, Enterprise Edition and do not affect the dimensionality of a target application. They can also be used with member mapping functionality to cross-reference multiple source segments and chartfields and assign a target value.

To add a lookup dimension:

1. On the Setup tab, under Register, select Target Application.
2. In the Target Application summary grid, select a target application.
3. Select the Dimension Details tab.
4. Click Add.

   Blank dimension name and data table column name entry fields are displayed.

5. In Dimension Name, enter the lookup dimension name.
6. In Data Table Column Name, select the data column from which to base the lookup dimension.

   Note:

   The data table column name value must be a user-defined dimension greater than the selected target dimension. For example, if the application has four custom dimensions, select UD5.
7. Click OK.

   The lookup dimension is added to the dimension detail list with the target dimension class name of "LOOKUP." To use the lookup dimension as a source dimension, make sure you map it in the import format.