07-12-2024 12:04 PM
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
07-15-2024 02:55 AM
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)