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.
SAP Knowledge Base Article - Preview