Forum Discussion
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...
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.
This should be something for the IdeaStream for sure! I have had similar requests from our users. Realize that there is the possibility of having multiple results but perhaps OneStream could create an XF function where one of the arguments is the individual hierarchy parent. The only other way I can think of to try to make this happen is to use one of the Text fields for the member to identify it's parent and then pull that but again that can be a LOT of manual effort.