The Bridge Wizard enables you to create Bridge tables that pull fields from multiple links and their related hubs and Satellite Current Views. Options are available for adding a surrogate key and calculated columns.
These are the steps for creating a Bridge table with the new wizard:
- Open the Business Vault Category
- Right-click a blank part of the canvas, select Tables and choose New Bridge table or click on the Create bridge table workflow button.
- Select two or more links with hubs between them.
- Select the hubs you would like to include in the Bridge table. The hub(s) required for the relationship between the links cannot be unselected.
- Choose whether you would like to introduce a surrogate key and whether you wish to include attributes from satellite current views.
- If you have chosen to select attributes from any related Satellite Current Views then you can now choose those attributes.
- You can add calculated columns with name, label and change. For the change field value, you can insert a function and also copy the column name which is listed for reference.
- You can modify the suggested name of the table, which defaults to the name of the selected hubs. Columns which will be added in the table will also be displayed below.
- Your newly defined Bridge table will be displayed in your model.
Note
Bridge tables have their DW Query generated in a later step when the Bussiness Vault Deployment model is converted to a RED Export model. This is when the SQL join statements are generated for WhereScape 3D.