cancel
Showing results for 
Search instead for 
Did you mean: 

Error while build a simple calculation view Dimension

0 Kudos

Hello all,

I have the following issue:

I have a simple project, with a dimensional view, also very simple.

Background:

1.- I created the project and build empty to create HDI Container.

2.- On Database Explorer, I created and filled the tables directly from the SQL console, not using cds.

3.- I create a calculated view of dimension type, very simple, only clients of a country.

When I build the project after Precompilling ok, Merged ok, I get the following error:

Error: The file requires "db: // CLIENTS" which is not provided by any files [8212001] at "src/CVD_AT/CVD_CLIENTES.hdbcalculationview" (0: 0)

I am practicing with HANA Express edition in the SAP Web IDE for SAP HANA.

Thanks in advance for the help you can give me

lsubatin
Active Contributor
0 Kudos

Hi, Federico, did you create the tables in the HDI container or in a plain schema?

Accepted Solutions (0)

Answers (1)

Answers (1)

braghavendra_rao
Employee
Employee
0 Kudos

Hi

All the HDI artifacts should have a corresponding design time files present as part of HDB module.

Since you created the underlying tables through SQL, you get this error.

Either you can create a design time .hdbcds files or create a synonym file pointing to the SQL generated tables.

Regards

Raghavendra

0 Kudos

For Lucia: I create tables from SQL Console in HDI container.

Rao, I'll try to create tables via .hdbcds.

Thanks