MDM Hierarchy Configuration Tutorial

Back Next

Step 3. Create the Product Relationship Object

The Product relationship object maintains the hierarchy relationships associated with the Product entity object. To create the Product relationship object, you can either convert an existing base object, or create the Product relationship object. In this tutorial, we will create the Product relationship object.

In the Model workbench, click

Hierarchies

Select

Hierarchies

Create New Entity/Relationship Object

Select

Create New Relationship Base Object

. Click

Enter the following parameters for the relationship object:

Parameter	Parameter Value
Display name	Product Rel
Physical name	C_PRODUCT_REL
Data Tablespace	CMX_DATA
Index Tablespace	CMX_INDX
Description	Optional.
Secure Resource	Enabled
Entity Base Object 1	Product
Display Name	Product ID1
Physical Name	PRODUCT_ID1
Entity Base Object 2	Product
Display Name	Product ID2
Physical Name	PRODUCT_ID2
Hierarchy FK Column	Row ID Object
Hierarchy FK Display Name	Row ID Hierarchy
Hierarchy FK Physical Name	ROWID_HIERARCHY
Rel Type FK Column	Row ID Object
Rel Type FK Display Name	Row ID Rel Type
Rel Type FK Physical Name	ROWID_REL_TYPE

Rename Saved Search

Table of Contents

MDM Hierarchy Configuration Tutorial

MDM Hierarchy Configuration Tutorial

Step 3. Create the Product Relationship Object

Step 3. Create the Product Relationship Object