The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
business rule BR for a column (e.g. K) to Accumulate what is in another column (in Cubeview)?
OneStream is the best EPM app for consolidation and everything planning - it is going to kill Hyperion / Essbase !! Does anyone have a sample business rule BR for a column (e.g. K) to Accumulate wha...
As it turns out, I had to write a new BusinessRule.Finance.XFR_CV_BR_Accum_colum
Here's the heart of the code:Dim cellVal As Decimal = api.Data.GetDataCell("U1#" & api.Pov.UD1.Name).CellAmount
' add accumulative value to current cell value
accumVal = accumVal + cellVal
GetDataCell(CVC("Insert column name") + CVC("Insert column name"))
This is a small script you can write in the actual cube view column member filter which will perform an on-the-fly calc.
As it turns out, I had to write a new BusinessRule.Finance.XFR_CV_BR_Accum_colum
Here's the heart of the code:Dim cellVal As Decimal = api.Data.GetDataCell("U1#" & api.Pov.UD1.Name).CellAmount
' add accumulative value to current cell value
accumVal = accumVal + cellVal