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.
Similar Threads

  1. Can connect to sqlexpress via asp.net but not via asp

  2. is there a good sample showing how to build data warehouse with possibility to fetch good rest from

  3. AS2005: Looking for a good MDX formula to do this...

  4. I set my database to trustworthy and deployed this clr stored proc as unsafe ok but when i run this

  5. Does anybody know of any good books on ASP.NET Membership and the Login controls?

Loading...