Error retrieving parent member name

[nbabu]

Hi,

I am getting error when retrieving parent member name of a UD dimension using XFGetRelationshipProperty. I have used below syntax. Could someone please help me.

XFGetRelationshipProperty(“UD4”,B15,“ParentMemberName”,"","","") 

It returns #ERROR: PropertyName

[Henning]

Hi, you need to provide the following information as part of your query:

You have to provide the parent name (second from above), you cannot retrieve it. The reason for this is that a member (technically) can have multiple parents, but you are looking to retrieve a single value. 

@AndreaF explains this here as well:

Solved: Return the parent member using XFGetHierarchyProperty function - OneStream Community (onestr...

@RobDessureault posted a nice file with some examples on how to use some Excel formulas in the Knowledge Base here:

Sample Excel Formulas - OneStream Community (onestreamsoftware.com)