OBIEE RPD开发

A parent-child hierarchy is a hierarchy of members that all have the same type. This contrasts with level-based hierarchies, where members of the same type occur only at a single level of the hierarchy. The most common real-life occurrence of a parent-child hierarchy is an organizational reporting hierarchy chart, where the following all apply:

父子层次的维，其所有成员具有相同的类型。基于级别的层次的维不一样，其类型一致的成员仅处于层次中的同一级别。父子层次的为最常见的实际使用情景是，开发具有组织汇报层次的图表。具体应用如下：

• Each individual in the organization is an employee.
• Each employee, apart from the top-level managers, reports to a single manager.
• The reporting hierarchy has many levels.

• 组织中的每个个体都是一位雇员。
• 除了顶层管理者，每位雇员都向单个管理者汇报。
• 汇报层次具有很多级别。

In relational tables, the relationships between different members in a parent-child hierarchy are implicitly defined by the identifier key values in the associated base table. However, for each Oracle BI Server parent-child hierarchy defined on a relational table, you must also explicitly define the inter-member relationships in a separate parent-child relationship table.

在关系表中，父子层次的维的不同成员的关系由关联基表中的标识符的值隐含地定义。但是，对于Oracle BI Server中每个父子层次的维定义在关系表中，你必须同时明确地定义内部成员的关系在各自的父子关系表中。

To create a logical dimension with a parent-child hierarchy, perform the following steps:
• Open the Repository in Offline Mode
• Import Metadata and Define Physical Layer Objects
• Create Logical Table and Logical Columns
• Create a Logical Join
• Create a Parent-Child Logical Dimension
• Define Parent-Child Settings
• Create Presentation Layer Objects
• Test Your Work