SAP Knowledge Base Article - Preview

1185268 - How Do You Prevent A Query From Returning Too Many Rows?

Symptom

A "Fan Trap" is a problem inherent to SQL. It is caused by limitations in the way joins are performed in relational databases. Unlike loops, which return fewer rows, a Fan Trap returns too many rows.

 

 


Read more...

Environment

BusinessObjects Enterprise

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI 3.0 ; SAP BusinessObjects Enterprise XI 3.1

Keywords

1322 , Fan Trap, wrong data, wrong number of rows, sql error , KBA , BI-BIP-SL , Semantic Layer , How To

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.