Get started Bring yourself up to speed with our introductory content.

13. OLAP CACHE

Learn the response to the thirteenth question in SearchSAP.com's exclusive BI/BW -- beginner-level quiz.

13. The following statements are true for OLAP CACHE.

a. Query navigation states and query results are stored in the application server memory.
b. If the same query has been executed by another user the result sets can be used if the global cache is active.
c. Reading query results from OLAP Cache is faster than reading from the database.
d. Changing the query will invalidate the OLAP Cache for that query.

ANSWER(S): A, B, C, D

Query results are stored in the memory of application server, which can be retrieved later by another user running the same query. This will make the query faster since the results are already calculated and stored in the memory. By changing the query, the OLAP Cache gets invalidated.

Return to the answer page
Return to the quiz

This was last published in April 2006

Dig Deeper on SAP business warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close