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
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”,B15,“ParentMemberName”,"","","")
It returns #ERROR: PropertyName
1 Reply
HenningOneStream Employee
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:
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)