Forum Discussion

dbarkhol's avatar
dbarkhol
New Contributor
4 years ago

Convert Essbase @SUMRANGE

Hi OS gurus. Hoping to get a little help on converting a Hyperion line of code that is using SUMRANGE to OneStream. Here is the Essbase line I am trying to convert: IF(@ISMBR("Assoc Ex Elim")) ...
Finance
ckattookaran's avatar
ckattookaran
Valued Contributor
4 years ago

You will have to use an Eval buffer to do this. Inside the eval buffer, you can check for the UD and perform a cumulative sum.

  • dbarkhol's avatar
    dbarkhol
    New Contributor
    4 years ago

    Thanks Calvin. Would this Eval in a buffer reside in a business rule and then we would
    call this BR within our dynamic flow member within the rest of code?

    Most examples I have seen, including in your OS Planning book page 67, seem
    to show this CalculateWithEval in a BR. I haven't really seen this in a dynamic Flow or Account member so this is why I ask.

    Thanks again.

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      You can use EvalBuffer on a member formula as well. Yes, we took an approach of not using member formulas in Planning as most of the Planning solutions are like that. Search for OnEvalDataBuffer and there is one example of that in the documentation.