Purpose of Node Levels in Creating Hierarchies

Use node levels to create leaf, detail, and aggregate members out of tree nodes and leaves. Use the parameters of the AttachTree method to set the node levels.

Details Start Level

The details start level determines the type of dimension members that Analytic Calculation Engine creates out of the nodes and leaves of a tree. Use either the parameters of the AttachTree method or the Analytic Instance Load/Unload page to set the details start level. The details start level is a required parameter. The default value is 0. The root level is 1.

See Loading and Unloading Analytic Instances.

Note:

If you specify a nonzero details start level, you must specify the strictly enforced method to the tree in PeopleSoft Tree Manager. The strictly enforced method ensures that all members that are created out of one level are created as the same member type.

See Tree Manager: Defining Basic Attributes.

The following table describes the members that Analytic Calculation Engine creates, depending on whether the details start level is specified.

Details Start Level Specified?	Leaf Members	Detail Members	Aggregate Members
Value > 0	Analytic Calculation Engine creates leaf members out of any detail values that are at the far right of the tree.	Analytic Calculation Engine creates detail members out of any detail values or nodes that are located either within the specified details start level, or within a level that is lower (higher number) than the details start level. If you specify the root level as the details start level, Analytic Calculation Engine creates detail members out of all nodes in the tree. Note: Analytic Calculation Engine cannot create detail members out of detail values that are at a higher level than the details start level. Do not specify a details start level that is equal to lower than the tree discard level.	Analytic Calculation Engine creates aggregate members out of any aggregate nodes that are located within a level that is higher than the details start level. Note: Analytic Calculation Engine cannot create aggregate members out of nodes that are at a lower level than the details start level.
Value = 0 Note: When the value = 0, the details start level is not specified.	Analytic Calculation Engine creates leaf members out of the detail values that are located at the far right of the tree.	Analytic Calculation Engine creates detail members out of all leaf members.	Analytic Calculation Engine creates aggregate members out of any nodes from which it has not created leaf members.

Details Start Level Specified?

Leaf Members

Detail Members

Aggregate Members

Value > 0

Analytic Calculation Engine creates leaf members out of any detail values that are at the far right of the tree.

Analytic Calculation Engine creates detail members out of any detail values or nodes that are located either within the specified details start level, or within a level that is lower (higher number) than the details start level.

If you specify the root level as the details start level, Analytic Calculation Engine creates detail members out of all nodes in the tree.

Note: Analytic Calculation Engine cannot create detail members out of detail values that are at a higher level than the details start level. Do not specify a details start level that is equal to lower than the tree discard level.

Analytic Calculation Engine creates aggregate members out of any aggregate nodes that are located within a level that is higher than the details start level.

Note: Analytic Calculation Engine cannot create aggregate members out of nodes that are at a lower level than the details start level.

Value = 0

Note: When the value = 0, the details start level is not specified.

Analytic Calculation Engine creates leaf members out of the detail values that are located at the far right of the tree.

Analytic Calculation Engine creates detail members out of all leaf members.

Analytic Calculation Engine creates aggregate members out of any nodes from which it has not created leaf members.

Tree Discard Level

The tree discard level determines the level from which Analytic Calculation Engine does not attach any more of the tree to the dimension. Use either the parameters of the AttachTree method or the Analytic Instance Load/Unload page to set the tree discard level.

See Loading and Unloading Analytic Instances.

Analytic Calculation Engine does not create members out of nodes or leaves that are either at this level or lower than this level. You must specify a details start level to every tree for which you want to specify a tree discard level. The default value is 0. If the tree discard level is anything other than Level 0, then the tree discard level must be at a lower level than the details start level.

The analytic calculation engine ignores the tree discard level if:

The details start level is 0.
The tree discard level is either equal to or higher than the details start level.