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 Vega89Views1like1CommentNested 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!514Views0likes7CommentsWriting 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 Regards153Views0likes1CommentDashboard 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.Conditional Statement in the Cube View Columns
Hey All, We got a recent requirement of implementing a conditional statement inside the cube view columns. The user wants to calculate a certain column on the basis of the value of another column. The design is explained below: If B <> 0 then D= B+C else if B = 0 then D= A+C A B C D 10 100 20 120 (100+20) 20 0 130 150 (20+130) 0 20 30 50 (20+30) I'm currently facing difficulty to implement this solution inside the cube view. My first shot was trying something in the XFBR string but that I couldn't get around the logic to implement the same. Any leads will be appreciated. Thanks! Pragyanshu Bansal JackLacavaOSAdminSolved185Views0likes2Commentssecurity based combo box
All, We currently have a combo box (with entities) in a dashboard but we would like to make this list a bit smaller and based on the security rights a users has. I want to solve this with a XFBR which i afterwards attach to a parameter and that parameter in a combo box. Does somebody has an example of this XFBR code which i can look into? Or is there a better way to do this. Thanks89Views0likes1CommentReport components: Can parameters be passed by clicking on a value in a report
Are report components (report designer) drillable when using vStageSourceandTargetDataWithAttributes? I want to be able to click on a value in a report component and it provide detail specific to that value. I know this can be done with cube views and other things where bound parameters are passed. Can I do the same for report components? If so, how? I can easily get the detail but I want it to be specific to a value in the report.153Views0likes2CommentsDashboard: Combo box with bound parameter
Hi, I have set up a combo box that uses Bound List parameter "WfProfile_AssignedEntities" with defaul value WFProfile_AssignedEntities. Even though the default value is set, when I use it in the dashboard, it default to empty space and a drop-down where I need to pick up my workflow profile assigned entity. How can I make to show a workflow entity without needing to go in drop-down and pick up it from there?22KViews0likes47CommentsConditional Visibility of Button Based on ComboBox Selection
Hi, I need help implementing conditional visibility for a button in my dashboard. In the attached image, there's a Store button that I'd like to make visible only when the "Single Store" option is selected in the Store Hierarchy combo box. When any other option (e.g., "All Stores," "Takeovers2024FY," etc.) is selected, the button should either disappear or have a different style to appear disabled. Can anyone guide me on how to achieve this behavior? Thanks in advance!Solved232Views0likes2CommentsCreate Parameters for Member Filters...where to start?
Hi, I am creating a report for our auditors that takes the IC accounts and their elimination "Plug" account throughout the Origin dimension. I don't want to create a bunch of separate reports for AP/AR, Sales/COGS, IC Expense, etc. My thought is to define these in a Parameter and then build a book. Can anyone point me to a good starting point on how to define these 4 different drop down options? For example, the AP/AR one would include A#19999, A#29999, and A#IC_DIFF, and the report user would select AP_AR_DIFF or something like that. Any insight is appreciated - the forum has been very helpful! Thank you!Solved393Views0likes4Comments