Query Service Caching Administration

Caching reuses previously executed results and, when possible, avoids new queries to the database.

Caching can improve performance when reports are re-run with small modifications, analyses are performed within the same cube, and repetitive master-detail requests are performed for large reports. The cache maintains the security permissions of the user who executes the request.