Retrieve Parent property
SOURCE: ONESTREAM CHAMPIONS 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. PhilExtract Metadata to Excel
HI All Does anyone know a way to extract a given Hierarchy to Excel broken out by columns for each layer ie a parent in one and children in the other. Using HFM in the past, I recall being able to extract the different hierarchies to Excel but thus far havent found a nice way to do this in OS. Of course I can pull the hierarchies into a cube view and export to exel which does have some visual indentation but its all in one column. Appreciate any ideas! Thanks Tahir
Quick View no longer recognized
I had multiple, fully functioning quick views in my excel file. Once I saved my excel file and reopened, OneStream no longer recognizes two of the quick views. The name manager in excel still has the values associated but OneStream is not recognizing the ranges. Has anyone else had trouble with this? Is there a way to quickly restore a complex cube view without starting from scratch? Thanks, SeanReturn the parent member using XFGetHierarchyProperty function
Hi, I am trying to use the XFGetHierarchyProperty Spreadsheet function to return the "Parent member name" property of a member. I tested the function by returning the HasChildren property and that is working fine. However, how do I return the "Parent member name" property? Is that possible and what should I use as property string in the function? (the one below is not working and returns an error as you can see) Thank you
