HELP! 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, ND207Views0likes10CommentsPreserve formatting in a Quick View
Hi everyone Is there a way to preserve formatting in a Quick View (not Cube View) in Spreadsheet or Excel Add-in on certain row levels? E.g. Font colour for base members = Blue. With Cube Views in Spreadsheet or Excel Add-in you can highlight the levels and assign Styles but this is not available in Quick Views, only in certain sections of the Quick View grid, e.g. Primary Style, Upper Left Style, Row Header, Column Header Style and Data Style. I noticed in the 8.5.1 version documentation that this option is available when you create a new Quick View, but not in the 7.4 version we are using: Regards Johan10Views0likes0CommentsIn Sheet Action Buttons Disappearing/Greyed Out
Good afternoon, I was wondering if anyone has had the issue of In-Sheet Action Buttons turning grey and not working within the excel add in. The environment is 8.5.1, using the 64 bit version of excel, and has the updated excel add in. When using the in sheet actions within the spreadsheet tool, there are no issues with the Buttons and the DM steps run as expected. When opening up in Excel, the first button is greyed out and does not initiate any tasks, while the green button still works. If anyone has any resolutions, I would appreciate it. Thanks, Ben8Views0likes0CommentsGet member description in user's culture code using excel add-in
Hi all, Do you know how to get the member description in a scpecific language using the Excell add-in? I suppose that it can be done using the "XFGetMemberProperty" but I can't find an example. Thank you. XFGetMemberProperty This function retrieves any Dimension Member property from the Member Properties tab in the Dimension Library. Note there are no spaces used when defining property name. XFGetMemberProperty(“DimTypeName”,“MemberName or Script”,“PropertyName”, “VaryByCubeTypeName”,“VaryByScenarioTypeName”,“VaryByTimeName”) As a reference when using BR: Get member description in user's culture code | OneStream Community Best regards, CarlosSolved38Views0likes4CommentsDynamic Calc UD8 Dimension to Filter Account Dimension?
Is it possible to create a dynamic calc UD8 dimension, that then filters down the members on the Account dimension at a base level? (and if so, how?) For example, within the Account dimension, I have Member A, Member B, Member C and Member D. Can I create UD8 dimensions of "Group 1" and "Group 2" where if Group 1 is selected, it filters down Account to only show Member A and Member B. And if I choose Group 2, it filters Account to only include Member C and Member D. I know this can be accomplished with an alternate hierarchy on the Account dimension but just checking to see if this can be done alternatively. Thanks in advance!13Views0likes0CommentsXFGetMemberProperty
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 ?84Views0likes1CommentQuickview: 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 Text132Views0likes1CommentCube View Connection Issue with Preserve Excel Format
Hello, On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it?Solved42Views0likes2Comments