GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
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 4, 2013 11:59 PM by 994812
Biee 11g with Mysql data source
Mar 4, 2013 11:59 PM
Currently Being Moderated
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 ?
Track in Communications
- 10 points
- 5 points