Consume Calculation View in SAC from CAP project not working

[luisgleon]

Hi all,

I have a SAP Cloud Application Programming Model (CAP) project in my BTP environment (trial), and I am trying to consume a calculated view from SAP Analytics Cloud (trial), I have created a connection and then when I try to select a data source in the modeler, the list is empty.

To create the CAP project I followed the following tutorials:

Create an SAP Cloud Application Programming Model Project for SAP HANA Cloud
https://youtu.be/8obCwGEx1-Q?si=ll6fWgvEqPluQa8i
https://developers.sap.com/tutorials/hana-cloud-cap-create-project.html

SAP Tech Bytes: CAP/HANA Tutorial Part 2 - Create Database Artifacts Using Core Data Services (CDS)
https://youtu.be/uS_vT-gHYMo?si=C4W1q7I6CLfHErHP
https://developers.sap.com/tutorials/hana-cloud-cap-create-database-cds.html

SAP Tech Bytes: CAP/HANA Tutorial Part 3 - Create a User Interface
https://youtu.be/6WY70LyLS1c?si=X0XuCNEtDW2o6sRe
https://developers.sap.com/tutorials/hana-cloud-cap-create-ui.html

SAP Tech Bytes: CAP/HANA Tutorial Part 4 - Add User Authentication
https://youtu.be/anvKQP8yOr4?si=rDy5ndYbe__6ZwHp
https://developers.sap.com/tutorials/hana-cloud-cap-add-authentication.html

SAP Tech Bytes: CAP/HANA Tutorial Part 5 - Create Calculation View and Expose via CAP
https://youtu.be/zKsx91qicwU?si=xC4rZUGZrGFI7mxE
https://developers.sap.com/tutorials/hana-cloud-cap-calc-view.html

Everything works fine, at the end of part 5 I verified that the view was created correctly (see images 1) and the service exposes the data correctly. After that I tried to consume the calculated view from SAC, following the tutorial Develop Calculation View in BAS and consume in SAC (https://community.sap.com/t5/technology-blogs-by-sap/develop-calculation-view-in-bas-and-consume-in-...), starting from step 8. I created a connection, and then I tried to create a model but when I select the data source, it doesn't show anything (see image 2).

image 1

image 2

What can I be doing wrong?

Thanks in advance.

[Willem_Pardaens]

I can't spot anything wrong from the information you shared. Maybe double check the connection in SAC that it is pointing to the correct HDI container and using a valid RT user?

[Kunal_Ingale_In]

Hi,

If you need to utilize a calculation view developed within an SAP Cloud Application Programming Model (CAP) project in the Business Technology Platform (BTP) environment, and subsequently wish to consume this calculation view in SAP Analytics Cloud (SAC).

proceed with the following steps:

First, you have to create a connection with live data:

Choose the "Connection" option from the left-side menu in SAC. Then, proceed to create a connection by selecting "Create Connection". From the available options, opt for "SAP HANA" under the "Connect to Live Data" section.

Once you've accessed the new HANA live connection, select "SAP HANA Cloud" as the connection type. Follow these steps to obtain the host, username, and password:

1. Navigate through the Global account to the subaccount, then locate the Services section. Within Services, find the Instance & Subscription option, and select your specific instance.

1. Choose the "project name"-db-key and navigate to the form to obtain the Host, username, and password. Copy this information to the connection detail section.

1. Choose OK to create a connection.

To access the created calculation view in SAC, navigate to the Modeler from the left-side menu of SAC.

1. opt for Live Data Model. A pop-up will appear prompting you to create a model from a live data connection. in the frame of the live data connection and data source.

Select "System Type" as SAP HANA and choose the connection with the name you provided during its creation.

After it loads, you'll see a list of data sources in the value help list. Select the calculation view you created and proceed to create a model based on it.

[luisgleon]

Hello Kunal,
Thank you for your response. I followed your instructions but I still can't see the data source list in the value help list. I'm not receiving any errors, it just doesn't show anything. If you look at my post, I had already practically followed the same steps you mentioned, but the result is the same: the data source list cannot be displayed. Although I haven't read anything about it, could it be a permissions issue? Something that isn't mentioned in the tutorials I've followed.

Thanks in advance.