Recent Discussions
Cube View - Conditional Formatting
Hi everyone, I'm currently working on a Cube View and would love some help with setting up conditional formatting based on a comparison between two columns. Specifically, I’m trying to highlight in red any cell in the “Actuals” column (Actual CPK @ ACT 2024 rate, Jan 2024) where the value is greater than the corresponding value in the “Cost per kg” column. To give you a clearer picture, I’ve attached a screenshot showing the layout I’m working with. The "Cost per kg" values are budgeted figures, and I'm comparing them to actuals from 2024 to identify any overages. I’d like the Cube View to visually flag these instances, so they stand out during reviews. Of course, the numbers in both columns are exemplary. In the rows I have different Entities. Has anyone done something similar or can guide me on the best way to achieve this? Thanks so much in advance for your support!
Dynamic Dashboard & Cubeview parameters
Hi, I have a classique cubeview that uses !prm_entity! as Entity POV. When using classic Dashboards, everything works as expected. When converting the dashboard from "Embedded" to "Embedded Dynamic" and using a simple Factory service to add the template cubeview stored component, nothing more: then the !prm_entity! POV of the cubeviews seems not interpreted at run time, no prompt showup and this cubeview displays a blank page. When checking cube POV we can see parameter is handled like a string in the POV. Any idea what basic setting i am missing to do in the Dynamic Dashboard way to let OS prompt for the prm_entity parameter value? Thanks in advance,
HELP! Microsoft excel is waiting for another application to complete an OLE action after 8.5 Upgrade
Hello Experts, We have a few users that are getting below error while trying to close Excel windows after OneStream upgrade. Error text "Microsoft excel is waiting for another application to complete an OLE action" Can someone share any insights or guidance on resolution here? Regards, ND
Parcel Service Fileshare Folder Path
Hello - I'm using Parcel Service to generate/ship a Book. The book is an Excel export file of a Cube View. Very simple. I can get the Excel file to email properly through Parcel Service. But, I also want to save a copy of the Excel file in the OneStream file system. Does anyone know the syntax for the OS file share path? I've tried everything I can think of. Thanks, Bil
Reports not displaying in Dashboard
I'm having trouble with a dashboard I'm building. I want to display either an IS or a BS on a single dashboard frame based on user's selection. I've created a list parameter with the options "Income Statement" and "Balance Sheet". However, no matter which option I select, the dashboard only displays the IS. I suspect I'm missing a step to properly link parameter selection to switch between the two reports. I don't have much experience with multi report dashboards up to now, I've only worked on single report dashboards. Could someone help point out what I am doing wrong or guide me on how to make the report dynamically switch based on the parameter. Thanks.
PDF export - Header text wrap breaks indentation in CubeView
Hi, I have a CubeView with indentation applied on row members. When exporting to PDF, I need all columns to fit on a single page. To do that, some column headers wrap onto two lines. The problem is that the indentation works only on the first line of the header. When the header text wraps, the second line is not indented, which creates a misalignment. Has anyone faced this? Is there a way to apply indentation on all lines of a wrapped header in PDF export? Thanks in advancePDF Export: Column height mismatch due to header wrapping in CubeView
Hi everyone, I have an issue when exporting a CubeView to PDF. In the web view, column headers do not wrap. All rows have the same height and everything is aligned properly. When exporting to PDF, I need all columns to fit on one page. To do that, some column headers wrap onto multiple lines. The problem is that the row cells under these wrapped headers do not adjust their height accordingly, which causes a misalignment between headers and data cells. Is there a way to force the row cells to align with the wrapped headers in PDF? Or any workaround to keep the layout consistent while making sure all columns fit on one page? Thanks a lot for your help
