Skip to Content

Do Query Views use existing OLAP Cache or create their own

Hi, I'm looking to find out if a Query View will use the Parent Query OLAP Cache or will it create it's own?

I am imagining that it would use the query view, but create additional cache if it drilled down on a free characteristic that wasn't in the original query output. Any comments

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 16, 2007 at 07:11 PM

    If there are any entries in the CACHE which meets the drilldown and filter criteria for the view it will be able to make use of existing Cache.

    As you mentioned for any additional drilldowns if there are not entries in the cache it will have to read from DB.

    Add comment
    10|10000 characters needed characters exceeded