Forum Discussion

Oscar's avatar
Oscar
Contributor
3 years ago

UD8 Calculate Variance Between Two Scenarios in Cube View

We are trying to calculate the variance between two Scenarios using an UD8 member. In Essbase, the calculation below works just fine, but in OneS it returns an error. Any improvement to the formula is appreciated.

 

Cube View
  • Oscar's avatar
    Oscar
    3 years ago

    Thank you all for your contributions in trying to resolve this issue ... I got the U8 member to work as expected but I am perplexed as to why the system is behaving in this manner. Basically, all I did was to switch the Formula Type to (Not Used) .. Hit save, then switch it back to DynamicCal .. Hit save

    I then went back to my formula and it compiled successfully ... 

     

    It is very weird that I have to change the attribute to get the system to recognize that the member is a DynamicCalc

  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor
    3 years ago

    Hello! 

    Does it need .CellAmount after the formula? 

    Return api.Data.GetDataCell("S#Actual - S#TieOut12").CellAmount

    I'm not the best at vb.net but this is what all my UD8 calcs have at the end so worth a shot. 

    • Oscar's avatar
      Oscar
      Contributor
      3 years ago

      Hi Nicole!

      Thanks for the input, unfortunately, it fails to compile and returns the same error.

  • ckattookaran's avatar
    ckattookaran
    VIP
    3 years ago

    You need to use the UD8 for both scenarios. Is there anything else in the formula?

  • Koemets's avatar
    Koemets
    Contributor
    3 years ago

    Oscar, they are 2 types of processes in BRs (among others :)). One is a function and another is a sub. Function returns a value, hence they must end with Return, even it's a Return Nothing.

    Sub is a subroutine, that runs in the background and not supposed to return anything. Hence the error on "return" line. So in this particular instance you should either run the variance in cube view or create bogus member to write the variance data into, such as api.data.calculate("A#Bogus = A#1-A#B")

  • Oscar's avatar
    Oscar
    Contributor
    3 years ago

    Thank you all for your contributions in trying to resolve this issue ... I got the U8 member to work as expected but I am perplexed as to why the system is behaving in this manner. Basically, all I did was to switch the Formula Type to (Not Used) .. Hit save, then switch it back to DynamicCal .. Hit save

    I then went back to my formula and it compiled successfully ... 

     

    It is very weird that I have to change the attribute to get the system to recognize that the member is a DynamicCalc