SAP Knowledge Base Article - Preview

1204140 - SQL generation difference between Desktop Intelligence and Web Intelligence

Symptom

There is a difference between the queries generated by Desktop Intelligence and Web Intelligence.
For example: 

SQL query in Web Intelligence 

SELECT
table.column
FROM
table
WHERE
( table.column1=table.column2(+) )
AND (table.column1=table.column3 ) 

SQL query in Desktop Intelligence 

SELECT
table.column
FROM
table 
 
When executing the query in Web Intelligence, the following error message appears:
ORA-00904 error, followed by a WIS 10901.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

deski webi , 7310894 , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.