09-16-2022 04:00 PM - last edited on 05-24-2023 12:51 PM by JackLacava
Hi All,
I am trying to find a way to create a report that shows the Entity and the Parent in a column next to it. I tried to do this by using the functions =XFGetMemberProperty() and =XFGetRelationshipProperty(), both returns an error when I try.
=XFGetRelationshipProperty(“Entity”,"",B15,“Parent”,"","") returns “#ERROR: Parent”
=XFGetRelationshipProperty(“Entity”,B16,"",“Parent”,"","") returns “#ERROR: Member Name”
=XFGetRelationshipProperty(“Entity”,B17,"",“Parent”,“ACTUAL”,“2021M1”) returns “#ERROR: Member Name”
=XFGetRelationshipProperty(“Entity”,B4,B5,“Parent”,"","") returns “#ERROR: Parent”
=XFGetMemberProperty(“Entity”,B13,“Parent”,“Finance”,“Actual”,“2021M1”) returns “#ERROR: Finance”
=XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent”
=XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent”
=XFGetMemberProperty(“Entity”,B11,“Parent”,"","",“2021M1”) returns “#ERROR: Parent”
=XFGetMemberProperty(“Entity”,B12,“Parent”,"","","") returns “#ERROR: Parent”
as a reference, I tried the same function on “currency” and that works.
=XFGetMemberProperty(“Entity”,B21,“Currency”,"","","") returns “EUR”
I am assuming that the complexity lies in the fact that the parent could vary in time (?) .
I hope some body can help on this thanks.
Phil
09-20-2022 08:50 AM - edited 09-20-2022 08:50 AM
I tried doing this before and was unsuccessful. I am guessing it has something to do with OneStream's extensibility and that a member can have multiple parents. The system wouldn't know what parent needs to be retrieved. That's only a guess, but I'd be interested to see if it can be done.
09-20-2022 12:21 PM
Hi pling: you can get the parent-child in an export directly from the Application -> Dimensions tab in OneStream.
Steps:
Cheers -DB