Forum Discussion

nbabu's avatar
nbabu
New Contributor
6 months ago

Error retrieving parent member name

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...
Excel Add In
Henning's avatar
Henning
Valued Contributor II
6 months ago

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)