SAP BW Query Read Mode

Query to Read All Data at Once

 

Advantages:

  • query navigation after first call very quickly as data completely present in OLAP cache

Disadvantages:

  • Initial call slow
  • Using characteristics aggregates greatly restricted
  • Large memory requirement in the OLAP cache

Recommendation:

  • Using the read mode only for small InfoCubes
  • Using the read mode only in queries with a few free characteristics

Query to Read Data During Navigation

Advantages:

  • Good hit rate in characteristic aggregates
  • Quick response times for small hierarchies

Disadvantages:

  • Waiting period required in successive runs when selection is not identical to Initial call

Recommendation:

  • Using the read mode for small hierarchies
  • Using the read mode for large result sets

 

Query to Read When You Navigate or Expaned Hierarchies

Advantages:

  • Initial call of the query quickly because only the necessary data is selected

Disadvantages:

  • Selects the least amount of data in the Initial call, so read access to database with modified navigation required

Recommendation:

  • Using the read mode when hierarchy aggregates required
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0