04-07-2022
01:25 PM
- last edited on
05-24-2023
11:34 AM
by
JackLacava
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.
Solved! Go to Solution.
04-11-2022 12:35 PM
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
04-07-2022 03:36 PM
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.
04-11-2022 10:12 AM
Hi Nicole!
Thanks for the input, unfortunately, it fails to compile and returns the same error.
04-08-2022 03:09 PM
You need to use the UD8 for both scenarios. Is there anything else in the formula?
04-11-2022 11:47 AM
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")
04-11-2022 12:35 PM
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