Business rules for nodes at lower levels of a hierarchy may require the evaluation of property values from ancestor nodes above them. One way to allow these property values to be referenced by lower-level nodes is to enable inheritance on the property definition that manages the values that must be referenced. However, in many cases, using an inheritance for a property definition is not appropriate.
You can use specific hierarchical formula functions with a self-reference to the current property definition to recurse up a branch of a hierarchy to retrieve or evaluate property values for ancestor nodes.
ParentPropValue––Use this function to recurse up a branch of ancestors in the current hierarchy. For example: If(Equals(Integer,PropValue(Core.Level),1),Label Only,ParentPropValue(Essbase.DataStorage))
HierNodePropValue––Use this function to recurse up a branch of ancestors in another hierarchy. For example: If(Equals(Boolean,PropValue(Custom.PlanPoint),True),Abbrev(),HierNodePropValue(Geography,HierNodePropValue(Geography,Abbrev(),Core.Parent),Custom.PlanMember))