Data Source search not working with HANA calculation view in Business application studio (CAP )

[former_member838773]

Hello,

I have created a CAP project deployed in my BTP trial account using BAS. I have 2 tables (Header & Item) deployed under my CF space, and I can see the data preview as well, using the HANA DB explorer. Now I have created a Calculation view in the same project under db/src folder as below.

Now inside the calculation view, when I'm trying to add my tables inside a projection node, by pressing '+' button(add data source), i don't find my tables in the search list.

Network call:

Are there any npm dependencies to be installed or is it a limitation with trial account ?.

Please note, I have an active session with cf and DB is up and running.

[robinjayasinghe]

Is there any CDS model involved? If not this is a plain HANA tooling / HDI question. In case the tables are modeled as CDS entities we need to clarify whether the tooling for .hdbcalcviews is capable to work together with CDS entities.

[Dino]

Try to copy the calculationview to the gen/db/src folder and try it from there.

But be careful to copy any changes from gen/db/src to db/src folder before you rebuild the project.
If you forget this the build will overwrite your changes in the gen/db/src folder.

I have the same problem and do it that way at the moment.

[former_member838773]

@robinjayasinghe : Yes, It's a CAP project with 2 CDS entities. It deployed the same, and it could see these tables in my HDI container.

[former_member838773]

@dinosaur4711 thanks for your response. I tried the same but no luck. Are there any npm dependencies to be added. Or is this a limitation with trial account ?