Defining Collision Mappings (Optional)

When you validate your source to warehouse set control mappings, you can choose to allow two tablesets merge in the warehouse. However, if two tablesets merge it is possible for collisions to occur between business keys (such as supplier ID). If such collisions do occur, you must create a collision map to resolve the collision.

Pages Used to Define Collision Maps

Page Name	Definition Name	Navigation	Usage
Collision Map Definition	PF_COLLISION_MAP	select EPM Foundation, then select EPM Setup, then select ETL Map Parameters, then select Collision Map Definition	Define collision maps to resolve business ID collisions.
Collision Map Error Report	PF_COLLISION_RPT	select EPM Foundation, then select EPM Setup, then select ETL Map Parameters, then select Collision Map Error Reports, then select Collision Map Error Report	Displays the results of the error out duplicates collision map.

Collision Map Definition Page

Use the Collision Map Definition page (PF_COLLISION_MAP) to define collision maps to resolve business ID collisions.

Navigation

select EPM Foundation, then select EPM Setup, then select ETL Map Parameters, then select Collision Map Definition

Image: Collision Map Definition page

This example illustrates the fields and controls on the Collision Map Definition page. You can find definitions for the fields and controls later on this page.

Map Type

Select a collision map type to resolve any business ID conflict resulting from merging tablesets.

You can select:

First In Wins: The first instance of a business ID is loaded into a tableset and subsequent instances of the same ID from different tablesets are ignored.

Error Out Duplicates: The first instance of a business ID is loaded into a tableset, but subsequent instances of the same ID from different tablesets are sent to an error table where they can be inspected and remapped. You can examine these errors by accessing the Collision Map Error Reports page.

If you select this option, the Warehouse Record and Dimension ID fields appear for editing.

Use Mapping Table: Each incoming business ID is checked against a mapping table. If an entry does not exist in the mapping table, the row errors out.

Dimension Name

Select the target dimension that contains the merging tablesets.

The list is drawn from the set of dimensions defined in the Define Dimension page.

Mapping Table

Select a mapping table that stores resolved conflicts to verify future incoming business IDs.

You can use the default mapping table (PF_DIMN_MAP) or create your own mapping table in Application Designer.

Warehouse Record

Select the OWE or MDW table that associates with the dimension selected for the Dimension Name field.

This table is used for prompting in the Error-Out Duplicates map type.

Dimension ID Field

Select the ID column for the table you specified in the Warehouse Record field.

Description Fieldname

Select the column that stores the description for the table you specified in the Warehouse Record field.

Collision Map Error Report Page

Use the Collision Map Error Report page (PF_COLLISION_RPT) to displays the results of the error out duplicates collision map.

Navigation

select EPM Foundation, then select EPM Setup, then select ETL Map Parameters, then select Collision Map Error Reports, then select Collision Map Error Report

This page displays the results of the error out duplicates collision map, where the first instance of a business ID is loaded into the relevant tableset and the subsequent instances of the same ID from different tablesets are sent to this page for review. For each row of data you can chose to:

Accept: The mapping between the colliding business IDs is preserved as displayed.
Create: You can create a new business ID that can be loaded into the applicable tableset.
Defer: You can defer action to a later time.
Select: You can select an existing member of the tableset as a mapping for this incoming business ID.

If you select Create or Select, the Target Business ID field becomes available for editing and you can create or select another business ID to load into the applicable tableset.