Cube view dimension Hierarchy in reverse order with expandable option..
Hi team, is there a way to get the children of a member above the its row with expandable and collapse option. I know we can use the TreeDescendantsInclusiveR but we are not able to have an option for expanding and collapsing the hierarchy for example I want the expandable option on BUYBCK_MGN with expanding above in the following imageUsing XFBR String Service in WS Assembly
I'm new to WS assembly - trying to get a simple example of setting up an xfbr and use it in a cubeview but not successful. Here's what I did - what did I do wrong? 1. Set up XFBR String Service: 2. Then set up factory: 3. Then added to my maintenance units & workspace 4. Added to cv: => I get this error. Not sure why it is looking for the service factory in default. I followed the design guide, tried all the following syntax, none have worked: XFBR(Workspace.Reporting.myAssembly.Time, SayHello) XFBR(Workspace.Current.myAssembly.Time, SayHello) Thank you.
Trend Analysis Capabilities Comparison
Hi OneStream Team, I’m gathering insights on trend analysis capabilities across EPM platforms and would love to understand OneStream’s differentiators. Specifically: What capabilities does OneStream offer for trend analysis, such as predictive forecasting, scenario modeling, and visualization? How do these features compare to those offered by other EPM solutions like SAP, CCH Tagetik, and others in the market? Could you please share any relevant materials, documentation, or best-practice examples demonstrating OneStream’s approach to trend analysis? If you have comparative insights or vision statements (e.g., an “Art of the Possible” deck), that would be extremely helpful as well. I love the Genesis topics on this one, but I am looking for the official OneStream position. CheersScenario 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?Genesis includes pre-built trend analysis templates:
These templates can be customized or extended without requiring a complete start from scratch. Wow, I saved hours using these. 12/24/36-month income statement trend YTD vs PYTD performance trends Forecast accuracy trend analysis Variance and driver-based analysis visuals
