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

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

- 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.

- 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.

- Benefits of incorporating HANA Native Artifacts like Calculation Views in CAP projects.
- Emphasis on Calculation Views' capabilities in aggregation and filtering large data sets.

- 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.

- Instruction on adding tables to Calculation View and setting up join conditions.
- Details on choosing fields for the join and adjusting join cardinality.

- Addressing authentication requirements for Cloud Foundry and HANA database connectivity.
- Explanation of the significance of hybrid development approach for building calculation views.

- Completing the Calculation View setup and deploying it to the HANA database.
- Overview of the deployment process and verification in Database Explorer.

- 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.

- 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.

- 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.

[anandmuthu]

Calculation View with table function with mapped parameters are not working when called from the cds service. The parameters are not passing through when called from the odata service. Is there an example of this or its not possible ?

[misterheoify]

When creating the calculation view and trying to find data sources, I get the error "Missing Service Details", OR "Unable to find service undefined".

I've checked the mta.yaml and the db-deploy path is db/src. Any ideas? Thank you.

[ChPetru]

Error: Missing configuration file. No default-env.json or substitute found. Full Details: VError: No service matches hana