Skip to Content
author's profile photo Former Member
Former Member

OLAP Cache setting

Hi All,

Regarding the OLAP cache, I have a huge list query off an ODS that when run appears within the cache. When I rerun the query, instead of using the results from the cache, it goes against the ODS again.

In looking at the settings on the ODS, I have the following:

- Main memory Cache without swapping

- Query to read when you expand or navigate.

I've checked the settings on the cache and they are as follows:

- It is active

- Persistence mode - Flat File

Any ideas why it's not reading the cache the second time the query is called? Should I perhaps change the second setting in the ODS to a persistent cache. I assume that I would have to then change all existing queries manually.


Robert Zovic

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2004 at 02:38 PM

    Are you running the query exactly as it was run the first time - no change in variable values, drilldowns etc?

    Some questions about your stmt that says your ODS is set for main memory cache, but then you say the the cache setting is persistent mode - flat file.

    Persistent Mode - Flat File indicates the results are stored to a flat file cache rather than main memory. It is possible to have a system wide OLAP cache setting one way, the InfoProvider another, and an individual query set yet another way. Based on your post, are you saying the system setting is Persistent Mode - Flat File, but the Infoprovider cache setting for this ODS is Main Memory?

    If that's the case, you might want to check and see how much memory is allocated to the main memory cache. The default value is very small, don't remember for sure, but think it is only 4 mb. It may simply be that your data just won't fit.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.