A business model contains all of the logical, abstract business objects and relationships that model your physical database objects in such a way that underlying changes to the physical database objects have minimal impact on your business, your business intelligence application, and your end users. There can be multiple business models in a single domain. A business model currently supports one database connection, and consists of business tables, relationships, and a multiple business views.
Fortunately, when you import a physical table, all of the table's columns come with it, so the import is a one step exercise instead of two. Later, you can remove the columns you do not want in the connection or the model. Below is an example of an import from HSQLDB (Hypersonic):
-
Right-click the
Sample Data Example node in the navigation pane then
select Import Tables from the menu.
A dialog box that contains all physical tables available in the database appears.
