XFGet formulas return #Refresh when used in a large file and the XFGet contains an argument that points to a formula and not a hard coded value. This seems to be especially the case when the XFGet is used to retrieve FxRates. For example: =IF(P5=
Originally posted by Arthur Shedd3KViews0likes3CommentsUnable to retrieve data through XFGet formula
Hi all, We have built a excel report which includes multiple xfget formulas. However, an #Value error shown in the cell after refresh (refresh sheet/refresh workbook both are not working). I have also checked that the dimensions have been entered correctly in the formula. May I know is there any solution to address this issue? Thank you. Best, Jacky71Views0likes2CommentsSpreadsheet Related Error Message
Hi Everyone, When trying to access the Spreadsheet section in our application, we were met with this error message that we did not recognize. We were unable to open the Spreadsheet section because of this unless we opened the application in a new window. Has anyone seen this error message before or know what the root cause for it was?42Views0likes0CommentsQuickviews and the Consolidation dimension
Is there a way to drill through the entity hierarchy in a Quickview that shows the total of Top in the Consolidation dimension? I have users asking me if this is possible. In the example above 87M is the total amount of the child entities including eliminations showing in the second Quickview but no total. The first Quickview is at local before eliminations therefore doesn't addup to the total of 87M. I've tried to use CAD but get the same numbers as local.Solved154Views0likes2CommentsCube 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. Robert85Views0likes0CommentsQuick 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, Sean7.2KViews3likes20CommentsOnestream Excel Add-In - Server Address gets deleted when clicking on "Connect"
Hello, we encounter the following behaviour with the OneStream Desktop Client and the Excel Add-In: The Server Adress URL is stored in c:\users\[username]\AppData\Roaming\OneStream\Common\Settings\webserverurl.txt As soon as I click connect, the URL stored in the webserverurl.txt file gets deleted with the next start of the desktop application or the Excel Add-In, the Server Address field is empty and I have to get the Connection URL by clicking the three dots next to the Server Adress field (which is quite annoying). Does anyone of you encounter the same issue? Regards Martin GebhartlSolved2KViews1like9CommentsOneStream Excel AddIn Setup Wizard ended prematurely
Hello! I have one of the users receiving the error "OneStream Excel AddIn Setup Wizard ended prematurely" while trying to install OneStream Excel Add-in. The user is an administrator on the laptop. Tried a few things like closing all Microsoft office applications, deleting the APPDATA folders, restarting the computer....nothing help! Anyone faced this issue or seen this error before? If so, what steps were taken to resolve it? Thanks, Hari240Views0likes2Comments