Cube View Time Out issue
Hello Team, I'm experiencing performance challenges with a CubeView that contains: 4 row dimensions (all using .base members) Multiple time period columns Dynamic calculations that are causing significant retrieval delays Current Challenge: The CubeView needs to be executed and its data exported externally, but the dynamic calculations are making the retrieval process extremely time-consuming. Attempted Solution: I've already tried converting the dynamic calculations to stored values using finance rules, but this approach has proven ineffective - it's still taking excessive time and not producing the desired results. Request: Could you suggest any alternative approaches or optimization strategies to improve the performance of this data retrieval and export process? Thank you for your assistance.
Cube View sum of columns sums only values from column with first child
Hi everyone, I'm having an issue with a cube view. I have a column whose parameter is E#GroupEntity.Base. When launched, it shows one base entity per column, with its respective data. I need to place a new column at the end of the cube view that sums the values of all the base entities. I tried to use the CVC function to sum columns, but it only sums the data of first base entity, ignoring all the other base entities. Is there a way to achieve what I need, and if yes, could someone please help me? Thank you!
Cube View Cash Flow Report QTD or MTD
Our cube view cash flow reports were built using an account hierarchy and includes parent cash flow accounts to rollup base accounts. The cash flow reports were originally built on a YTD basis. Later the view parameter was changed to also generate cash flow reports on a QTD or MTD basis. The QTD and MTD cash flow reports reflect the correct calculated movement of balance sheet accounts for the parent cash flow accounts, but still reflect YTD calculated movement for the base accounts. Any income statement accounts included in the cash flow reflect the correct YTD, QTD or MTD amounts for the parent cash flow and base accounts. OS Community - Does anyone have a similar cash flow report build including options to generate the report QTD or MTD and solved obtaining QTD or MTD balance sheet base account calculated movements?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?
Time Sorting order issue in BI Viewer
Hi Team, I have attached CV in Data Adopter (Type "CubeViewMD"). in CV Time dim is at columns(T#YearPrior1(|CVTIme|).Quarters, T#Year(|CVTIme|).Quarters, T#YearNext1(|CVTIme|).Quarters) & Entity dim is at rows. (My CVTime = 2026M3). when i ran Cv i am getting 2025, 2026 & 2027 quarters. but when i ran the same CV through BiViewer time is not sorting properly. Can you please help us to resolve the issue.
