Technical data

Creating Hierarchies Chapter 9

See Chapter 6, “Creating Dimensions,” Defini ng Dimension Properties, page 48.

You can use the A

nalytic Model Viewer to view the properties of the trees that you are using with your

analytic mode

See C

hapter 14, “Viewing and Debugging Analytic Models,” Viewing Dimension Properties, page 239.

PeopleCode Us

age with PeopleSoft Trees and A nalytic Models

Use the AttachTree and DetachTree methods to work with PeopleSoft trees and analytic models.

AttachTree Method

Use the Attach

Tree method to:

• Attach a tree to its corresponding dimension.

PeopleSoft Analytic Calculation Engine attaches the tree to the dimension, and then creates and displays the

hierarchy.

• Make changes to the tree.

• Creat e a record that use s PSACETREEOVRD as a subrecord, then attach the new record to the dimension

members to associate the member override function to the hierarchy.

Be aware of these restrictions:

• Because the At

tachTree method attaches a specific tree to an analytic model, the system throws an e rror if

the tree’s nam

e, setID, or effective date is incorrect.

• You can attac

h only one tree to a dimension.

• If the analyti

c model is already loaded into an analytic server, the tree is not attached until the next time that

the analytic

model is reloaded.

DetachTree Method

Use the DetachTree method to detach the tree from the dimension.

Note. If the application loads the analytic model after the tree is detached, the analytic model does not create a

hierarchy for the dimension.

Note. If the analytic model is already loaded into an analytic server, the DetachTree method is not applied to

the tree until the next time the application loads the analytic model.

Updating a Tree at Runtime

To update a tree at runtime, perform these steps:

1. Unload the analytic model.

See Enterprise PeopleTools 8.49 PeopleBook: PeopleCode API Reference, “Analytic Calculation

Engine Classes,” Unload.

2. Use the DetachTree method to detach the tree from the analytic model.

3. Use the AttachTree method’s parameters to update the tree with the changes.