dbTalk Databases Forums  

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

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problem execute a MDX in ASP, but in mdxsample this mdx execute good in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gboniscontro@comsoft.com.ar
 
Posts: n/a

Default Problem execute a MDX in ASP, but in mdxsample this mdx execute good - 05-10-2004 , 11:08 AM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.