Cannot connect to OLAP cube when viewing data at lowest dimension via ASP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

Thanks,
Randy Ly
rly4444@xxxxxxxxx

.

Relevant Pages

  • RE: dispaying nested members from same dimension on one axis?
    ... elaborate MDX in order to return only the years and relevant months then ... display above the quarter labels on the columns... ... > may be using the same MDX query to populate the UI components. ... >> i have a time dimension which has year, quarter, month, day etc all cleaned ...
    (microsoft.public.sqlserver.olap)
  • RE: Pushing the boundaries with Dynamic Dimension Security
    ... "I'm hoping to get an MDX statment like this returned(then post the MDX you ... > member of another dimension) and modify the result set accordingly. ... > then the allowed members from the secured dimension can ... > MDX query (I've tested this by using a function that queries a view ...
    (microsoft.public.sqlserver.olap)
  • Cannot connect to OLAP cube when querying data at lowest dimension via ASP web page
    ... I'm getting error message when running MDX query pulling data via ASP ... web page from lowest dimension. ...
    (microsoft.public.sqlserver.olap)
  • Re: MDX - querying different levels of a hierarchy
    ... results of the MDX. ... > I want to write an MDX query that will give me an output like this: ... > I know I need a non-empty cross join, but I'm not sure what syntax to use ... > when attempting a join on different levels of the same dimension. ...
    (microsoft.public.sqlserver.olap)
  • Re: Alternate Drill down paths
    ... We are an online casino not a land based casino ... a standard time dimension would allow you to view any one of these ... > i'd repost this under the title MDX and say you need to write this as MDX ... > like 3 days before i left; and girlfriend bought a ticket and followed me ...
    (microsoft.public.sqlserver.olap)