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.Issue Passing Parameters to Custom BR Function in Cube View Member Filter
Hi All, I'm currently working on a Cube View where I need to use a custom Business Rule function (CalculatePer) within a member filter for ColD. The goal is to calculate values dynamically based on inputs from ColA and ColB. To help illustrate, here’s a simplified version of the layout: Sample Cube View: ColA ColB ColC ColD 100 150 250 ? 20 -50 -30 ? 30 0 30 ? 0 30 30 ? Column Definitions: ColA → T#|CVTime|:Name(XFBR(Fin_XFBR_Consolidations, GetLastDayOfMonth, Param_SelectMonth = |CVTime|)) ColB → T#YearPrior1(|CVYear|)M12 ColC → GetDataCell(CVC([ColA]) - CVC([ColB])) ColD → Intended to call a custom function using values from ColA and ColB. What’s Working: When I use the BR without parameters, it works fine: GetDataCell(BR#[Fin_GlobalHelper, CalculatePer]):Name(%) What’s Not Working: When I attempt to pass the values of ColA and ColB as parameters to the function, like this: GetDataCell(BR#[Fin_GlobalHelper, CalculatePer, A=GetDataCell(CVC([ColA])), B=GetDataCell(CVC([ColB]))]):Name(ColD) …it does not work as expected. The function does not receive the evaluated values properly, and I believe the nested GetDataCell() within the BR#[] call is causing the issue. Attempted Alternative: I also tried passing values directly using CVC(): GetDataCell(BR#[Fin_GlobalHelper, CalculatePer, A=CVC([ColA]), B=CVC([ColB])]):Name(ColD) The parameter evaluation is not be happening correctly in this context and so the function is not called. below is the custom function; Custom Function (Business Rule Code) Below is the code used in the Business Rule (CalculatePer) for reference: Select Case api.FunctionType Case Is = FinanceFunctionType.DataCell If args.DataCellArgs.FunctionName.XFEqualsIgnoreCase("CalculatePer") Then brapi.ErrorLog.LogMessage(si, "Inside CalculatePer: ") Dim ColCP As String = args.DataCellArgs.NameValuePairs.XFGetValue("A") Dim ColPY As String = args.DataCellArgs.NameValuePairs.XFGetValue("B") Dim A As Decimal = api.Data.GetDataCell($"{ColCP}").CellAmount Dim B As Decimal = api.Data.GetDataCell($"{ColPY}").CellAmount brapi.ErrorLog.LogMessage(si, "ColCP: " & ColCP) brapi.ErrorLog.LogMessage(si, "ColPY: " & ColPY) brapi.ErrorLog.LogMessage(si, "A: " & A) brapi.ErrorLog.LogMessage(si, "B: " & B) If A > 0 Then Return A Else Return B End If End If End Select Request: Could you please advise on the correct syntax or method for passing evaluated column values (T# tokens) as parameters to a BR function in the Cube View? Any insights or a working example would be greatly appreciated. Best regards, Archana
