Tips, Tricks, and New Features with SAP HANA Calculation Views

  • by Joerg Boeke, Independent BW Senior Consultant and Solution Architect
  • December 12, 2017
Get a detailed guide for using the two different calculation views (graphical and SQL Script based) within SAP HANA development. Learn about a new SAP HANA BW modeling concept based on views and the benefits of tight integration of SAP HANA SQL Script procedures in calculation views, as well as its pitfalls.
Learning Objectives

Reading this article, you’ll learn:

  • A detailed overview of SAP HANA calculation views and their extensions by using SAP HANA-based procedures
  • How to cut down development time as well as remodeling phases by using the new features SAP HANA development offers
  • How to combine old staging data with modern SAP HANA virtual staging via calculation views and procedures in mixed-scenario approaches to be more flexible than in the regular Administrator Workbench-driven design
  • How to replace existing staging with dynamic SAP HANA-based views
Key Concept
In a modern SAP BW powered by SAP HANA environment, it is wise to switch to virtual data staging instead of old-school data staging via persistency layers. SAP HANA calculation views and procedures for complex scenarios help to calculate data on the fly to cut down unload and reload phases to zero when it comes to business-related changes in data staging or extension/reduction in a data model. In the SAP HANA environment using SAP HANA studio or Eclipse, SAP BW operators can very easily switch from the old-fashioned models to the new calculation-view-based modeling concept or run a mixed scenario of both worlds.

More and more SAP system users are implementing SAP HANA as the foundation and database for existing SAP BW installations. Some may just be replacing an existing database with the modern SAP HANA database to gain speed in query execution and warehouse management. This is, of course, a keystone of an SAP HANA implementation within SAP BW, but not the only one.

From my point of view, the tight integration of SAP HANA functionality using SAP HANA studio or Eclipse to design new ways of data warehouse management is at least as important as reporting performance.

Why use old habits with SAP application layers, storing more and more data in persistency layers, when it’s possible to calculate new reporting data on the fly? Using SAP HANA-based staging to enhance data flows without the physical staging of incoming data in several layers (SAP staging layer architecture [SLA]) is something I am working on at a customer site.

Joerg Boeke

Joerg Boeke is an SAP NetWeaver BW solution architect and senior consultant working with BIAnalyst GmbH & Co.KG, with 19 years experience in SAP NetWeaver BW, having worked on it since SAP BW 1.2A. He offers significant expertise in the SAP NetWeaver BW reporting area, including design, data integration, data visualization, performance optimization, and the cleanup of existing SAP NetWeaver BW systems. He is the author of SAP BW 7.x Reporting - Visualize your data.

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.