Skip to Content
avatar image
Former Member

Database read or OLAP

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 21, 2010 at 06:41 PM

    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..

    Add comment
    10|10000 characters needed characters exceeded