4.3.4 Extending a Physical View
In a multi-tenant environment, it may be useful to provide a different physical view to each tenant. Each physical view can provide access to tenant-specific database tables, as well as to a set of common tables that are shared by all physical views.
To create a tenant-specific physical view, extend the existing physical view by adding tables from a tenant-specific connection. Follow the steps below.
1. Open the Asset panel, and expand the 'Data Source' node.
2. Right click on the base physical view that you wish to extend, and select 'Add Extended View' from the context menu. This opens the 'Extended View' dialog box.

Note: An extended physical view is associated with one (and only one) connection. Likewise, a connection can be associated with only one extended physical view.
3. In the 'Extended View' dialog box, choose a connection option for the new extended view, and click 'OK'. (You can select the default data source connection, or any of the tenant-specific connections.)

Tables and joins inherited from the base physical view cannot be modified within the extended view.
This adds the new extended view to the current data source, and opens the view for editing. The right panel displays the tables and joins defined in the base physical view.

4. Drag tables from the left panel into the right panel, and create any desired joins between the new tables and the inherited tables. (See Creating a Physical View for more information about joining tables in a physical view.)
5. When you have finished defining the extended view, click the 'Save' button in the Style Studio toolbar.
You can now use this extended physical view to create an extended logical model. See Extending a Logical Model for more information.
See Also
Adding Additional Connections, for information on configuring connections.
Creating a Physical View, for information on creating the base physical view.
| << Chasm Trap (Cardinality Trap) | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.4 Logical Model >> |