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 image
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. Cheers
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!
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?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
