Planning Unit Hierarchy Dimension Properties

Primary Member, Primary Enabled, Secondary Dimension, Secondary Parent, Relative Generation, Auto Include, Secondary Member, Include, Owner, Reviewers, Notifiees

Table 5-15 Planning Unit Hierarchy Dimension Properties

Column Header in Load File	Oracle Hyperion Planning Property	Value	Default	Required
Primary Member	Primary dimension (Entity) member name. This property corresponds to the Name column of the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page.	Text	None	Yes
Primary Enabled	Enables the Primary Member for Approvals. This property corresponds to the Enabled column of the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page.	True, False, or an integer: non-zero is true; zero is false	None	No
Secondary Dimension	Dimension name that specifies the Subhierarchy Dimension to be associated with the Primary Member. This property corresponds to the Dimension column of the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page.	Text	None	No
Secondary Parent	Dimension member name that is referenced in specifying Secondary Members with the Relative Generation property. This property corresponds to the Parent Member column of the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page.	Text	None	No
Relative Generation	A numeric range specifying the descendants of the Secondary Parent for participation in Approvals depending on the Auto Include and Include properties. This property corresponds to the Relative Generation column of the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page.	Integers specifying a range of generations. For example, 1-3 designates generations {1,2,3}; 1,3-5 designates generations {1,3,4,5}; 0-4,7 designates generations {0,1,2,3,4,7}, and so on. Level 0 is equal to the generation of the Secondary Parent, level 1 is equal to the generation of immediate children of the Secondary Parent, and so on.	None	No
Auto Include	Enables for Approvals the descendant members specified with the Secondary Parent and Relative Generation properties. This setting can be overridden on a member-by-member basis with the Include property. This property corresponds to the Auto Include check box on the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page.	True, False, or an integer: non-zero is true; zero is false	None	No
Include	Enables for Approvals the specified subhierarchy member. This property corresponds to the check boxes in the Selected Members pop-up window that displays when the icon on the far right column of the Primary and Subhierarchy Selection tab of the Planning Unit Hierarchy page is clicked.	True, False, or an integer: non-zero is true; zero is false	True	No
Secondary Member	Secondary dimension member name that was enabled for Approvals. The Include, Owner, Reviewers, and Notifiees properties are dependent on this property. This property corresponds to the Selected Members column of the Primary and Subhierarchy Selection tab, and the Name column (where Secondary Members are specified) of the Assign Owners tab, of the Planning Unit Hierarchy page.	Text	None	Yes, if these column headers are defined: Owner, Reviewers, Notifiees
Owner	User name of the owner for the specified member. This property corresponds to the Owner column of the Assign Owners tab of the Planning Unit Hierarchy page.	Text	None	No
Reviewers	A comma separated list of reviewers for the specified member. This property corresponds to the Reviewer column of the Assign Owners tab of the Planning Unit Hierarchy page. Note Specify the reviewers in the order you want them to review the planning unit. The first reviewer in the list is the first user to work on the planning unit. When the first user promotes the planning unit, the second reviewer in the list becomes the planning unit owner, and so on through the list of reviewers you create.	Text	None	No
Notifiees	A comma separated list of Notifiees for the specified member. This property corresponds to the Notify Users column of the Assign Owners tab of the Planning Unit Hierarchy page.	Text	None	No