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
Cell Wise Calculation
I have 50 rows and 4 columns, here I have to do a calculation with cell wise. For eg: col4row20 = col1row1 / col1row10 col4row21 = col1row2/col1row11 col4row22 = col1row3...
I think we might be picking the wrong approach here.
CubeViews support Conditional Format statements, but that does not perform calculations (well, it can flip signs, but that's it). It also supports CubeView Extenders, i.e. custom code that can run on every intersection, but only when the CV is exported as report (because, again, it's meant mostly for formatting; but people abuse it for various things).
For calculations, you're supposed to use expansions and overrides, which are pretty powerful and cover most average needs. If those are not enough, the calculations are clearly not simple reporting operations, but full-on calculations on complex data; so the best approach becomes working with Dynamic Calc member formulas, typically on UD8 members. Those will allow you more flexibility to pull data from anywhere.
Else, is there any process to use the parameter and saying the condition like if the row name equals to ***** then perform this calculation, if its there please give me the example formula how to use that.
JackLacava
OneStream Employee
OneStream EmployeeI think we might be picking the wrong approach here.
CubeViews support Conditional Format statements, but that does not perform calculations (well, it can flip signs, but that's it). It also supports CubeView Extenders, i.e. custom code that can run on every intersection, but only when the CV is exported as report (because, again, it's meant mostly for formatting; but people abuse it for various things).
For calculations, you're supposed to use expansions and overrides, which are pretty powerful and cover most average needs. If those are not enough, the calculations are clearly not simple reporting operations, but full-on calculations on complex data; so the best approach becomes working with Dynamic Calc member formulas, typically on UD8 members. Those will allow you more flexibility to pull data from anywhere.