(agarwalshuchi@gmail.com) writes:
> Now i execute the entire statement as
>
> exec('SELECT a.* FROM
> OpenRowset(''MSOLAP'',''DATASOURCE="RAPID-CHRISTUS"; Initial
> Catalog="MRS";'',' + @mdx1 + mdx2 ') as ' )
>
> Still error comes that :
> Unclosed quotation mark before the character string 'WITH MEMBER ..
>
> ('With member' is the starting statement of my MDX query)
>
> Is there any other way to connect to OLAP server and execute an MDX
> statement with a Length greater than 8000 chars

Have a look at http://www.sommarskog.se/dynamic_sql.html#OPENQUERY
for some tips.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx