Recent Discussions
Report component - The control is overlapped
Hi guys, I need to create a pie chart on a report component (under dashboard), but this pie chart has the particularity that, instead of showing up the labels of the data presented in the chart itself, i need to show the Total Amount inside the pie. The achieve this, i wanted to add an XF label taking the total from the cube, but when i set the label over the chart then i have the error "The control is overlapped". Do you have any workaround / solution to allow the controls, in particular the labels, overriding a chart? note: ok under preview that works, but at the end i need to use this report component in a docx file (with narrative reporting) - that's blocking me to use the report. Thanks a lot in advance, Regards, Florence
Quickview: Exclude entity if it does not contain a Text1
Hi All. Is there a way to exclude entities that do not have a Text1 from the following? E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base or E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1) Since I have that in my data management and it shows an error if it does not find Text1, I need to exclude those that do not have Text1
Cube View Connection – Excel Formula Not Being Retained
Hi I linked several cube views into Excel with the settings below (Version 8.4.0). I then created some basic formulae within the cube views. E.g. = C25. The Excel formula is retained by the first cube view but in the other cube views it is moving up 4 rows on each refresh. The Cube View Connection options are the same in each one. I have tried selecting/deselecting the insert/delete rows & columns and including/excluding the header. The cube views all have some rows with a specific account and at least 1 row that uses “.Base”. Has anyone come across this before? Thanks. RobertTrend Report showing Periodic negative balance for following month
Hi, I am building out a Trend report by year and by product, so I have Jan-Dec along the columns, and then 2022-2025 for each product type by row. My problem is that because i'm viewing this in V#Periodic, when I run the report for March 2025, April's balance shows up as the negative YTD balance for 2025. Is there any kind of conditional formatting I can use that says something like "If the intersection of month and year in the cube view (in this case, April 2025) is larger than the Time POV parameter selected when you run the report (March 2025), then change the text color to White so it doesn't show up?Report Component - adding a pie chart appears twice
Hello, I need to create a pie chart in a report component (under dashboard). So i created a very simple cube view with 2 elements of the UD1 dimension, and 1 column showing up an account. With this cube view, I created a data adaptor, with Command Type = Cube View and Data Table Per Cube View Row = False; when I open the data adaptor then I can see the correct data, with 2 rows and 2 amounts then. Now, when I create a report component and add a pie chart on it, the pie chart appears properly and as expected (2 pieces in the pie, for each UD1) but it appears twice ! And twice the exact same pie! Any idea from where/which setting this is coming from please? I am struggling in finding it.. Thanks in advance, FlorenceDynamic 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,
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!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
