2 weeks ago
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.
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:
To access the created calculation view in SAC, navigate to the Modeler from the left-side menu of SAC.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
67 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.