Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Web I report using SQL Server 2008 based Universe

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

Former Member
Not what you were looking for? View more on this topic or Ask a question