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 Vega
Dashboard Report - calculating % on Group Sum values
Hi all, I'm trying to figure out how to insert a field within my report's Group Footer that would perform a calculation on other Group Sum fields. In my Group Footer, I'm summing up Contract Amount and Contract Margin fields from the Detail band. I would like to calculate the Margin % based on these sums and have no idea how this is done. Any advice would be greatly appreciated! Cosimo
Bi Viewer not rendering charts when it refer in Dashboard (V8)
Hi, we are in the process of migrating into V8. while testing some of the dashboard we observe that BI Viewer is not rendering charts when it refers to dashboard. when running alone BI Viewer it is working fine. can you anybody please help me this on priority . is there any option to enable? working fine on 7.1. Thanks.
Cube Views: Taking Date from an Entity Dimension Text Field to Calculate Months to Date
I am trying to calculate months to date in a cube view column based on a date entered in a text field within Entity Dimension members. The text field would display in one of the columns on the cube view report, and the goal is to effectively subtract the current month from that date's month to derive a total months to date calculation in another column. Any thoughts on how I can do this?IC Matching Partner Detail data format
After upgrading to v8, we seem to have lost the comma formatting that was there on the standard IC Matching Partner Detail report. Is this something that I can change, and if so will I need to do this anytime there's an upgrade? I can't find where this setting resides.
Chart drops to zero instead of showing no data
Hi, A dynamically calculated KPI returns "Nothing" for future months in the Actuals and therefore I expected the line in the advanced chart to stop at the current month. However, it's not doing that, instead it is dropping to zero, creating a rather undesirable effect. I can't imagine that this is the default behavior of OneStream. Am I doing something wrong? Did I overlook a setting or is there another way to prevent the drop to zero for non-existing data?