I am working on something this morning with the Java API and found something to be a bit touchy and, of course, thought I would share it in case someone else runs into something similar. Specifically, I was using the IEssCube.queryMembers() method which very quickly returns member information. This function is the Java version of the VB API EsbQueryDatabaseMembers and C API EssQueryDatabaseMembers functions.
Those API calls use a query language that is similar to, but different than, Essbase report scripting language. In this scripting language, spacing matters. Here is a screenshot of something that didn't work:
Note there is no space between the FORMAT and {MBRNAMES} clauses in the query. I added a space and here is the result:
In this case, the API correctly returned the ancestors of Connecticut.
Lesson: Be aware that spaces can be important, in some places, when working with Essbase.