We've been testing the performance of SSAS 2005 ROLAP cubes against a
large Oracle data warehouse. One of the problems we've noticed is that
the queries SSAS generates use variable binding. With long running
queries variable binding is very often not the best option with Oracle
or DB2.

So for example a query like

SELECT <bunch of stuff> FROM <tables> where Time.Year = :1

performs much worse than

SELECT <bunch of stuff> FROM <tables> where Time.Year = '2004'

In some of the tests we've been running the first query takes 10-15
minutes, the second takes 60-80 seconds.

Is there any way to configure SSAS not to use variable binding?