DataMigrator/Reporting Server > Creating and Enhancing Synonyms Using Modeling View

Creating and Enhancing Synonyms Using Modeling View

How to:

Reference:

The Synonym Editor Modeling View tab allows you to create and enhance synonyms graphically. You can also use this view to create a single view of multiple data sources.

Procedure: How to Create Synonyms Using Modeling View

  1. Right-click an application directory, point to New, and then click Synonym via Synonym Editor.
  2. Right-click the new synonym, point to Insert, and click Reference to Existing Synonym as Root .
  3. Select the synonym to use as the root, and click Select.
    Note: If the synonym selected has more than one segment, a dialog box opens. Click the entry segment you wish to use and click OK.
  4. Click the Modeling View tab.
  5. Right-click the new synonym in the workspace and point to Insert.
  6. Add segments through one of the four methods listed.
  7. Optionally, if you have multiple joined segments you can double-click the arrowed lines between tables to open the Join Editor dialog box and determine how the tables are linked.

Procedure: How to Enhance Synonyms Using the Modeling View

Use the Modeling View to enhance a synonym by adding a segment.

  1. Open the synonym in the Synonym Editor by double-clicking it from the navigation pane.
  2. Click the Modeling View tab.
  3. Right-click a segment in the workspace and point to Insert.
  4. Add segments through one of the methods listed:
    • Reference to Existing Synonym as Child. Adds a segment to the existing synonym as a reference to another synonym. Only the name of the synonym is added. If the referenced synonym is changed, the new version is used.
    • Reference to Existing Synonym as Root. Inserts reference to selected table and any tables it references.
    • Segment via Metadata Import. Enables you to add segments by using the Create Synonym tool. This tool creates a synonym and includes it as a segment in the synonym from which the tool was launched.
    • Segment Manually. Enables you to add segments manually to the current synonym.

      Note: You would only use this approach if you are coding a new synonym by hand, as you would for a FOCUS data source.

  5. Optionally, you can double-click the arrowed lines between tables to open the Join Editor dialog box and determine how the tables are linked.

    Tip: You may also right-click a file icon and click Join Properties from the context menu.

    In addition, when creating a cluster join, there are two additional options for linking tables. Join All (default) is shown by a double arrow, and Join Unique is shown as a single arrow.

    Join options are not available for FOCUS files.

Reference: Modeling View - Segment Shortcut Menu

When you right-click the title bar of a segment in the Synonym Editor Modeling View tab, a shortcut menu opens.

The shortcut menu has the following options:

Expand/Collapse

Changes the view from a file icon to a table view, which enables you to see columns, sample data, and sample data parent keys.

Tip: You may also double-click a file icon to open the table view. Double-click the table to close the table view, or click the X button from the toggle toolbar to close.

Properties

Opens the Properties pane for the selected segment.

Insert

Has the following options:

  • Reference to Existing Synonym as Child. Adds a segment to the existing synonym as a reference to another synonym. Only the name of the synonym is added. If the referenced synonym is changed, the new version is used.
  • Reference to Existing Synonym as Root. Inserts reference to selected table and any tables it references.
  • Segment via Metadata Import. Enables you to create a new synonym through the Create Synonym tool, and add it to the current synonym.
  • Segment Manually. Adds a segment to the current synonym that must be coded manually.
Data Profiling

Provides the data characteristics for the columns of a synonym.

Sample Data

Shows a sample of the data associated with the synonym.

Delete

Deletes the segment.

Edit All Properties

Opens the Properties pane for the segment.

Assign SCD Columns

Allows you to assign columns to a SCD type by using drag-and-drop.

 WebFOCUS

Feedback