| 列印 開啟 PDF 版的線上說明

#### About Hierarchies Some 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: Top Level is set to USA. Level 8 has the following entries: Northeast, South, Midwest, and West. Level 7 has subentries, for example, the Northeast territory has: Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, and Connecticut. Level 6 has more subentries. For example, the Massachusetts entry has: Boston, Cape Cod, Eastern Massachusetts, and Western Massachusetts. Level 5 divides the previous territories further. For example, the Cape Cod territory has: Lower Cape, Outer Cape, Hyannis, and Barnstable. Level 4 is not used in this example. Level 3 is not used in this example. Level 2 is not used in this example. Level 1 is not used in this example. 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.
Top Level Territory Name | USA
Level 8 Territory Name | Northeast
Level 7 Territory Name | Massachusetts
Level 6 Territory Name | Cape Cod
Level 5 Territory Name | Hyannis
Level 4 Territory Name | Hyannis
Level 3 Territory Name | Hyannis
Level 2 Territory Name | Hyannis
Level 1 Territory Name | Hyannis
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.

2022年8月 | Copyright © 2005, 2022, Oracle 和 (或) 其關係企業。 Legal Notices.