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,
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 display
How to run calculations on all base members in a DynamicCalc
After having read a lot of this superb forum to discover OneStream, I'd like to ask you my first problem that I haven't managed to solve. I'd like to forecast sales for month M in relation to actual sales for month M-1 (if imported), or alternatively the M-1 budget, to which will be added management sales. If I perform this calculation in the view cube of the child entity, it replaces the actual M-1 with the budget when the actual M-1 does not exist (not imported). If I perform this calculation at parent entity level, entities with no M-1 actual are shown at €0 and not at the amount of their budget. I therefore end up with a sales figure that has been reduced by the number of companies that did not report sales in M-1. In my forecast calculation UD7, I was thinking of looping through each base member so that the condition calculation (if the actual is absent then takes the budget, otherwise takes the actual) so that the forecast sales figure displayed corresponds to the sum of the individual calculations, but I can't do it: Dim Entité As String = api.Pov.Entity.Name Dim EntitiesList As List(Of Member) = api.Members.GetBaseMembers(api.Pov.EntityDim.DimPk, api.Members.GetMemberId(dimtype.Entity.Id, Entité)) For Each Entity As Member In EntitiesList CA_M_Antérieur = api.Data.GetDataCell("E#" + Entity.Name + ":S#REEL_Gestion:T#POVFirstInMonthPrior1:A#R70600_020:U7#Conso:U8#PF_Restit").CellAmount The calculation works when I select the child entities, but not for the parent, which returns 0. Do you know how I can do this calculation for all the base children?Display 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 !Center headers within a cell (After 8.2 release)
Hi team, my client was excited to upgrade to 8.2 to center headers. After turning on this functionality, what we have found is below. Can you tell me if I'm missing a setting here to make it work like we want it to? Finding: It only works if it is the top row AND it is a single member repeating. Notice how the months aren't centered, also notice that even though the scenario is merged and in the center cell, it is not centered WITHIN the cell.
