MDX query max size

  • 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

  • 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

  • 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