Guided Reporting/Dashboard parameter WF Profile entity value defaulting to Parent
Hi all, I am implementing Guided Reporting into our workflows. The entity parameter I have is a member list looking up E#Root.WFProfileEntities. The cube view is a pretty standard balance sheet, with row and column sets. I have embedded it into the workflow, so that users can come in and use their reporting for the specific entities. The issue I have is that whenever I open the balance sheet and set the rows and columns, the cube view always defaults to the Group Parent entity, even if the WF profile has different assigned entities. I change workflow, and it still shows the parent entity. It's only when I change the entity manually from the GR parameter button that it refreshes. Any idea how to link the entity button to set the cube view upon first run? Maybe I'm missing something, or maybe there is a BR that I can build? Thanks!
Top Ten and All Other
Hi. I have a cube view / customer sales report where I can get my top ten customer sales, and I have a row that has the total sales. How can I make a row to show 'All Others' so I can foot the lines to the total sales? I've tried a CVR calc but it pulls in the top customer only. Thanks, BrianGuided Reporting Duplicate Param Dialogue Box Showing on Run or Param Change
Hi OneStreamers, I'm currently working with the Guided reporting solution in OS v8.4.0. When running the report in the GDR homepage a duplicate dialogue box appears after the Guided Reporting Dashboard is selected via the OnePlace menu item, once a report is selected, or after a Parameter is changed anytime the Parameter combo box is changed. Each Parameter is set up a Member list at the moment but were previously discovered as Member Dialogue, and now rediscovered as the updated Member list param. Any Idea what I could be missing?
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!
Trend 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?Cube View Row Math?
Hello all, I've written a Member Filter Builder on A#IncomeStatement.Base.Where(AccountType Contains Revenue). A second one for Expense too. I am now trying to sum those rows and cannot seem to get the math logic to render. Any advise out there - what am I missing or not considering? Columns are Entities, not row/column sharing, and the number of rows are extensive. I've tried the following and cannot seem to get it right: GetDataCell(CVR([TB_Rev])):Name(Total Revenue) GetDataCell(A#IncomeStatement.Base.Where(AccountType Contains Rev):Name Thanks in advance for your help,Data labels in report graph
Hi everyone, I am creating a graph in a report. This report is a component in a dashboard maintenance unit and is using a simple data adapter linked to a cube view to retrieve the data. The graph is working. However, I would like to only show a data label based on a time selection parameter that is part of the data adapter. For instance, if I select 2022M11, I only want to see the data label for November 2022. Please see the screenshot for clarification. So, if I select November 2022 (or any other year) I would only like to see the data label for November (I still need to work on the number formatting). Is there anyone with experience in this and can help me? I have checked all the options but couldn't find anything. I was thinking to work with the scripts part of the report components. Any help is much appreciated. Thanks! Floris van der PoelReport 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
