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.