Post reply

MDX query max size

  • February 14, 2011 at 1:56 am

    #157441

    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

  • August 29, 2012 at 6:40 am

    #1531352

    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

  • May 22, 2016 at 8:55 pm

    #1880658

    This helped me:

    https://olapextensions.codeplex.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply