SAP Knowledge Base Article - Preview

3426772 - OLAP Cache is not used for BW Query 2nd Execution

Symptom

For a BW Query that can use OLAP cache and does not yet have OLAP cache:
When executing the query with a certain selection for the 1st time, it reads data from Database.
When executing the query with the same selection for the 2nd time, it still reads data from Database (instead of reading data from OLAP cache). 
When executing the query with the same selection for the 3rd or further time, it reads data from OLAP cache as expected.


Read more...

Environment

BW
BW4HANA

Product

SAP BW/4HANA all versions ; SAP Business Warehouse all versions

Keywords

twice execution, two executions, second execution, third execution, 2nd execution, 3rd execution, second time, third time, 2nd time, 3rd time , KBA , BW-BEX-OT-CCH , Olap Cache , BW4-AE-CCH , OLAP Cache , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.