Augment OLAP Cache and Query Performance with Delta Cache

  • by Anurag Barua, Independent SAP Advisor
  • July 1, 2008
SAP NetWeaver BI 7.0 includes many options to help you speed up query performance, such as SAP NetWeaver BI Accelerator. Find out about a lesser-known option, delta caching, that you can also use for fast query performance.
Key Concept

The concept of delta cache builds on the technique of caching the most frequently accessed data of a query in main memory or some other secondary storage media. The next time a query needs to access this data, it does not need to go to the database but reads it directly from the cache. This reduces the total runtime of a query. It also improves query performance and, of course, end-user satisfaction.

Getting SAP NetWeaver BI queries to run faster is almost an obsession for me. I am of the mindset that even if a query is perceived to be running fast enough, efforts should be made to make them run faster. In the earliest releases of SAP BW, your quest for query performance optimization would have been hamstrung due to the lack of adequate tools. However, SAP NetWeaver BI 7.0 offers many diverse tools to help speed up your queries.

Although you may be familiar with the more prominent tools that potentially bolster performance — such as aggregates, Online Analytical Processing (OLAP) cache, setting the appropriate read mode, and BI Accelerator — a few are obscure or new. One such tool that is both is delta cache. The delta cache functionality is available starting with Support Package (SP) 10 of SAP NetWeaver BI 7.0.

The first time I used this option in an SAP NetWeaver BI 7.0 system I didn’t know anything about it. I was looking for ways to improve the runtime of a query in the query monitor (transaction RSRT) when my eyes fell on a check box labeled Update Cache Objects in Delta Cache. After I selected this option, my query, which was run off a standard InfoCube, ran faster.

Anurag Barua

Anurag Barua is an independent SAP advisor. He has 23 years of experience in conceiving, designing, managing, and implementing complex software solutions, including more than 17 years of experience with SAP applications. He has been associated with several SAP implementations in various capacities. His core SAP competencies include FI and Controlling FI/CO, logistics, SAP BW, SAP BusinessObjects, Enterprise Performance Management, SAP Solution Manager, Governance, Risk, and Compliance (GRC), and project management. He is a frequent speaker at SAPinsider conferences and contributes to several publications. He holds a BS in computer science and an MBA in finance. He is a PMI-certified PMP, a Certified Scrum Master (CSM), and is ITIL V3F certified.

Anurag will be presenting at the upcoming Managing Your SAP Projects 2017 conference, October 24-26, 2017, in Copenhagen. For information on the event, click here. Anurag will also be presenting at the Managing Your SAP Projects 2017 conference, November 29-December 1, 2017, in Las Vegas. For information on that event, click here.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.