Purpose of PeopleSoft Trees and Analytic Model Hierarchies
Analytic Calculation Engine uses trees to establish hierarchies of a dimension's parent-child relationships. 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.
Before loading the analytic model into the analytic server, the application uses the AttachTree method to attach the tree to its corresponding dimension. Next, the analytic model creates its own hierarchy by reading the parent-child relationships that are defined by that tree. During the remainder of the user session, the analytic model uses its own hierarchy, and no longer uses the original tree. For this reason, when the application adds a new dimension member during runtime, the member is actually added to the analytic model's hierarchy; the original tree is not modified.
Note:
If a tree is not attached to a dimension, you can create a basic hierarchy for that dimension by specifying a total member name for the dimension.
See Defining Dimension Properties.
You can use the Analytic Model Viewer to view the properties of the trees that you are using with your analytic model.