Planning Dimension Node Hierarchy DMO

Defines the parent-child relationships between dimension nodes in the dimension hierarchy.

Object API Name: std__PlanningDimensionNodeHierarchyDmo__dlm
Category: Unassigned
Availability: Available in 262 and later versions
Primary Key Field: Id

• ParentNodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• ChildNodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.

• cdp_sys_record_currency
• ChildNodeId
• DataSourceId
• DataSourceObjectId
• EndDate
• Id
• InternalOrganizationId
• ParentNodeId
• StartDate
• StructureType
• UsageType

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__ChildNodeId__c
• Data Type: TEXT
• Description: A unique ID of the child dimension node in the current hierarchy.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__EndDate__c
• Data Type: DATEONLY
• Description: The date on which the parent–child relationship is no longer active or valid.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: A unique identifier for a parent–child relationship (edge) in a dimension hierarchy. It is a composite primary key combining the ParentNodeID and ChildNodeID columns.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__ParentNodeId__c
• Data Type: TEXT
• Description: A unique ID of the parent dimension node in the current hierarchy.

• Field API Name: std__StartDate__c
• Data Type: DATEONLY
• Description: The date when the parent–child relationship becomes active within the dimension hierarchy.

• Field API Name: std__StructureType__c
• Data Type: TEXT
• Description: Defines the hierarchy structure for a dimension, enabling multiple hierarchies for the same dimension.

• Field API Name: std__UsageType__c
• Data Type: TEXT
• Description: Specifies the business process that uses the associated hierarchy. For example, Account Planning.