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 for Me (Login required).

Search for additional results

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