SAP Knowledge Base Article - Preview

1742596 - In a webi document in XI 3.1, the SQL is missing the Having clause when the FILTER_IN_FROM parameter is enabled

Symptom

The Webi SQL is missing Having clause when FILTER_IN_FROM parameter is enabled.  After changing the  FILTER_IN_FROM = Yes parameter, the SQL should generate the Having clause. It will throw the error:

SELECT Failed. 3781: No aggregate operation allowed in the search condition for a joined table.


Read more...

Environment

BusinessObjects Enterprise XI 3.1

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

1518434, 01518434 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.