Problem execute a MDX in ASP, but in mdxsample this mdx execute good

Discussion in 'microsoft.public.sqlserver.olap' started by gboniscontro, May 10, 2004.

  1. gboniscontro

    gboniscontro Guest

    The problem is the follow:
    When I execute the mdx in ASP, appear a error message : internal server error.
    but this MDX I can execute in MDX sample.

    MDX = SELECT {[Measures].[Exposure Level %],[Measures].[Exposure Risk %]} ON COLUMNS FROM [SPM] WHERE ([Time Daily].[All Time Daily].[2003].[June].[2003/06/06],[Domain SPM].[All Domains],[Organization SPM].[All Organizational Units],[Hour SPM].[All Hours SPM].[23])
    This Mdx execute good in MDX Sample but in the asp this have a internal error.
    The problem appear when I agregate in the where of mdx a member([Hour SPM].[All Hours SPM].[23]).
    if I delete this member, the mdx execute good in asp.

    Please,somebody help me.
    How I do to solve this problem??

    **********************************************************************
    Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
    Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
     
    gboniscontro, May 10, 2004
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.