XFGETCELL #REFRESH
Certain users aren't able to refresh sheet containing XFGETCELL. Only shows #REFRESH. In OneStream task activity, it shows that the task has failed with an error message "Summary: Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1." This should not be related to access since I was able to refresh sheet using another profile with the same roles.
Save Offline Copy
I'm getting the below error message regarding location when trying to save a file with multiple XFGetCell formulas offline. I've updated my preferences that an earlier question showed as a solution and refreshed the workbook (again) before attempting to save...but am unable to save the file without the formulas. I've tried directly to my desktop, various folders, where downloads go.... I can't find an acceptable location. Any help would be appreciated.
Refreshing an emailed spreadsheet
We just upgraded from 8.4 to 9.0, and almost certain before we could email a spreadsheet with XF functions and immediately refresh the spreadsheet with button in the ribbon when already logged in. Now the Refresh Sheet button is grayed out, and now you have to "save as" the spreadsheet then refresh because the spreadsheet is in "read only" mode. I'm trying to decide if it changed with the upgrade, or if one of the Preferences settings affect this, or if we are just not remembering correctly. Any ideas or are we just wrong?Excel Addin Tab disappearing from the Menu
Hi community, Have you experience users reporting Excel Addin Ribbon disappearing from the Excel Menu ? The problem behavior is: User reports that OneStream Excel Add-in disappeared We are able to mark it as enable again After some time the add-in gets disabled again for the same user We have tried to reinstall OneStream Excel Addin, and the add-in get enabled, but it disabled itself after some time. Users use different ERP Add-ins, it may be a compatibility issue, have you any remediation for this cases ? Regards! Carmina
Hierarchy Comparison Reports or Dashboards
Has anyone built a cube view, or more likely a dashboard, that can automatically compare the base level members of 2 or more hierarchies in a dimension to identify exceptions? We do this manually now in Excel but was asked by the users to put this comparison in OneStream. I thought this might be an application report, but I don't see anything close. Also, we are currently on v7.4, so if there is a feature in the latest version please pass along. Thanks!Automate Excel workbook refresh
We have an Excel workbook with a *lot* of embedded cube views and table views. Some sheets have two Cube Views with Excel formulas showing significant differences. Others have stacked Cube Views showing Import, IFRS Adjustments and Total. We cannot use Books because of this. It takes about an hour to refresh the workbook so we want to automate the refresh somehow. Anyone have any suggestions about how to automate the refresh? Thanks Marcus
