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!
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
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 helpLeverage a CV Rule or parameter to choose row primary dimension
We are looking to have a cube view that uses a parameter or CV Extender to possibly control the primary dimension selection. This is used in a dashboard to show metadata selections with the dimension in the rows and ud8 dynamic formulas across the columns. Looking to see if anyone has any ideas on doing the dimension selection dynamically to use one CV only for displayDisplay User Local Time and Custom Date Format in Cube View Footer
Hello, We’re trying to display the date and time in the footer of our cube views in the following format: "Wednesday, April 16, 2025 - 16:27:13" (or "Mercredi 16 avril - 16:27:13" for a user with French culture settings). We are currently using the |DateTimeHHMMSS| variable, but it shows the server time (e.g., 14:27:13 instead of the user’s local time: 16:27:13). The native option via Application Properties > Show Date doesn’t meet our needs, as it displays the date in the format "4/16/2025" or "16/4/2025". We’re looking for a more readable format depending on user culture: "Wednesday, April 16, 2025" (EN culture) "Mercredi 16 avril" (FR culture) Does anyone know how to achieve this — displaying both the user’s local time and a culture-based, readable date format in the footer? Thanks a lot !Bi Viewer - Prior Time Totals
I have a daily report in bi viewer. This works by selecting the Week from a combo box and then it displays the days within that week (based on a sql table). I want to have the prior weeks show up as totals. Can't figure out how to do this within BI viewer or if I'll have to create a more defined sql query. Below are the screenshots from current setup. In this example I want to also see W1-4 but at their totals. Select Week combo box:Days in a month
Hi! If we have a workflow scenario like forecast month 1, forecast month 2, etc. How do I change the # of days that fall into each month? I know there is a specific way to do it because I recall a colleague of mine literally typing out say 30 or 31. I've tried going to application, time profile, in the time periods tab, if I go to 2025M1, it only has the ability to change the first day of the month. I've also changed what days week 1 start and end in but these workarounds are not what I'm looking for. Help please!
