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.Viewing all Metadata and values in Cube View or Spreadsheet
I am attempting to create a view in a dashboard for users to be able to see all metadata for each row with that value. Essentially I need to recreate the "Data Records" Report in the database. I would prefer not to recreate it in SQL via a data adapter, instead use either a Cube View or a Quick view in Spreadsheet. For the Cube View I can't seem to display more than 12 of the dimensions and would need 16 in the report (Cube and View aren't needed those can be in the POV). For the Quick View in Spreadsheet putting |!prm_Entity!| returns "#ERROR - The member filter contains unresolved parameters" instead of providing some sort of dialogue box to select the member. Any suggestions on how to get all dimensions into a Cube View or how to use parameters in the Member Selection in a Quick View would be greatly appreciated. Thanks
Combo Boxes Passing Selections to Other Dashboards
Hi I appear to be having a slight issue when trying to feed the user selection of multi combo boxes embedded in the main dashboard to other dashboards that the user would be navigating to (i.e. their selection on the main dashboard would be the default in the next dashboard). I can currently only get it to work for one single combo box at a time? I'm using a Dashboard Extender Rule which incorporates both the LoadDashboard function type (this is activated against a server task for the dashboard being navigated to) and the ComponentSelectionChanged function type (this is attached to each of the combo boxes as a changed server task) Any advice on this would be much appreciated or if there is a easier way to achieve it? Thanks AndyGuided Reporting Selector List Label Incorrect Position
Howdy, When using Guided Reporting, the Selector List Labels are not being positioned correctly. As shown below, the label is positioned on top of the next parameter (to the right) instead of the parameter it's associated with. Has anyone experienced this before and have a solution? Additional information: Occurs in every report when viewing in Guided Reporting Global Selector List Labels are aligned as expected Thanks in advance Mantis
Setting up default value in the combo box for Cube View
Hi Everyone, We recently received a request from the client to set up a default value in the combo box for the cube view. The cells are set with type Annotations and has a dropdown of options to be selected. The client wants to default the dropdown as PctBudget until and unless it is changed. Is there a configurable setting that can be used to achieve that? I used the default value/members under parameters but it didn't help the cause. Thanks in advance! Pragyanshu JackLacavaHenning
CubeView Parameters not Passing Correctly into a Business Rule though a Dashboard
Hello, my team and I have encountered the following unexpected behavior: District Loan Detail Dashboard On the initial display of this screen when we click "Run Drill-down" button, the 2 parameters from the Cube View do not get passed into the Business Rule correctly. As shown below in the error message: It passed in GRP_16 which was from the previous "Run Drill-down" process, instead of the selected row's value of GRP_26 (UD7: "26 - Principal", Flow: "EndBalLoad"). So on initial display, clicking on the first row, which is already selected, does nothing and passes the incorrect (previous) values from the cube view. I have to click on a different row and then back to the first row to get the correct parameter values passed to the Business Rule. If only one row is in the cube view I will never be able to return the correct results because it is passing the incorrect value. This issue has been present ever since we upgraded to version 7.3.3 from version 6.4.0. We appreciate your help, Cruz VegaNested Parameters using Bound List
Hello We are trying to build a CV where we need two parameter selections by the user. The first parameter selection needs to be passed into the second parameter. The second parameter is configured as a bound list using Method Type as Business Rule, and the first parameter selection needs to be passed as an argument in the Method Query - but the BR is not able to resolve the parameter value and is only able to read it literally. Following configuration is for the second parameter The BR is reading t1 as "|!TestingPrompt1!|" and not the actual parameter value that was selected by the user. Any ideas on how to solve this are appreciated. Thanks!
Writing a value to a cubeview cell
Hi I have a form and there is a balance sheet account, total input and validation columns. The condition is to check if the balance sheet account value has a value and total input has no value, if balance sheet account is 0 and total input has a value and total input is greater than balance sheet then validation should be 0. If balance sheet is greater then total input then validation is 1. This validation is stored in a member formula and I was wondering how can I get the validation column to show 1 or 0 based on the condition I have tried the SetDataCell() first but found out that on a member formula that does not work, which other function can be used. Your assistance will be greatly appreciated Regards
Dashboard Objects and Associated Parameters
Attached is a one tab Excel file that lists all the dashboards, with all the dashboard components and their associated parameters. This can be helpful to see where specific DB objects / parameters are used throughout our dashboards. Filtering has been turned on for the columns to assist with this activity.
