SAP Knowledge Base Article - Preview

1809165 - How to improve performance, user adoption and guarantee correct results when using Relational Universes by means of Expert Guided Implementation

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

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 4.3

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.