The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

nbabu's avatar
nbabu
New Contributor
1 year 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
Icon for OneStream Employee rankOneStream Employee
1 year 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)