XFGetMemberProperty
Hi Team, How does XFGetMemberProperty works in Excel AddIn? The fields in the formula I have are - MemberNameorScript PropertyName VaryByCubeTypeName VaryByScenarioTypeName VaryByTimeorTimeDimProfileName I want to pull the properties for Text 1 to Text 8 from OneStream Production for Entity, for different Time Periods like Default, 2023, 2024 and 2025. Now the properties I pulled at Default are giving correct result. But when trying to pull at year level like 2023, 2024 and 2025, I am not getting the correct data. It is only showing the data present at Default. But in OneStream Prod, I do have data in 2023, 2024 and 2025 for the Text Tags. In my formula, I was setting VaryByTimeorTimeDimProfileName = "2023". And so on for 2024 and 2025 I am getting the same thing for XFGetMemberPropertyVolatile formula as well. In OneStream my year values are stored in 'Stored Property Value' Can someone please help me here ?
Quickview: Exclude entity if it does not contain a Text1
Hi All. Is there a way to exclude entities that do not have a Text1 from the following? E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base or E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1) Since I have that in my data management and it shows an error if it does not find Text1, I need to exclude those that do not have Text1
Cube View Connection – Excel Formula Not Being Retained
Hi I linked several cube views into Excel with the settings below (Version 8.4.0). I then created some basic formulae within the cube views. E.g. = C25. The Excel formula is retained by the first cube view but in the other cube views it is moving up 4 rows on each refresh. The Cube View Connection options are the same in each one. I have tried selecting/deselecting the insert/delete rows & columns and including/excluding the header. The cube views all have some rows with a specific account and at least 1 row that uses “.Base”. Has anyone come across this before? Thanks. RobertHELP! Microsoft excel is waiting for another application to complete an OLE action after 8.5 Upgrade
Hello Experts, We have a few users that are getting below error while trying to close Excel windows after OneStream upgrade. Error text "Microsoft excel is waiting for another application to complete an OLE action" Can someone share any insights or guidance on resolution here? Regards, NDXlookup not working in OS-Spreadsheets
Hi, We have several excel sheets with XLOOKUP formula. In application-spreadsheet (v6.8 and V8.4) this is not working. Whereas it is working in MS-excel. Is this possible in OS-spreadsheet? Working around with match/index/vlookups etc is not a solution. Thanks, Rutger
xfdoc.xlsx - XFGETCELL - save as offline
hello we've a excel addin based report (XFGETCELL). this report has macros as well. the data is used for recon process on another server that doesnt have excel addin. Is there a way to run this though DM/ business rule? or can this be automated through onestream spreadsheet and save as offline? i separated macros in different file and tried running this report as xfdoc,xlsx. getting #Logon error on server (calc is automatic, cant change on server) is there a way to save as offline? i tried running through DM but facing #Logon issue. the server where we want to run recon does not have excel addin and we dont want to install. any ideas, please suggest. in longer run, cube view might be a better option but is there a better way to achieve this? pls suggest. thank you in advance
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. Phil
