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

These posts might also be interesting:

• Replicate SAP BW DataSource
• Overview SAP Business Objects tools
• Activate all inactive transformations
• Infoset throws dump while checking or activating

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.