SAP Knowledge Base Article - Preview

1762023 - How do you ensure optimal performance of Web Intelligence reporting off of multi-source Universes with semi-joins?

Symptom

  • A BI 4.x Web Intelligence document reporting off a multi-source Universe (UNX).
  • Observing the generated SQL query using the Data Federation Administration Tool, it is observed that incorrect semi-join is being performed.
  • The resulting query cause a full scan of one of the database tables, resulting in either slow performance or crash of the Data Federation service.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.x
  • SAP BusinessObjects Business Intelligence Web Intelligence
  • Information Design Tool
  • Multi-source universe MSU

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3 ; SAP NetWeaver 7.0

Keywords

WebI , DF , MSU , KBA , BI-RA-WBI , Web Intelligence , BI-RA-WBI-DSL , Obsolete, use : BI-RA-WBI-BE-DP , EIM-DF , Data Federator (use BI-BIP-DF) , Problem

About this page

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

Search for additional results

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