November 2014.

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

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:

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