I installed biee 11g on linux server and create a new repository using Mysql data source.
I can deploy this .rpd file on biee server, but bi server will occur an error and cannot return any result.
I debug the sql issue, found that the sql be ganerated as below: select distinct T9."KPI_CATEGORY" as c1 from "DIM_KPI" T9
this sql will be not allowed in Mysql but it is OK in Oracle(quotation marks is not allowed in Mysql).
How can I fix this issue and let the sql can be execute in Mysql ?