SAP Knowledge Base Article - Preview

1912916 - MultiSource Universe Connection with Oracle and BW Displays Multiple Sql Queries Generated Multiple Times From The Same Table

Symptom

  • When executing the query a multisource universe with connections to Oracle and BW displays multiple sql queries that are generated where the same table is accessed multiple times
  • The Data Federation Adminstration Tool Query monitor displays multiple sql queries are generated accessing the same table multiple times


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4x
  • Information Design Tool
  • Web Intelligence
  • Data Federation Administration Tool
  • SAP NetWeaver BW
  • Oracle 11G

Product

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

Keywords

Multiple Queries , MSU ,Multi-source ,IDT ,DFAT , KBA , BI-BIP-IDT , Information design tool , BI-BIP-DF , Data Federation Service , 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.