0 Replies Latest reply: Mar 5, 2013 1:59 AM by 994812 RSS

    Biee 11g with Mysql data source


      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 ?