Dependent parameters in a spreadsheet having cube view connection
Hi All, We have a technical blocker for one of the report in our planning application. This report has UD2, UD3 and account as parameters. On the dashboard, this report appears fine when user seamlessly selects the parameters from the interface. There is some dependency between these user selection options which is handled through XFBR rule. For a specific UD3 member, a certain list of UD2 members will appear for selection, for another UD3 member a different set of UD2 members will show up and so on. We have the same report available as an offline report having the same cube view connection. In the spreadsheet, this dependence is causing a blocker and parameter pop up for UD2 appears blank showing no options for user to select values. Kindly guide us on how this dependence of parameters can be handled in the spreadsheet having the same cube view connection.
Unable 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!
Customize Dimension Filter based on Fiscal Year Period
SOURCE: ONESTREAM CHAMPIONS Hi Team, we have a situation in which we need to create a new dimension every month, and can obsolete the earlier one for the next period, that works perfect. no Issue here. but since they share the common workflow, in the Entity Filters both the old Dimension and New Dimension are appearing. Expectation here is to get Display on the New dimension in the current period and only the old dimension in the previous filter ( Refer screen shot for more clarity ) Since the filter is based on Entity calculations, not sure what’s the solution to achieve the same. I need some inputs to get the filter dynamically listed based on the Year / Period we choose. Regards Darpan BhansaliCubeView 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
Parameterize dimensions in Business Rule and then in cell format of the CV
Hello!! I am trying to parameterize all the dimensions within a business rule. I am doing this because I want to use that business rule in the cell format of a cube view to make it dynamic. If passing the rule parameters within the cell format of the cube view works, I will include an image: However, when passing the parameter in the cell format of the business rule, the statement is not working: The parameter is created as a literal value type. Could it be that it's not working because of the |CV|? Attached is an image of the parameter. I hope someone knows how to solve this. Thank you in advance :))
Nested parameters to return one value
I am building a report that uses a nested parameter. This report will run on a dashboard within Guided Reporting if it makes any difference. My parameters are Member List types. EntityParam1 uses a member filter of E#Corporate.ChildrenInclusive. This is controlled by a combo box on the dashboard. Let's pretend the user selects E#Legal as the value for the combo box, one of the children of E#Corporate. EntityParam2 has a member filter of |!EntityParam1!|.ChildrenInclusive.Children The member filter I want it to return is E#Legal.ChildrenInclusive.Children When I run this nested parameter, it runs E#Corporate.ChildrenInclusive.ChildrenInclusive.Children, which throws an error at some point. How can I use EntityParam1 to only return the E#Legal member for my nested filter? I would think the answer lies within a literal parameter but haven't found a method that automatically uses the selected value of my first parameter. Thanks in advance.
Book - Pass Input Parameter to Loop?
Is there a way to pass the Required Input Parameters for a book into a loop? For example if the users picks 2024M3 for time I want to be able to produce a report for that period as well as a report for -3 months and -12 months. I can getT#POV, T#PovPrior3, T#POVPrior12 to work but I would like to use the input time instead.
How do I make 2 combo-boxes dependant on one another?
We have summary dashboards with a lot of information. I'm trying to find a way for users to filter down on that information and have created 2 combo-boxes. However, none of the data pulls through. How do I make those combo- boxes (parameter values) dependent on each other? The idea is when a user selects the first "Resort" box only that resort's projects will be shown in the dashboard. Secondly, the second combo-box "Entity" would only return the entities from within that resort selected (step 1). Currently, no data pulls in when either parameter is selected. If I remove either of the combo-boxes, leaving only one, it works properly.
