Hi,

I'm getting error message when running MDX query pulling data via ASP
web page from lowest dimension (emp dimension). This same MDX
querystring runs OK via the MDX Sample Application, but errors out when
run via ASP web page. Strange thing is that the MDX querystring will
work from the ASP web page if looking at higher dimension (supervisor
dimension).

WORKER LEVEL MDX QUERY THAT DOESN'T WORK VIA WEB PAGE:
------------------------------------------------------------------------------------------------------------
SELECT {[Measures].[Qualified Units], [Measures].[Qualified Profit],
[Measures].[Qualified Unit Profit]} ON COLUMNS, non empty {[Product
Category Description].Members} ON ROWS FROM MAIN_REPORTING WHERE
([Sales], [Fri 08/18/06], [organization].[supervisor_name],
[emp].[worker_name])

SUPERVISOR LEVEL MDX QUERY THAT WORKS VIA WEB PAGE:
------------------------------------------------------------------------------------------------------
SELECT {[Measures].[Qualified Units], [Measures].[Qualified Profit],
[Measures].[Qualified Unit Profit]} ON COLUMNS, non empty {[Product
Category Description].Members} ON ROWS FROM MAIN_REPORTING WHERE
([Sales], [Fri 08/18/06], [supervisor_name])

I've verified the permissions to the cube MAIN_REPORTING and "Everyone"
and "NT Authority/Anonymous Logon" has unrestricted permissions to all
the dimensions and measures in the cube. Again, the worker level MDX
query works on the MDX Sample App, but not via the web page while the
supervisor level MDX query works on the web page.

Have tried searching through newsgroups but haven't found anything that
will work. Appreciate any help/insight anyone can give me.

Here's error message...

---------------------------------------------------------
Error Type:
Microsoft® OLE DB Provider for Analysis Services (0x80040E14)
Cannot connect to the server ''. The server is either not started or
too busy.
---------------------------------------------------------

Thanks,
Randy Ly
rly4444 (AT) gmail (DOT) com