Hello All,

   Am trying to find a solution were I can automatically convert my MDX queries to SQL queries, Is there any existing tool for that ??

Can anyone tell me atleast how would be possible to achieve something like this.

Regards,

Bharath

Bharath_Ram

Hi Bharath,

In Analysis Services, MDX is used to query against cubes or other multidimensional objects on OLAP server. T-SQL queries tables/views under relational database. These two type of queries share similar syntax, but the structure and the target object for these two queries are different. See: Comparison of SQL and MDX.

Even cubes are built based on relational tables, it's still not possible to convert a MDX query to T-SQL query and get the same result. We can only use linked server to get the result set from MDX query in T-SQL. Please see: How to perform a SQL Server distributed query with OLAP Server.

Regards,