SAP Knowledge Base Article - Preview

1711167 - Multiple SELECT DISTINCT Queries generated on the Data Warehouse database from the BI Universe

Symptom

  • The database shows many SELECT DISTINCT queries generated on the database from the BI
  • Multiple sql statements appear to be executing and performance is slow.
  • The mass SELECT DISTINCT queries generated have caused database to become unstable


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.x
  • Universe Design Tool (UNV)
  • Web Intelligence (WEBI)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

BOBJ, BI, Performance webi , data base hangs , KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , BI-BIP-UDT , Universe Design Tool , 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.