Using Parent-Child References
When performing Essbase dimension builds, use a parent-child build method when every record of the source of data indicates a hierarchical relationship including the name of a new member and the name of its parent.
Members in a database exist in a parent-child relationship. The image below shows part of the Product dimension with its parent and children relationships identified. Product is the parent of 100. 100 is the child of Product and the parent of 100-10, 100-10-12, and 100-10-16. 100-10, 100-10-12, and 100-10-16 are the children of 100.
Figure 15-5 Parents and Children
![This image illustrates parent and children relationships, as described in the text preceding the image. This image illustrates parent and children relationships, as described in the text preceding the image.](img/v71esb_aspc.jpg)
A parent-child source of data must contain at least two columns: a parent column and a child column, in that order. The source of data can include columns with other information (for example, the alias, the attributes, or the properties of the new member). A record within a parent-child source of data cannot specify multiple parents or multiple children, and cannot reverse the order of the parent and child columns.
In a parent-child build, the rules file specifies which column is the parent and which column is the child. For example, consider the source file (Dim_Product.txt
), in which each record specifies the name of a parent and the name of its child, in that order.
![Data file for a parent-child build Data file for a parent-child build](img/dat_parchild.png)
The rules file (Dim_Product.rul
) specifies which column is the parent and which column is the child. Additionally, this example associates aliases with the child field. Null fields, reserved for properties, are ignored.
![Rules file for a parent-child build Rules file for a parent-child build](img/rule_parchild.png)
Essbase builds the following hierarchy from this source data and rules file.
![Hierarchy showing member Product with child member 200. Beneath member 200 are child members 200-10, 200-20, etc. Hierarchy showing member Product with child member 200. Beneath member 200 are child members 200-10, 200-20, etc.](img/otl_prod_parchild.png)
Note:
For duplicate member situations, the parent field must contain the qualified member name. See Building Qualified Member Names Through the Rule File.