Tree Manager

Trees depict hierarchical structures that represent a group of summarization rules for a particular database field.  For example, a tree can specify how your manufacturing locations should be summarized, or rolled up, for reporting purposes.

                                                                                   Alternatively a tree can show the reporting relationships within an organization by specifying how the individual department should be summarized into territories, territories into regions, and regions into countries. Similarly, a tree can categorize items in a catalog as:

• The summarization rules depicted in a tree apply to the detail values of a particular field: vendors, departments, customers, or other values that you define.

• These detail values are summarized into nodes on the tree. The nodes may also be organized into levels to logically group nodes that represent the same type of information or level of summarization.

For example, the values of the DEPTID field identify individual departments in your

organization. Tree Manager defines the organizational hierarchy that specifies how each department relates to the others—


Departments 10700 and 10800 report to the same manager, department 20200 is part of a different division, and so on. In other words, you build a tree that mirrors the existing organizational hierarchy.

Nodes

• Nodes define the hierarchical relationship within the tree. Nodes can be either categories or items that need to be placed in a relationship with other items, such as an item in a catalog.

• Each detail value reports to a tree node at the next higher level of the organization. Each tree node represents the group of detail values that “report” to it. Referring to the node is a shorthand way of referring to the group of detail values under it.

• For Eg:-  if a report refers to the Office of the President, it includes data from all the detail values under the Office of the President node—including the detail values under the Human Resources department, since Human Resources reports to the Office of the President.

• In turn, each tree node reports to another tree node at a higher level of organization, until we reach the top level of the hierarchy, called the root node.