Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 5, 2013 1:59 AM by
Biee 11g with Mysql data source
Mar 5, 2013 1:59 AM
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 ?
This content has been marked as final.
Show 0 replies