Skip to Content
0
Sep 16, 2014 at 08:43 PM

Web I report using SQL Server 2008 based Universe

25 Views

Hi,

We are in the process of switching from Oracle to SQL Server DB.

As a part of the project the Web I reports (XI R4) are modified to accommodate the changes.

The Oracle universe connection is modified to SQL Server connection and the integrity is checked.

While trying to refresh the Web I reports based on this universe , I just noticed that the query filter got displayed under 'FROM' clause in the System generated query with an AND at the end of each filter.

Normally it should get displayed under the WHERE clause in the system generated SQL.

Any ideas to get them displayed under the Where clause?

MSSQL query with additonal AND (System generated)

--------------------------------

SELECT

T.NAME,

L.LOCATION,

T.DESIGNATION

FROM

EMP T INNER JOIN EMP_LOC L ON (T.LOC_ID= L.ROW_ID AND T.Emp_id IN @Prompt('Enter id','A','Geo':'Column 0',Multi,Constrained,Persistent,,User:-1,Optional)

AND AND L.LOC IN @Prompt('Enter LOC','A','Geo':'Column 0',Multi,Constrained,Persistent,,User:-1,Optional) AND )

Oracle query (System generated)

-------------

SELECT

T.NAME,

L.LOCATION,

T.DESIGNATION

FROM

EMP T, LOC L

WHERE

T.LOC_ID=L.ROW_ID AND

T.Emp_id IN @Prompt('Enter id','A','Geo':'Column 0',Multi,Constrained,Persistent,,User:-1,Optional) AND

L.LOC IN @Prompt('Enter LOC','A','Geo':'Column 0',Multi,Constrained,Persistent,,User:-1,Optional)

Thanks,

Nithya