4.2.1 Creating the Physical View
The first step to creating a data model is to create a physical view. A physical view captures the relationships (joins) among a set of tables, and may encompass all or part of the underlying database schema.
In the following example, you will first create a new physical view using the predefined 'Orders' data source and 'Data Model'. You will then create a logical model, based on this physical view, that provides the order details for products.
To create the physical view, follow the steps below:
1. Click the 'Asset' button to expand the Asset panel.
2. Expand the 'Orders' data source node in the Asset panel.

3. Right-click the 'Data Model' node, and select 'Add Physical View' from the context menu. This opens the 'Physical View Wizard'.

4. In the 'Physical View Wizard', enter “SampleView” into the 'Name' field. Click 'Finish'.

This opens the new physical view for editing.
5. Expand the 'TABLE' tree in the Database panel, and expand the 'SA' node.
6. Drag the following tables to the right pane: 'order_details', 'orders', and 'products'.

7. Create the joins between the tables as follows:
Note: There may be a slight delay as join cardinality is analyzed.
a. Drag the 'product_id' field from the 'order_details' table, and drop it onto the 'product_id' field in the 'products' table.
b. Drag the 'order_id' field from the 'order_details' table, and drop it onto the 'order_id' field in the 'orders' table.


8. Click 'Save' to save the physical view.
You are now finished creating the physical view. The join relationships between the tables form the foundation of the physical view.
If you make a change to the structure of the database schema, press the 'Refresh Metadata' button on the toolbar to update the physical view.
Note that physical views are independent of one another; that is, join relationships defined in one physical view do not impact the relationships defined in another. For full information on physical views, see Physical View in Data Modeling.
| << 4.2 Creating a Data Model | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.2.2 Creating the Data Model (Logical Model) >> |