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!Guided 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?
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 Poel
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,
Guided Reporting: Delimited List displaying Value Items
Hi I'm using Guided Reporting to generate a Cube View. Within the Cube View, a parameter (delimited list) is used to show / hide columns. This is working fine. My problem is that in the Selector List, Guided Reporting is showing the Value Item (of the Delimited List) instead of the Display Item. For example, an end-user will select 'Collapsed' (Display Item) but Guided Reporting will show 'IsColumnVisible = CVMathOnly' as the Display Item. This isn't impacting report functionality, however it looks messy.
Force Excel to store the source number (no scaling) when CV is exported
Hoping someone out there has some ideas on how to make this work... Let's say we have a cube view containing a parameter that allows the user to select a scaling option (millions, thousands or no scaling). The results of the parameter are stored in the CV's default CellFormat. Currently, when the CV is run and exported to Excel; regardless of the scaling selected by the user, the display in Excel is in thousands and Excel stores the entire number (unscaled). For example - if scaling selected is millions: If the number is 345,773,247.11; it displays in the CV as 346, it displays in Excel as 345,773 (but the stored number shown in the formula bar is the correct source value: 345,773,247.11). In other words, regardless of whether user selects thousands, millions or no scaling.... Excel displays as thousands and stores the correct number. If I try to change the Excel format to display in any other way (i.e. millions), it will store the scaled value based on the format and no longer stores the full number. This happens even if I force ExcelUseScale=False. The goal in this exercise is to figure out a way to "display" the exported CV in Excel exactly as it appears in the cube view but still retain the whole number. Using the above example, I would like to see this result: CV Displays 346 Excel Displays 346 Excel stores 345,773,247.11 Is this even possible? I have tried multiple ways to make this work including manual formatting, XFBR, parameters, etc., but I still can't determine the exact combination of formatting options that will result in what I want to see. Would love to hear if anyone has found a way to accomplish this. ThanksConditional Formatting in Cube view on Annotation members
HI, I am looking for an option to highlight text value in the cube view based on some condition. I have combo box which has parameter which pulling value from one of the DIM Member 1 = United States Member 2 = Canada Member 2 = Not filled If its not filled then I want to highlight red. Is there any option. I tried using XFBR but seems like it run on specific data unit onlyUnable to open shared Cube View
Hello, We are trying to use row and column templates in a Cube View but are using parameters to populate the names of those row and column template cube views. We get the below error and are curious what else could be issue as we have checked values of parameters and they are pulling in values expected (names of templates). Thanks!Narrative Reporting Parameters
I'm currently using the Narrative Reporting MarketPlace Solution on OS version 8.4 and have successfully integrated Cube Views, Content, and other artifacts using QuickParts. However, I'm facing several challenges: Member Prompts on Report Checkout/Edits: Despite configuring parameters at both the report and report group levels, I continue to receive member prompts from the cube view every time I check out or modify a report. This differs from the expected behavior in guided reporting and dashboards, where parameters are supplied automatically. Is this expected, or is there a workaround to prevent these prompts?
