Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the Business Vault Category
  2. Right-click a blank part of the canvas, select Tables and choose New Bridge table or click on the Create bridge table workflow button. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/Bridge wizard.pngREPLACE WITH THIS IMAGE: Images/Business Data Vault/Bridge Wizard/Bridge Table Wizard 2.png
    Image Added

    Image Added
  3. Select two or more links with hubs between them. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table 1_601x610.png
    Image Added
  4. 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. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table 2.png
    Image Added
  5. Choose whether you would like to introduce a surrogate key and whether you wish to include attributes from satellite current views. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table 3.png
    Image Added
  6. If you have chosen to select attributes from any related Satellite Current Views then you can now choose those attributes. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table 4.png
    Image Added
  7. 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. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table 5.png
    Image Added
  8. 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.REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table 6.png
    Image Added
  9. Your newly defined Bridge table will be displayed in your model. REPLACE WITH THIS IMAGE: Images/releasenotes/8.6.2.0 prime/New bridge table displayed.png
    Image Added
Note
titleNote
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.