SAP Knowledge Base Article - Preview

1344433 - What is the best practice for setting Setting Query Timeout and Limiting Result Set Data in Universes for ad Hoc report.


  • Ad Hoc reports against Very Large Data sets from relational(Oracle, Microsoft SQL Server etc.) or OLAP Data Sources(SAP BW, Essbase, Microsoft Analysis Services) can allow users to return Billions of Rows of data. Returning such large data sets can be taxing on the Business Objects Enterprise Infrastructure and can have a negative performance impact on the over system leading to system instability.



SAP BusinessObjects Business Intelligence platform R2


KBA , BI , Business intelligence solutions , 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.