Returns information about individual Essbase workspace options.
EssVGetGlobalOption(item)
ByVal item As Long
Number indicating which option is to be retrieved. item cannot be Null or Empty. Table 8 indicates which options are returned for which number.
Table 8. Item Number Options and Return Types
Item | Option | Return Data Type |
---|---|---|
1 Info, Warning & Error messages | ||
Enable double-clicking to browse Linked Reporting Objects setting | ||
Returns a number or Boolean value indicating the state of the requested option. If an error occurs, #VALUE! is returned. If item is not between 1 and 10, #NUM! is returned.
This example sets the option for specifying a message level and checks whether the value set is valid.
Declare Function EssVGetGlobalOption Lib "ESSEXCLN.XLL" (ByVal item As Long) As Variant Sub GetGlobal() Dim X As String X=EssVGetGlobalOption(5) If X="#NUM!" Then MsgBox("Invalid item ID specified.") Else If X="#VALUE!" Then MsgBox("Error. Option could not be found.") Else MsgBox("Message level is set to " + X) End If End If End Sub