Using Trees

PeopleSoft Analytic Calculation Engine uses trees to establish hierarchies of a dimension's parent-child relationships. PeopleSoft Analytic Calculation Engine uses these hierarchies to:

• Calculate and display aggregated data to end users.

• Enable end users to navigate through data by performing such actions as expanding and collapsing nodes.

• Enable end users to drill down and drill up through data.

It is important to understand that PeopleSoft trees and hierarchies differ in the following manner: You create one tree for each dimension that requires a hierarchy. The analytic model uses that tree to create one hierarchy for one dimension.

Use the AttachTree method to attach a tree to a dimension, and use the DetachTree method to detach the tree from the dimension.

You should be aware of the following restrictions:

• Because the AttachTree method attaches a specific tree to an analytic instance, the system throws an error if the tree's name, setID or effective date is incorrect.

• You can attach only one tree to one dimension at a time.

• If the analytic instance is already loaded into the analytic server, the tree isn't attached until the analytic model is loaded.

• No aggregate data is displayed to the user after you use the DetachTree method.

• If your application loads the analytic model after the tree has been detached, the analytic model doesn't create a hierarchy for the dimension.

• If the analytic instance is already loaded into the analytic server, the DetachTree method isn't applied to the tree until the next time your application loads the analytic instance.

You can only attach a tree to an analytic model before the analytic instance

No aggregate data displayed to user after detach tree.