Recent Discussions
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!
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?
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 youCVR 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,
Bi-Viewer - Title and Legend
Bi-viewer appears to be limited on font size and type in version 8.5. So, what I've done is created anpng file through paint and chose the Load option in my Title in my bi-viewer to work around the original legend that is too small. What this allows me to do is have the font whatever size I want and I can make my legend line up with my bar chart. Looks beautiful on the client, but as always, the browser requires something "special". Is there anyway that I can use this thought pattern to make it appear on the browser. The Load function only looks at my cdrive which will not work on the browser. I tried uploading it to Data Explorer to get it on Onestream and then using that url in my image, then attaching my image to the same dashboard where my bi-viewer runs but it doesn't embed it into my chart so browser doesn't like that either. Regardkess if what I try, I just get the picture icon where my Title should be. Any ideas? ....even if it's something I've not mentioned here? Thanks ahead of time.
Referencing Image files in different workspaces
Hi, I am trying to reference a file location using an xfbr string in a image component. When the image component is configured like this: File Source Type - Workspace File Url or Full File Name - <FileName.png> This works to reference the other workspace. However when I use an XFBR String Service to return the exact same <FileName.png> it does nothing. I have also tried <Workspace.FileName.png> & <Workspace.MaintenanceUnit.FileName.png> without luck. The idea is to conditionally return different image files.The Consolidate button is always greyed out in my excel quick view
Hello OneStream experts: Thank all of you for the dedicate helps. I build onestream quick view using excel. It seems all the functions in my quick view is working except the consolidate button is always greyed out not matter how I change my POV. I would like to use my quick view to consolidate data to the parent entities. But I can only do calculate and Translate, not Consolidate with quick view in Excel. I would really appreciate that someone may tell me how to do consolidate with my excel quick view. Thank you in advance.
