Relation Member Definition Meta-data
The Relation Member meta-data contains attributes for denormalizing specific members from a parent class into a child class. In order to link specific members within a relation, the Relation definition must already be created. In addition, because the Relation Member specifies the members of the classes that comprise the relation, these class members must also already be defined. The RelationName attribute creates the actual link to the encompassing relation; thus the relation name in the RelationName attribute must match the RelDefName attribute for the wanted relation.
The Member meta-data contains the required fields for defining a class member. The ParentMemName and ChildMemName attributes create the link to the corresponding class members; thus, these names must match the MemberDefName attribute for the required data members in the Member object for the class.
For information about creating a new relation-member for a class, see Creating a New Class Relation Member.
The following table shows the attributes used for the relation member definitions. A set of these attributes is stored in the RelMem table for each relation member defined.
Attribute | Data Type | Constraint | Requirement | Description |
RelMemDefID | int | NOT NULL | Leave blank | Stores the unique identifier for the relation member. |
CatalogID | int | NULL | Leave blank | Stores the identifier for the schema catalog. |
CatalogName | nvarchar (128) | NULL | Leave blank | Stores the name of the schema catalog, "DWSchema." |
ChildMemID | int | NULL | Leave blank | Stores the identifier for the data member of the child class to relate. |
ChildMemName | nvarchar (128) | NULL | Required | Stores the name of the data member of the child class to relate. |
CreatedTime | datetime | NULL | Leave blank | Records when the relation member was created. |
Description | nvarchar (128) | NULL | Optional | Stores the description for the relation member potentially displayed on the UI. |
DisplayName | nvarchar (128) | NULL | Optional | Stores the name potentially displayed on the UI for the relation member. |
MajorVersion | int | NULL | Optional | Stores the major version number for the relation member. |
MinorVersion | int | NULL | Optional | Stores the minor version number for the relation member. |
ModifiedTime | datetime | NULL | Leave blank | Records when the relation member was last modified. |
ParentMemID | int | NULL | Leave blank | Stores the identifier of the data member of the parent class to relate. |
ParentMemName | nvarchar (128) | NULL | Required | Stores the name of the data member of the parent class to relate. |
RelationID | int | NULL | Leave blank | Stores the identifier of the relation containing the relation member. |
RelationName | nvarchar (128) | NULL | Required | Stores the name of the class relation. |
Status | int | NULL | Leave blank | Reserved. |