Set this to true to pass MDX queries to Microsoft SQL Server Analysis Services as-is.

Data Type

bool

Default Value

false

Remarks

You can execute SQL-92 SELECT queries to the views modeled by the provider; set this property to instead execute MDX queries directly to Microsoft SQL Server Analysis Services. If you are using MDX queries directly, it is recommended to also specify the Catalog to ensure MDX queries are submitted to the correct catalog.

See Retrieving Analysis Services Data for more information on querying Microsoft SQL Server Analysis Services through the provider.