Hello, Is someone using cfquery to retrieve data from MS Analysis Services cube? I configured the JDBC Driver from CDATA and added a Datasource, and it says OK when I test the connection, but when I run a MDX query it is not accepting the "{" for example this MDX statement

select {[ProductWeek].[ProductWeek].[Week]} on columns,{[Product].[Product].[Product]} on rows from [MedTech]

Throws this error

Malformed SQL Statement: Unexpected token encountered: [{]. Statement:select {[ProductWeek].[ProductWeek].[Week]} on columns,{[Product].[Product].[Product]} on rows from [MedTech]