Scenario management for FX
We are in the design and build phases of OneStream and it is really important to me that we get the foundation right and use OneStream the way it was intended to be used. What are the recommended design solutions in OneStream to enable users to quantify the FX translation impact separate from performance when comparing one period of time to another (e.g., YTD actuals versus budget or full year latest forecast versus full year budget). Hi HFM we do this through recalculation scenarios. For example, we have the following budget and forecast scenarios. 14 forecast scenarios - one for each month, one to recalculate the prior forecast at the most recent actual rates (used for comparisons against YTD and month actuals), one to recalculate prior forecast at the forecast rates (used for full year comparisons to prior forecast and full year budget). The latter two get overwritten every month with the latest previous forecast data and new rates. 3 budget scenarios - one for the original budget, one to recalculate the budget at the most recent actual rates, one to recalculate at the latest forecast rates. The latter two get overwritten every month with the new rates. The process works well in HFM. Should we design the same solution in OneStream? How do other people manage this?14Views0likes0CommentsPowerBI Custom Data Adapter
I have built a OS data adapter off of a cube view that has a parameter that prompts for entity. I subsequently built PowerBI query to pull data via this data adapter. I can get the PowerBI query to pull data if I hardcode the Entity parameter value in the Custom Subst Vars in PowerBI. What I would like to do is replace hardcoding the Entity value with list prompt for the user. That will let the user decide which entity they want to pull when they refresh the query. Any ideas on how to create this functionality? #PowerBI13Views0likes0CommentsDynamic Dashboard fails to load Embedded Dashboards via parameters
Hello, I'm using OneStream version 9.0 and have built a dynamic dashboard that serves as a container to display other dashboards. The dashboards being displayed were created in older versions of OneStream and use parameters to define embedded dashboards. When I try to open these dashboards within the dynamic dashboard, I get the following error message: #ERROR: Unable to open embedded dashboard '[dashboard to display name]' while processing component '[my embedded dashboard component]' The dashboard to display name is correct, so the parameter seems to be working. Also, when I open these dashboards directly (outside the dynamic dashboard), the embedded dashboards display correctly. Is it still possible to use parameters to define embedded dashboards within a dynamic dashboard in version 9.0?Solved22Views0likes2CommentsCreate new Documents in Narrative Reporting
Hi, I am attempting to upload files for our Narrative reporting and I am failing miserably here... I would like a CubeView report in either Microsoft Word or PowerPoint. I have following the instructions online within Word to Insert >> Field >> DocVariable and input the Syntax as instructed: I add it to my Narrative files and keep getting errors about parameters. I went as far to change the report so there are no parameters and all the dimensions are defined within the CubeView. Any ideas what I could be missing? Or does anyone have an example of what they used for their syntax and uploads? I can't seem to find this initial step.22Views0likes0CommentsWfTime parameter not working in SQL table editor
Hi everyone, I'm currently working on a dashboard that, through the use of a SQL table editor, will show data stored in a table. Below an example of one row from that table: The interface of the SQL table editor allows me to filter the data to show only specific rows, and I added a filter for the columns T_ENTITY and PERIOD: The first filter (T_ENTITY) works as expected. The second filter should filter out those rows in the table whose Period differs from the one selected by the user in the WF. Nevertheless, if I use |WFTime| as parameter, it doesn't show any row, even those that have the same Period as the WF. If I instead replace |WFTime| with the static period (es 'PERIOD = '2022M11'), it works fine. The conclusion I take is that |WFTime| is not equal to the current WF period. To check that out, I added the following label to the dashboard header, setting its value equal to |WFTime|: and it shows exactly the current WF period: Is it possible that the parameter |WFTime| does not work as a filter for a SQL table editor? Or am I missing something? Thanks in advance for the help!Solved118Views0likes3CommentsHow can I become a Advanced User of Member Filter Builder in QuickView
I am a Financial Planner and Analyst and My Organization use OnStream. I want to understand better how to extract the data for Multiple scenarios (act, fcst, budget, py) using Member filters, variables understand workflows, and parameters?34Views0likes0CommentsReports using Multiple Cubes
Hello, Would it be possible for me to generate a CubeView using multiple cubes? I know it would be possible using an XFGETCELL since we have to point to the specific cube in the formula. We are currently utilizing a single cube with all the parent and base level members in our dimensions and are transitioning into 2 Cubes (1 for the summary/parent level and 1 for all base level members). Our existing reports for example A#NET_INCOME.treedescendantsinclusive would work fine in our single cube, but it may not work when we move the parent & base level members to separate cubes.Solved48Views0likes1CommentHow do I return a range of Members?
We have a large flat hierarchy, members starting with Px_1000 to Px_9999. For example, P1_1000_27 Project 1, P5_1001 Project Yellow.... P7_9999 Project Bob. The numbers are unique (no two same number). We want a report that allows users to enter a "From" - "To" to pull back members in that range. For instance, only pull back members in the range "From" 500 To "532". Have an XFBR where I'm parsing the string, that's working, looping through and but only returning the number. The issue is that I need the entire string and description of the member. That's where I'm stuck. If anyone has done this before, would very much like know how you coded the XFBR. Thank you!Solved86Views0likes4CommentsHow do I remove parameter prompts from WF?
I am using a Cube View (IS) within a dashboard. The client does not want users to be prompted with parameters for selecting Entity, Time, or View. Instead, they expect these dimensions to be driven automatically by the Workflow Point of View While I’ve successfully applied WF Time and View dimensions in the CV to align with the Workflow POV, I’m encountering an issue with the Entity dimension. It does not respond to the Workflow POV such sd WF, WFProfile, etc.. I either have to hardcode it, or use the Parmeter. Can I create a parameter that does not prompt a user make a selection?50Views0likes3Comments