Essbase - VBA to change global options by using essvsetglobaloption codes

[cde]

Hello all,
I have built a macro that loops through a series of workbooks, does an essbase retrieve, multiplies it by a factor, and then locks/sends the data back to the database. I have everything working great, except I'd like to tweek one thing.

When I do the retrieve, I get an essbase message pop-up that states "sheet contains unknown member...." I would like to toggle off this option under the global settings tab under "essbase options."

I've declared the essvsetglobaloption (see below). I've seen people mention there are codes that specify certain options and will turn them on and off. It seems like a simple true/false would work but I can't seem to come up with the right combination.

Declaration statement:
Declare Function EssVSetGlobalOption Lib "ESSEXCLN.XLL" (ByVal item As Long, ByVal globalOption As Variant) As Long

I can paste the code in if necessary, but what I have doesn't really help with the question. I'm more than happy to share the code that does the loops/retrieve/lock/send if you need it.

Thanks in advance for any responses/help.

 

[BrianB]

Don't know really. not used Essbase for years.
I have a user guide dated 1994 that has
EssSetGlobalOptions(rightmouse,doubleclick,flashback,mbrSelect,messageLevel,display unknowns,createlog,purgelog)

messagelevel prameters :
1 display all
2 error & warnings
3 error
4 none

Example (not sure how to use this)
=EssSetGlobalOptions(true,true,true,false,4,true,true,true)