Working with Lookup Dimensions

Lookup dimensions allow reference data sourced from an external system to be associated to data being managed in Oracle Enterprise Data Management Cloud. Nodes in lookup dimensions do not get included in the record count for the environment.

For example, suppose you had a list of cost center owners that you want to associate with an existing Cost Center dimension. You could create a lookup dimension for the cost center owners in Oracle Enterprise Data Management Cloud and use a node data type property to assign the owners to the cost centers in your Cost Center dimension. As a lookup dimension, you could maintain the list of owners in a structure (for example, by line of business or department), and the nodes in the lookup dimension would not count towards your total record count.

Considerations

• You must be a Service Administrator or have Owner or Metadata Manager permission on an application in order to create a lookup dimension. You can add lookup dimensions to any application type.
• Lookup dimensions use the Lookup node type class, which has a predefined set of properties that you cannot add to or remove from. You can reorder the properties, and you can set them are Required or not in the node type inspector. See Adding, Removing, and Configuring a Node Type's Properties. Nodes in a lookup dimension can use any of the predefined properties. See Predefined Properties for Lookup Node Types.
• You can add multiple bindings to a lookup dimension. The bindings can have a node or hierarchy type. See Creating a Lookup Binding.
• Lookup dimensions can be used in existing views, or you can create a view to use for the lookup dimension when you create the dimension.
• You cannot import, export, or extract data from lookup dimensions. You also cannot download a lookup dimension viewpoint to a file. You can load data into lookup dimension viewpoints by using request load files (see Making Changes Using a Load File) or viewpoint loads (see Working with Viewpoint Loads).
• Lookup dimensions are not displayed in the application registration wizard.
• When you create a lookup dimension in a Universal application that is in Draft status, the application status is changed to Active.

To create a lookup dimension:

1. Inspect the application that you want to create the lookup dimension in.
2. On the Dimensions tab, click Create.
3. From Type, select Lookup.
4. Enter a name and (optionally) a description for the dimension.

   Note:

   The dimension cannot have the same name as any other bound, unbound, or lookup dimensions in the application.
5. Optional: In View, enter a name to create a view to use for the lookup dimension viewpoints.

   Note:

   If you are not a Service Administrator, you must have the Views - Create role to create the view.
6. Click Save.

   The dimension is displayed in the dimension inspector.

After you have created a lookup dimension you can create lookup bindings for it, which create associated data chain objects if needed (see Creating a Lookup Binding), or you can create the data chain objects manually (as in an unbound dimension). Then, you can use the lookup dimension, modify data with requests, create extracts for the dimension, and add permissions, policies, and custom validations.

Note:

You cannot add or remove properties from the dimension, and you cannot use it for importing and exporting data