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

Write a comment

Comments: 0