Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX query max size Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 1:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 02, 2011 12:18 AM
Points: 1, Visits: 31
Hi folks,

I am presently working on a scenario where in the query size keeps increasing based on the number of input parameters i receive from .Net developers.

I wont go into the scenario now. My question is - Is there a maximum size limit for am MDX query?(not size of result set). The size of the query itself.

If so, please suggest a way around it. Any help here would be appreciated.

Thanks,
Nitin
Post #1063359
Posted Wednesday, August 29, 2012 6:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 31, 2013 10:19 PM
Points: 5, Visits: 60
Hi budy,

there is no size issue if you are using MDX directlly but if you are executing mdx using store procedure than there is some limitation like(MDX should not be greater than 8000 char).

So if your quey is more than 8000 char you need to create a clr function which take your MDX and connection string (to connect SSAS cube) as a parameter using ADO.NET. Using CLR there is no limitation of query size...

Thanks
Binayak
Post #1351572
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse