3.2.3 Using Catalog Lookup with a Fact Entity

Used to retrieve information from fact tables.

Example:

• Transaction Facts
• Balance Facts

1. Create a Catalog Lookup Object pane, select the required Fact entity (for example, Fact Entity Allocation).
2. Define the key field (for example, Allocation Fact and select the lookup field to retrieve (for example, Fact).
3. In the Connector Source configuration, add the Source EDD and the Catalog Lookup Object.
4. Add a Aggregation condition between the source field and the lookup key field (for example, Entity Allocation Factor = Allocation Fact (ADI).
5. In Mapping, map the retrieved lookup value to the required target field.

   Note:

   If the source data type and target data type selected do not match, a warning sign is displayed.
6. Click Auto-Map to match the source and target data types.