SAP Tech Bytes: CAP/HANA Tutorial Part 5 - Create Calculation View and Expose via CAP

Video Version of Tutorial: Create Calculation View and Expose via CAP (SAP HANA Cloud) | SAP Tutorials - https://sap.to/6057RO5Kd

Learn how to combine HANA native artifacts, like calculation views, with SAP Cloud Application Programming Model (CAP)
You will learn
The basics of creating HANA Native Artifacts within a Cloud Application Programming Model project
How to create SAP HANA calculation views
How to integrate SAP HANA native artifacts, like calculation views, within the SAP Cloud Application Programming Model

Summary
Made with HARPA AI

[00:00](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 📖 Introduction to Creating Calculation Views and Integration with SAP Cloud Application Programming Model
Introduction to tutorial on creating and integrating HANA Native Artifacts within SAP Cloud Application Programming Model.
Overview of learning objectives: Creating HANA Calculation Views, integrating them into SAP Cloud Application Programming Model, and exposing them via OData service.

[01:34](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🛠️ Working with CDS Syntax and Handling HANA Native Artifacts
Explanation of integrating HANA Native Artifacts using CDS syntax.
Key concepts: Use of CDS persistence annotation, importance of matching the database artifact's name and columns, and potential runtime conflicts.

[03:38](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🌐 Advantages of Combining HANA Native Artifacts in CAP Projects
Benefits of incorporating HANA Native Artifacts like Calculation Views in CAP projects.
Emphasis on Calculation Views' capabilities in aggregation and filtering large data sets.

[05:06](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 💻 Creating a Calculation View using HANA Tooling
Step-by-step guide to create a Calculation View using SAP HANA database artifact wizard.
Focus on the process of selecting calculation view type and integrating it into the existing data model.

[07:23](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 📊 Adding Tables and Configuring Joins in Calculation View
Instruction on adding tables to Calculation View and setting up join conditions.
Details on choosing fields for the join and adjusting join cardinality.

[09:12](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🔄 Handling Authentication and Database Connectivity Issues
Addressing authentication requirements for Cloud Foundry and HANA database connectivity.
Explanation of the significance of hybrid development approach for building calculation views.

[11:21](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🏗️ Finalizing Calculation View and Deploying to Database
Completing the Calculation View setup and deploying it to the HANA database.
Overview of the deployment process and verification in Database Explorer.

[14:46](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🌍 Integrating Calculation View into CAP Data Model
Steps to integrate the Calculation View into the CAP data model.
Instructions on modifying namespace, creating a context, and defining a proxy entity for the Calculation View.

[17:48](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🔗 Adding Calculation View to OData Service and Final Deployment
Process of adding the Calculation View to the OData service in the CAP model.
Guidance on deploying changes to the service and testing the integrated Calculation View.

[20:01](   • SAP Tech Bytes: CAP/HANA Tutorial Par...  ) 🔒 Applying Security to Exposed Data and Conclusion
Demonstrating the application of security measures to different parts of the CAP project.
Conclusion of the tutorial with successful integration of HANA native artifacts and exposure via OData in the SAP Cloud Application Programming Model.