We tried that option also collation compatible=true but still the query fails with the same error.This happens particulary while entering currency symbols.
We are facing the similar issue the cube processing succeeds when processing manually by right click the cubedb->process but throws an error when we process through dynamic xmla:
Microsoft.AnalysisServices.Xmla.ConnectionException: A connection...