This discussion is archived
0 Replies Latest reply: Mar 4, 2013 11:59 PM by 994812 RSS

Biee 11g with Mysql data source

994812 Newbie
Currently Being Moderated
Hello,

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 ?


thanks..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points