Error retrieving parent member name

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 (onestreamsoftware.com)

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)