MySQL Query Processing in COGNOS

I have just set up a connection in COGNOS FM to MySQL db. (ODBC connection)
The package has multiple tables joined.
When queried on dimension table the result is quick. As I bring in a field from a FACT table, it just keeps running. (This query takes less than 30secs to be executed in the query window.)

What I realised is JOIN condition (A inner join B on A,C1=B.C1) is not recognised in MySQL but (A,b where A.C1=B.C1) is the way to go.

How do I get COGNOS to process the query in this manner?
I have tried Limited Local & Database only options with no luck.

Strange in my experience both formats should work with MySQL as the explicit join syntax is specified in SQL92 which is what MySQL uses! You must be using a very old version of MySQL if this syntax is not supported!

On the report studio go to query explorer then click on the query once to highlighted go to the query property on the left.
Where you will see.
1 - SQL JOIN SYNTAX (Explicit/Implicit)
2 - Execution Method - (Concurrent/Sequential)
3 - Use SQL Parameters (Marker / Literal)

Try to play with the above property.
Beside that not sure what you have it in the filter (detail or summary filter)
Try to remove one filter at a time and run (the filter might be causing the issue as well)
I have the similar situation while back which it turn to be filter issue also the property I was talking about above as well.