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
security 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. Thanks
Report 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.Dashboard: 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?
Looking for a way to report Workflow Profile properties/attributes
Just wondering if anyone out there has figured out a way to report the attributes/properties of a Workflow profile. What I'm actually trying to do as part of a security overhaul is determine WHERE a particular security group is actually being used. I am using the XFGetMemberProperty() function to pull security for all of my dimension members but I need a solution to pull the security groups used in each of our FPA workflows. There is no built in security dashboard report to provide this and the best advice I've received so far is to download the application and search for the security groups there. That's one way, but we literally have dozens of security groups set up so it'll be a long and manual effort. Would love to hear from anyone who's found a better way to do this. Thanks