Unable to create business models

Question

Business model/physical model view is empty after selecting the tables in meta web editor. I am unable to proceed with business model implementation.

I am using PostgreSQL as a data source. Tables are stored in different DB schemas.

Can you please help me to solve this problem?

Comments

Hi,
do you have errors in the knowage.log and knowagemeta.log files? please have a look at it.
Also at the moment is not possibile to select tables coming from different schemas.

---

Thank you for your reply. Actually I can see and select the tables coming from different schemas however nothing is delivered to the business model view. I've tried to create a test table in default PostgreSQL schema (public) and after doing so I was able to deliver the table to business model view successfully. However it means that currently all the tables should be created in default schema in PostgreSQL and this is not a good practice.

Marco do you know are there any plans to fix the issue with tables coming from different schemas in upcoming Knowage release?

P.S. There were no errors in logs.

Answer 1

It's not normal that you see tables coming from different schemas, this will be probably fixed in future releases. Also using tables coming from schemas different from the public one must work, but for the moments there are no plan to support a mixed situation using tables from different schemas in the same business model.