November 2014.

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
Read More 0 Comments

Open a BEx workbook via VBA

In 7.0 and 3.5 you can open workbooks via VBA. This is useful if you want to automate reporting. The command for BEx Analyzer is:

Read More 0 Comments

Load VBA code from a text file

If you want to import source code from a text file, you can use the following code.

Read More 0 Comments