File this under:
HOW DID I NOT KNOW THAT?
I have been selling the Essbase SQL interface short for many years. Apparently, if you put everything into the top SELECT window, you don't have to put any code into the FROM and WHERE windows.
I have been performing complex SQL in SQLNET clients and spooling them to text to be picked up by load rules precisely because I was told that Essbase' SQL interface could not do the complex queries. I always thought it was a stupid waste of and ODBC connection if all one could do is simple selects, and I have gotten on the nerves of more than one DBA whose indignation at the suckitude of such an interface was righteous. It turns out that, at least in 9.3.1 and above, the SQL interface can handle the complex stuff. You just put it all in the top window.