About Configuring PeopleSoft Tree Extract
Oracle BI Applications uses the trees defined in PeopleSoft Tree Manager as the sources for dimension hierarchies for the listed dimensions.
-
Department Hierarchy
-
Company (Business Unit) Hierarchy
-
Product Category Hierarchy
-
HR Position Hierarchy
You configure these PeopleSoft Tree Extract processes by specifying the data load parameters for these dimension hierarchies. For each dimension hierarchy, the list shows the related data load parameters and how they are used:
-
Tree Structure ID — PeopleSoft Trees are defined under a given tree structure. The tree structure determines the tables used to store the tree nodes and tree details. It also determines if a tree is defined as a winter tree or a summer tree. Typically each dimension hierarchy in Oracle BI Applications is based on one tree structure. However, in some cases, you might want to extract the trees from multiple tree structures. The only constraint is that you need to ensure that these tree structures are using the same table for the details.
-
Tree and the SETID — PeopleSoft applications store trees for different SETID. The combination of the tree name and the SETID can uniquely identify a hierarchy. Oracle BI Applications can support multiple hierarchies for a given dimension. By default, the Tree Extract process extracts all trees created against the given tree structure. You can also specify a list of combinations of tree and SETID to limit the number of trees to be extracted.