Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
3 years ago
Solved

Return the parent member using XFGetHierarchyProperty function

Hi,   I am trying to use the XFGetHierarchyProperty Spreadsheet function to return the "Parent member name" property of a member.   I tested the function by returning the HasChildren property...
Excel Add In
  • AndreaF's avatar
    AndreaF
    3 years ago

    Thank you for your reply. Since the parent member is a relationship property, looking at the XFGetRelationshipProperty function probably makes more sense. However, as you pointed out a member can have multiple parents. Looking in the dimension library I believe the properties that are greyed out can be used to identify the relationship, but cannot be retrieve using the XFGetRelationshipProperty function, while what is not greyed out can be retrieved with the XFGetRelationshipProperty function.

     

     

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

From documentation:

This function determines whether or not a Dimension has children and returns True or False

XFGetHierarchyProperty(“DimTypeName”,”DimName”,“MemberName or Script”,“PropertyName”,”PrimaryCubeName”,”ScenarioTypeNameForMembers”,
”MergeMembersfromReferencedCubes”)

Example: Retrieving Child  Hierarchy
XFGetHierarchyProperty("entity","HoustonEntities","Houston Heights","HasChildren","Houston","Actual",FALSE)

There is no mention of parents. I would argue returning a parent would be difficult, because any member can have multiple ones in a hierarchy.