The Essbase Visual Basic functions and the extended spreadsheet macros return values indicating the success or failure of the function. The functions return these types of values:
0 (zero)—Function was successful. Note that a function can run successfully but return undesirable results.
1—Typically means the user pressed Esc or clicked Cancel from a dialog box.
Negative number—Function failed due to a problem with the client computer, a problem with the syntax, or a problem with the local environment.
Large positive number—Function failed due to a problem originating on the server, such as Essbase Server not running or an invalid user name.
Table 23 lists the return values for local problems, represented by negative numbers.
Table 23. VBA Return Values