About HierarchiesSome data objects, such as account, book, opportunity, and territory, support a hierarchical (tree) structure. For example, the territory hierarchy appears in multiple subject areas and is usually used to store sales territory information. Oracle CRM On Demand supports nine levels of hierarchy, including the top level. For example, a territory hierarchy implemented for a company in the United States might have this kind of structure:
The previous hierarchy is more compressed, as shown in the following table. The maximum number of hierarchy levels that is supported is nine. So, if a hierarchy has fewer than nine levels, then the lowest-level values are repeated for those levels (Hyannis for Level 5 through Level 1). This feature enables you to report your related metrics at any level of the hierarchy.
In the user interface, the hierarchy attributes are in a subfolder under the main dimension folder, such as account, territory, and so on. All entries are displayed in alphabetical order. NOTE: When you use information from a hierarchy in an analysis, the information is based on historical data, which is compiled nightly. Even if the analysis is created for a real-time reporting subject area, the information is not based on real-time data. |
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |