Recent Discussions
ONC - IntercompanyDetailAllPlugaccounts - Suppress matches
Hi, We have moved to v9, and the previously used IC matching methods are giving us issues. For this we have a ticket open with support, and they have pointed us towards ONC. We use something very similar to the intercompany all plugs, but then supressing any combinations that are matching. Is there a way to filter the IntercompanyDetailAllPlugAccountsGridView_ONC to suppress the matches? It seems to be working in our development environment, but would be great if we can supress the matches as this is something that will be required. We have tried this: {WS}{GetIntercompanyDetailAllPlugAccountsGridView}{View = |!Members_View_Numeric_ONC!|, SuppressMatches=True} But that does not seem to work. With kind regards, Tim
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?
OS Genesis CubeViewTreeView
Hi All, When opening a cube view via OS Genesis cube view tree view, the content block can take a while to open. Even though there is no data, it is a simple cube view PnL. Opening it via cube view or dashboard takes only 2 seconds with data. Is there a way to improve the performance of the cube view tree view content? Appreciate your help on this.
Get the name of the current container of an embedded dashboard
Hi everyone, In a dashboard that I'm developing I have multiple dashboards embedded into one another. Within one of the embedded dashboards I have a button that is associated to a dashbaord extender rule. When the button is clicked, I need the rule to retrieve the name of the dashboard that is currently the container of the embedded dashboard where the button is placed (see scheme below) Primary dashboard Embedded 1 Embedded 2 Embedded 3 -> button I see there are two rules (args.PrimaryDashboard and args.EmbeddedDashboard) that allow to retrieve the name of the primary dashboard OR the name of the current dashboard (Embedded 3 in the example). I need to retrieve the name of Embedded 2. I couldn't find any resource that explained if and how to do that. Does anyone know how to do that? Thank you
Updating Time Zone from UTC in Dashboards
Does anyone know how to change the time zone used in OneStream Dashboards from UTC to a different time zone (e.g., Eastern Time)? We’re implementing for a client based in Eastern Time, and we’d like dashboard times to reflect that for end users. Any guidance or recommended approaches would be appreciated. Thanks!CVR and GetDataCell Issue in cube views
Hello, I currently have a cube where I am having an issue calculating variances. The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12). When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell. I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?
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,
