Description:

This property specifies BI Server's strategy for caching metadata and user query results.

Values and behavior:

• NONE - No caching is used at the BI Server level. This may result in slower queries.

• AUTO - The system will determine which query results should be cached when the execution time exceeds the QUERY_CACHE_TIME_THRESHOLD.

  • For materialized semantic models, all query results are cached for SQL, MDX, and Kyvos visualization queries.

  • For a non-materialized semantic model, only the SQL metadata queries are cached. No user queries will be cached.

  • For hybrid multidimensional semantic models, the results of:

    • metadata queries will be cached.

    • user queries having only materialized dimensions and measures will be cached.

    • user queries having non-materialized dimensions or measures will only be cached when the partitioning strategy (Sliding Window) is defined on the semantic model.

• ALL - Enables query caching for all SQL, MDX, and Kyvos visualization queries when the execution time exceeds the QUERY_CACHE_TIME_THRESHOLD.

Default value:

ALL

Scope:

Semantic Model: If the property is set on a semantic model, then the value will override the connection level value for that semantic model’s job.

Comes into effect:

The value of the property can be changed at any time (not recommended) and comes into effect during the next browsing session.

Dependencies and related properties:

OlapEngine Properties

• QUERY_CACHE_STORE_TYPE

• QUERY_CACHE_PATH

• QUERY_CACHE_TIME_THRESHOLD

Recommendation:
Using AUTO is highly recommended. Choosing ALL may return old values on non-materialized semantic models. For additional performance improvement with data validated for accuracy, set the property value as ALL. Set the value to NONE, only if performance is not an issue, and the BI Server has minimal resources.