Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

111

112

113

114

115

116

117

118

119

120

Creating Hierarchies Chapter 9

Parent Child

Member Override User

Function

100 120

<none>

110 111

(leaf)

110 112

(leaf)

120 121

(leaf)

The following table describes the hierarchy of the TRANS_DATE dimension that is associated with the

QrtrlyTree tree. The first column lists the parents in the hierarchy. The second column lists the children of the

parents. The third column lists the m ember override user functions that are pe rformed on each child.

Note. Overrides are not performed on cells denoted (leaf) or <none>.

Parent Child

Member Override User

Function

Q1 Q1

<none>

Jan

(leaf)

Feb (leaf)

Mar

(leaf)

The following table describes the hierarchy of the DEPT dimension that is created from the DeptTree tree. The

first column lists the parents in the hierarchy. The second column lists the children of the parents. The third

column lists the member override user functions that are performed on each child.

Note. Overrides are not performed on cells denoted (leaf) or <none>.

Note. This example uses the <RED_HERRING> child node override as incorrect data. Leaf nodes do not

have aggregations.

Parent Child

Member Override User

Function

GBL GBL <SOME_DEPT_AVG>

GBL USA

<none>

GBL

EUR

<none>

USA CA

(leaf)

USA GA

(leaf)

USA

(leaf)