Contents
With the lookup field, users can associate multiple “child” records of that entity to a single “parent” entity record. Beyond simply defining how records can be related to other records, 1:N entity relationships also provide data to address the following questions:
What are data members in parent child dimensions?
Referred to as data members, these special child members contain a value that is directly associated with a nonleaf member and is independent of the summary value calculated from the descendants of the nonleaf member. For more information about data members, see Attributes in Parent-Child Hierarchies.
Can a dimension not have a parent-child relationship?
Dimensions that do not have a parent-child relationship construct hierarchies by grouping and ordering attributes. These dimensions derive the level names for their hierarchies from the attribute names.
How are the dimensions of a parent child hierarchy determined?
Because of parent-child relationships between levels in a parent-child hierarchy, some nonleaf members can also have data derived from underlying data sources, in addition to data aggregated from child members. The dimension schema of a parent-child hierarchy depends on a self-referencing relationship present on the dimension main table.
Can a child of a master detail relationship be a parent?
A child of one master detail relationship cannot be the parent of another. Lookup field on page layout is required. other difference is, you can’t create a rollup summary field on Lookup Relationship. it is only available on Master-Detail relationship. 😀 that’s a good point.
What happens when a parent record is deleted?
When the parent record is deleted all the child records attached needs to be deleted. All the users who can access a specific parent record will also has access to all the related child records (parent has private OWD setting and has sharing rules on top of it) ..
Can a detail be created on a master record?
In which Master represents Parent and detail represents Child. If Parent is deleted then Child also gets deleted. Rollup summary fields can only be created on Master records which will calculate the SUM, AVG, MIN of the Child records.