SAP Knowledge Base Article - Preview

1743593 - SBOP XI 3.1: Self join is ignored by SQL query generator in Web Intelligence Rich Client and Universe Designer

Symptom

  • Wrong results are shown by Web Intelligence reports built on top of a Universe with defined self joins
  • A self join defined for a dimension is ignored by Web Intelligence SQL-generator and the self join is being lost under FROM section of the query


Read more...

Environment

  • SAP BusinessObjects Enterprise XI 3.1 SP3 Fix Pack 3.7, Fix Pack 3.8
  • SAP BusinessObjects Enterprise XI 3.1 SP3 Fix Pack 3.7, Fix Pack 3.8 Client tools: WebIntelligence Rich Client, Universe Designer
  • SAP BusinessObjects Enterprise XI 3.1 SP4 Fix Pack 4.2
  • SAP BusinessObjects Enterprise XI 3.1 SP4 Fix Pack 4.2 Client tools: WebIntelligence Rich Client, Universe Designer
  • SAP BusinessObjects Enterprise XI 3.1 SP5 Fix Pack 5.2
  • SAP BusinessObjects Enterprise XI 3.1 SP5 Fix Pack 5.2 Client tools: WebIntelligence Rich Client, Universe Designer
  • Microsoft Windows Server 2008 R2

Product

SAP BusinessObjects Business Intelligence Edge 3.1, standard package ; SAP BusinessObjects Enterprise XI 3.1

Keywords

self join, ignored, missing, removed, lost, sql, query, SQL, FROM, fix pack, 3.7, 3.8, 4.2, 5.2, 5.3, ADAPT01640966, 01640966 , KBA , BI-BIP-UDT , Universe Design Tool , Bug Filed

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.