1274731 - Web Intelligence XI 3 dropping conditions from Universe joins in SQL WHERE clause

• Self joins or joins with special conditions are being dropped from the WHERE clause in the WebI SQL in XI 3.0 and XI 3.1.
• Example of correct SQL Statement as it appears in Desktop Intelligence:

SELECT
R3_TEST.EMPNO,
R3_TEST.ENAME,
DEPT.DEPTNO
FROM
R3_TEST,
DEPT
WHERE
( R3_TEST.DEPTNO=DEPT.DEPTNO )
AND ( ( exists (Select ENAME from EMP where ENAME= @Variable('BOUSER') AND EMP.DEPTNO=DEPT.DEPTNO))
)

• How it appears in Web Intelligence:

SELECT
R3_TEST.EMPNO,
R3_TEST.ENAME,
DEPT.DEPTNO
FROM
R3_TEST,
DEPT
WHERE
( R3_TEST.DEPTNO=DEPT.DEPTNO )

• It is dropping the special condition added to the join in the Universe:

AND ( ( exists (Select ENAME from EMP where ENAME= @Variable('BOUSER') AND EMP.DEPTNO=DEPT.DEPTNO))

KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem