Symptom
- Improve universes so they meet basic best practice
- Ensure that universes are proofed for correct results
- Improve response times for universe queries
Read more...
Environment
- Universes based off a relational source (i.e. using SQL)
- SAP BusinessObjects Enterprise XI 3.x
- SAP BusinessObjects Business Intelligence Platform BI 4.x
- Access the SAP Enterprise Support Academy Expert Guided Implementation. Typically this is:
- SAP Enterprise Support customers and VAR partners (with VAR delivered support)
- SAP Product Support for Large Enterprises customers
- SAP Certified partners
(Access to the SAP Enterprise Support Academy Expert Guided Implementation is not available for customers with a SAP Standard Support contract)
Please note this is NOT suitable for:
- OLAP Universes (i.e. using MDX), including Multi-dimensional Universes (available in BI4 for connecting to OLAP sources)
- Stored Procedure Universes
- JavaBeans Universes
Product
Keywords
optimisation, query, slow, BOUNDARY_WEIGHT_TABLE, TRUST_CARDINALITIES, Multiple SQL statements for each measure, database delegated, Hierarchical Display, delegated search, LOV, optional digit, mandatory digit, @prompt, @variable, BEGIN_SQL, END_SQL, DISTINCT_VALUES, FILTER_IN_FROM, ANSI92, FULL_OUTER_JOIN, INNERJOIN_IN_WHERE, BOUNDARY_WEIGHT_TABLE, JOIN_BY_SQL , KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , 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.