Dashboard - Time Parameter for Specific Cube Views
Hello - I have a dashboard with 6 buttons across the top - each one is set to display a different cube view. The time dimension for 4 of the CVs are set to workflow time, where the other 2 I want the users to be able to select a period from a list, because these 2 are designed to show historical variance commentary. I set up a member list parameter with the time periods and added it to the two cube views. Now when I open the dashboard, the prompt automatically appears for every CV. I checked and couldn't find a way to only have this prompt appear for the two cube views. What settings do I need to enable or disable for my dashboard so 4 out of the 6 run off workflow time, but when a user clicks a button for one of the 2 others, the time period prompt appears?
Double Line Formatting
Hello, We currently print out a book to our general managers every quarter and our reports formatting seemingly changed without us changing. We use double underlines as our totals and previously it worked fine, but this quarter it looks like a solid line, but when you zoom in, you can see it's a double line. Is there any way I can fix this? I've tried changing the ReportBottomLine1Thickness and ReportBottomLine2Thickness size, but with no luck. Any suggestions? Thanks, Will
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.
How to create a text box in Dashboard - text is dependent on WF Scenario
Hi, I have created an admin dashboard for forecast. I want a text box that shows parameter values, but there is a separate parameter for each Scenario. Scenario Parameter Forecast_Mar CopyLatestActualsToFCT_Mar Forecast_Jun CopyLatestActualsToFCT_Jun Forecast_Sep CopyLatestActualsToFCT_Sep Forecast_Dec CopyLatestActualsToFCT_Nov CopyLatestActualsToFCT_Dec The parameter has either value False/True and depending on the value, the business rules that are initiated via the dashboard will do different things. The dashboard is shared between the WFs/Scenarios. How do I create a text box that gives me the parameter name and value? e.g. when I use WF Forecast_Mar I want the textbox to say: "Forecast_Mar = (Value)" December has double parameters why I need both to be shown, "Forecast_Nov = (Value), Forecast_Dec = (Value)". Is it possible to do this using standard functionality for parameters (e.g. create a new parameter that picks the values from the others that I then link in my dashboard). I have tried to create a BR, but I couldn't really get it to work in a good way and then something happened in OneStream so it reverted almost everything I had written in the Business rule.
Guided Reporting Duplicate Param Dialogue Box Showing on Run or Param Change
Hi OneStreamers, I'm currently working with the Guided reporting solution in OS v8.4.0. When running the report in the GDR homepage a duplicate dialogue box appears after the Guided Reporting Dashboard is selected via the OnePlace menu item, once a report is selected, or after a Parameter is changed anytime the Parameter combo box is changed. Each Parameter is set up a Member list at the moment but were previously discovered as Member Dialogue, and now rediscovered as the updated Member list param. Any Idea what I could be missing?
Guided Reporting - Multiple Extensible Hierarchy Selection - List Selector Error
I have a Cube View report in Guided Reporting where the user needs to be able to select from anywhere inside of the following three hierarchies. The hierarchies contain extensibility. I am running into an issue where the hierarchies are not appearing correctly, and member are missing in the 'List Selector' on Guided Reporting. I created my parameter to pull the tree views of all three entity hierarchies. I have confirmed that the Cube View parameter selection shows up as expected. When I try to select Entity in Guided Reporting, I see the following: The only items that are showing under the tree views are the members that do not have any extensibility. Output is showing its children, but it is not collapsable to the parent. If I switch the order over the tree views in the parameter, whichever is the last one listed has its members listed out like Output does in the screenshot. I have tried multiple different ways to write the parameter out and have been unsuccessful. Has anyone else experience this issue? Is there any way to get the hierarchies to display correctly? I am having trouble since the code behind Guided Reporting is locked by OneStream. Thank you!
