Symptom
- Web Intelligence generates one query with multiple SELECT statements.
- How are the 2 SELECT statements combined? Does it use UNION, INTERSECT OR EXCEPT?
Universe has following SQL parameters selected:
- Multiple SQL statements for each context;
- Multiple SQL statements for each measure.
Standard WebI behaviour: a query using either:
- objects from separate contexts
or - measure from separate tables.
Read more...
Environment
- SAP BusinessObjects Enterprise XI R2
- SAP BusinessObjects Enterprise XI 3.x
- SAP BusinessObjects Business Intelligence Platform 4.x
- Web Intelligence
- Universe Designer / Universe Design Tool
Product
SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI 3.0 ; SAP BusinessObjects Enterprise XI 3.1
Keywords
multiple SQL; multiple select; combined queries; join; intersection , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , How To
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.