Reporting

Originally posted by Celvin Kattookaran4/24/2018 I'm trying to create a copy of UTM_HelperQueries, I created a copy of UTM_SolutionHelper and trying to reference that in my new helperquery (UTMR_HelperQueries). It'll not allow me to do reference the main class. Dim utmHelper As New OneStream.BusinessRule.DashboardExtender.UTMR_SolutionHelper.MainClassSaysError at line 141: Type 'OneStream.BusinessRule.DashboardExtender.UTMR_SolutionHelper.MainClass' is not defined. If I edit UTM_HelperQueries same thing happens (changing to DashboardExtender.UTMR_SolutionHelper.MainClass) Is there a way to do this, I don't want to change the default helperquery.

Originally posted by Cameron Lackpour6/15/2018 I have a terminate-with-extreme-prejudice calc that clears data and the client has asked that there be a, "A you really, really, really sure you want to do this?" message.

Originally posted by Andy Moore2/26/2020 does anyone have any good admin dashboards they could share for admin activities ?

Originally posted by Andy Moore5/24/2018 Does anyone know the process for activating mobile dashboards/cube views?

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?