Reporting

Originally posted by Darryl GerrowDoes anyone have an example of how to use VisualBasic in Excel to call the OneStream XF functions, specifically the "Refresh Workbook" and/or "Submit Workbook" API functions?   Thanks,

Originally posted by Rob Gaughran6/11/2020 I have a 6 tab Data Explorer dashboard.Can I specify a default tab rather than it always defaulting to the first tab?

Originally posted by Christophe JelskiHello all, I am building up graphical reporting (charts) and I am kind of stuck, lacking features I am used to in XL. I could not find any how to guidance on the subjects, like : - trend lines - combo charts displaying components in stacked columns (AR, AP, INV) and total (working capital) as a line - regression line on scatter. I am attaching quick displays comparing OS (what I managed to do) and XL (what I am aiming at in). For the moment, I am sticking with cube view dump in XL, but if I could make it available online, this would be even better. Anybody facing the same issue ? Anybody found a solution ? Thx for your feed. CJ    

Originally posted by Rob Dessureault on 4/28/2020 Is there a way to use a Range for the Time year in a CV?

Originally posted by David Bender4/24/2020 Loading data from a client on version 5.1 to local host which is 5.3. Received error saving Dashboard Component. Lbl_blank exists in Maintenance Unit: Seeding

Originally posted by Geoffroy des Dorides4/29/2020 Dynamic way to get the parent for an entity in Quick View?

Originally posted by Michael MalandraIs the 4.2 excel addin compatible with Hyperion SmartView 11.142.610?

Originally posted by Andrea Tout3/27/2018 Has anyone not been able to get the "OneStreamXF" Right click option in the excel add-in?

Originally posted by Chul Smith7/27/2018 I've got a data source with two accounts and two amounts in each line and need to load both. I was going to use a derivative rule to create an additional line for the second account (imported to Attribute 1) and use a BR to grab the amount for the second account (Attribute Value 1 field). Who's got a rule to do this? Or do you have a better way - I was thinking maybe a BR on the data source but don't think that creates an additional line of data to import

Originally posted by Brian Dildy11/6/2019 I installed 5.2 last month including the Excel add-in. When I attempt to connect to my client via Excel add-in I am getting this message. Do I have to revert back to the prior add-in version?

Originally posted by Tiffany Ma8/15/2018 I'm trying to have all the CV's that are in the form profile referenced in the WF Profile open in Spreadsheet when I'm in the windows app. To do this, I set all the form types in the group to Spreadsheet, as shown in the screen shot. Once I go to One Place to open the spreadsheet, nothing opens. Am I supposed to change anything else?

Originally posted by Kathryn Watkins12/19/2018 Has anyone had an issue with Excel add-in coming back in after it was disabled or heard complaints about Excel taking a long time to open? Two users told me today that even if they disable the add-in and close/reopen Excel, the ribbon is activated again the next time they open Excel. The only way to make it go away was to go into the Trust Center to disable it. When it's active, they have found that it's taking "30 min" to load (not sure if it's really 30 min or if that was exaggeration). They think the long load time is because they have a bunch of other add-ins also running and it's in conflict with one / many. No one has administrator rights to their own computer and no one wants to uninstall it because they won't be able to get it back when they need it.

Originally posted by Andrea Tout9/27/2018 Does anyone have a client uses Automate? My client is using Automate to run in the background (by help systems) and it interferes with our excel add-in. She can't run Automate in the background anymore and has to run it manually.

Originally posted by Michael Gialanella7/18/2018 Can the XF Spreadsheet be a source for a Form in a WF Forms channel? If that XF spreadsheet is a Cube View brought in to XF Spreadsheet?

Originally posted by Matt Kerslake1/22/2020 Is it possible to retrieve data from different OneStream environments (ie, Prod & Dev) in a single worksheet in Spreadsheet? I know I can bring in data from different CUBES, but what about environments?

Originally posted by Laura Garcia2/5/2020 Anyone seen this error before?  User is getting it when using Spreadsheet.

Originally posted by Tami Chuang3/5/2018 I have a question for anyone who uses the Excel SetCell functionality...I am setting a cell and have the NoDataAsZero property set to TRUE. If I have an existing value and try to send a missing value to the same cell, i would expect it to overwrite the previous value with the blank value as a zero and see nothing after submitting the sheet. However, the missing data is not treated that way and I still have the previous data. I have data existing in Forms from sending to BeforeAdj and am pushing the SetCell value to the same (BeforeAdj). Is this the expected behaviour here or am I missing something?

Originally posted by Celvin Kattookaran9/25/2018 I got the latest version of client software and customer is on a previous version.Is there a backward compatible version (or a forward compatible) that I can use. I don't want to downgrade my own installation.

Originally posted by Steve Mebius4/4/2019 Has anyone noticed that the in app spreadsheet cannot open xlsm files, only xlsx files.

Originally posted by Eric Osmanski6/20/2019 You cannot highlight cells and see the total in Spreadsheet in OneStream. Is this on the radar? Is there a way to get a subtotal without using the Sum function? Obviously the below is a simple example but think a huge Budget Form with a ton of cells where people need to see Sums of various things all over.

Originally posted by Andrea Tout3/5/2018 The excel add-in should not have issues installing on Windows 7 correct?

Originally posted by Sam Richards5/29/2018 Has anybody had any issues using spreadsheets as components in dashboards? I have a spreadsheet that is a component and it will run fine and display the numbers correctly for a brief moment then it loses the number formatting. The only thing I can think of it that it is losing my parameter that controls the formatting for some reason in the dashboard component.

Originally posted by Debra O'Connell8/26/2019 Does anyone have a concise list of the steps to convert Hyperion SmartView files to OneStream Add-In? Sales is looking for something to include in a deck

Originally posted by Cameron Lackpour3/28/2019 I’m trying to use a spreadsheet in a dashboard with a simple parameter-driven CV.When I open the CV interactively in the spreadsheet and then click on Refresh in the ribbon, the CV parameter dialog box pops up, I make my selections, et voilà, I have my CV-within-a-spreadsheet: However, when I make this a dashboard content component, and set the “Refresh Spreadsheet When Opened” parameter to true, I get: Which is a bummer. I've tested this in 4.4 and 4.5 with the same result. Has anyone else seen this?  Is this an artefact of my local (somehow bad) client install?

Originally posted by Hein Scholten11/5/2017 Trying to open an XLbook from the Spreadsheet but that doesn't seem to work. I can open XLS but no XLbooks. Tried Open with... but that don't work either. Has anyone tried this? Or do we still need the add in for XL books?