BI publisher SQL data set editor not accepting complex queries - Irrelevant errors thrown
BI publisher SQL data set editor doesn't quite understand complex queries, for example
SELECT * FROM EMPLOYEES JOIN (SELECT DEPARTMENT_ID,DEPARTMENT_NAME FROM DEPARTMENTS) DEP
on (employees.department_id=dep.department_id and dep.department_id = (select min(department_id) from DEPARTMENTS))
gives me an error "ORA-00907: missing right parenthesis", this works successfully in SQL developer. Why is it so hard for BI publisher to understand this query ?
Please note there can be alternatives to the writing the above code but my question is why is this specific query not accepted in BI publisher.
I am using BI publisher trial edition 11.1.1.6.0
SELECT * FROM EMPLOYEES JOIN (SELECT DEPARTMENT_ID,DEPARTMENT_NAME FROM DEPARTMENTS) DEP
on (employees.department_id=dep.department_id and dep.department_id = (select min(department_id) from DEPARTMENTS))
gives me an error "ORA-00907: missing right parenthesis", this works successfully in SQL developer. Why is it so hard for BI publisher to understand this query ?
Please note there can be alternatives to the writing the above code but my question is why is this specific query not accepted in BI publisher.
I am using BI publisher trial edition 11.1.1.6.0
0