Database read or OLAP

[Former Member]

Hi Guys,

I would like to know for following scenarios while running a BW query, if ...

1) There is a database read (again).

OR

2) The operation is done in OLAP.

Scenarios:

1. Sorting the result after the query is run by a characteristic.

2. Selecting, keeping or removing a characteristic value after running the query.

3. Display or Suppress resultset rows.

4. Swapping characteristics

5. Clicking Back button or Back to start.

6. Normalize query result.

All these are operations done after a user has run the query and the result displayed on screen.

Your inputs will be greatly appreciated.

Thanks

- Kumar.

[former_member184494]

It all depends on the Query read mode - if you have read all data - then the first read is done from DB / Aggregate and subsequent reads are done from the cache - if you have read on navigation - thendepending on the user action the data is fetched..

[Former Member]

Hi,

That is a good input. But my question is after the first run. The query output is there in Bex Analyzer. Now we do the operations so what happens then. Does it hit the data base back or do the operations in OLAP.

[former_member185181]

the data is read from OLAP cache memory.

Execute the query and check the time in st03n.This will help you find the difference