We use a custom app built using vb and smartview.
We recently upgraded to 126.96.36.199 and found that HYPSUBMITDATA does not send #missing to the app.
Anyone hit this issue already? If so please let me know the solution.
We have a case with Oracle and i think it will be declared a bug.
#MISSING is not a value stored in Essbase, so this is expected behavior.
This thread indicates
"Using -2.0E-15 if you need a numeric value in the cell that will not write a zero to Essbase."
I would test thoroughly before using, as I have not tried this myself.