Excel add-in: Save offline version not working
I have a client who is trying to save an offline version of some of their excel reports in order to share them with their auditors. First they open the spreadsheet, refresh the workbook, then select the "Save Offline Copy" feature from the OneStream ribbon bar. Second, they close the original spreadsheet, then attempt to open the "offline" version. What appears is a series of #VALUE! where there should have been offline data. Has anyone else out there encountered this? Is it a known bug? Is there any type of work-around? The client does not want to use excel's copy-paste value feature because there are excel (non-OneStream) formulas such as "SUM" that they want to preserve. Any ideas, suggestions, or information would be much appreciated. Thank you,
The Consolidate button is always greyed out in my excel quick view
Hello OneStream experts: Thank all of you for the dedicate helps. I build onestream quick view using excel. It seems all the functions in my quick view is working except the consolidate button is always greyed out not matter how I change my POV. I would like to use my quick view to consolidate data to the parent entities. But I can only do calculate and Translate, not Consolidate with quick view in Excel. I would really appreciate that someone may tell me how to do consolidate with my excel quick view. Thank you in advance.OS V9 Excel Add-in Parameters Feature
Hi all, I've been playing with this feature for a bit and it would appear that if you've made a cube view connection to a CV that contains parameters based on "Member Dialog", those parameters don't seem to work as expected. The resulting worksheet does create a space for those parameters but in the cell where you would select your member, there is no dropdown available to open and choose. The cell is completely blank. Upon refresh, I am prompted for those member dialog parameters but even the result I choose is not returned to display on the sheet. Doesn't seem to be any issues if the parameter is based on a Member Filter. Am I doing something wrong or is the use of Member Dialog parameters in Excel add-in simply not possible? There is nothing in the existing documentation that I can find that discusses this. Attaching a screen capture of the Excel results:
Spreadsheet via Browser dashboard (OnePlace)
Hello everyone, I am currently working on OneStream v9.2 and trying to set up Ad Hoc reporting in the Web version (OnePlace). Context: I created a Dashboard with a Spreadsheet component exposed in Web (under OnePlace Dashboard). The connection to existing, preconfigured Cube Views is working correctly. Issue: In the Browser version, I do not have access to Quick View / dynamic POV features like in the Spreadsheet WinApp (Excel Add-in). I cannot find the option to perform free-form Ad Hoc analysis (changing axes, selecting members dynamically, etc.). Question: Is this a standard limitation of the Web version (OnePlace) in v9.2? Is there a specific configuration that enables a Quick View–like behavior in Web? Thank you in advance for your feedback and experience.
Saving Offline Copy
My team has recently been unable to save offline copies of Excel files that contain XFGetCells + CubeViews. Prior to this, we had no issues and had saved 100+ files offline as part of quarterly reporting. I have seen prior threads where this has been discussed some time ago, and our team has tried updating preferences, saved elsewhere, etc. with no luck. Is anyone else currently having this issue?
Excel add-in V9: Not able to drilldown
We recently upgraded from V7.4 to V9.1 and we’re seeing an issue with the Excel Add-In. A small group of users (about five) are unable to use the Drilldown feature (the option is completely greyed out), while the rest of our users can access it without any issues. All users have been upgraded to the 9.1 Excel Add-In and every other function appears to be working correctly. Has anyone else run into this? Any ideas on how to fix it?
