How to: Reference: |
The Synonym Editor Modeling View tab provides a visual presentation for the synonym for which positioning is preserved and stored in the Access File. Use the Modeling View to define dimensions for OLAP analysis, view join properties, create cluster joins, and add or edit segments. For more information about using the Dimension Builder in the Modeling View, see Defining Dimensions for OLAP Analysis.
Note: The Modeling View is not available for Cube data sources.
Use the Modeling View to enhance a synonym by adding a segment.
The Synonym Editor opens.
The Synonym Editor Modeling View tab opens in the workspace.
The following context menu appears.
Note: You would use this approach only if you are coding a new Master File, as you would for a FOCUS data source.
To edit synonyms using Modeling View:
The Synonym Editor opens.
A context menu appears, providing options for adding segments.
Note: Options for adding segments are also available from the icons above the workspace.
To insert a segment from an existing synonym:
The Insert Reference to Existing Synonym dialog box opens.
Columns can be customized and sorted. Synonyms displayed in this dialog box are based on the Reporting Servers APP Path configuration.
The segment is added to the synonym.
To insert a segment from an existing synonym with Snowflake:
The procedure is the same as Reference to Existing Synonym, except the selection list will show both candidate synonyms and any synonyms that they reference.
To insert a segment via Metadata Import:
This method enables you to launch the Create Synonym tool, create a synonym, and incorporate it as a new segment in the synonym from which you initiate the import.
The following image is an example of a screen where you provide information for the connection parameters.
The following image is an example of a screen that enables you to select tables to create synonyms.
The segment is added to the synonym.
To insert a segment manually:
The segment is added to the Modeling View and a default field is created, using a default segment name.
The following image shows a synonym that has had several segments added in the Modeling View tab.
The following image shows the resulting Text View.
The following image shows the resulting Access File Text View.
When you right-click a synonym or segment in the Synonym Editor Modeling View tab, the following context menu appears.
The context menu has the following options:
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.
Provides access to the Join Properties window.
Note: Join options are not available for FOCUS files.
Provides the characteristics of the data for a segment.
Displays sample data in the workspace.
Displays sample data with parent key in the workspace.
Deletes the segment.
Enables you to rename the segment.
When you select Join Properties from a segment in the Synonym Editor Modeling View tab, the Join Editor dialog box appears.
The Join Editor dialog box contains Left and Right Source columns, Join Type, and Join Condition options, as well as One-to-Many and One-to-One choices. Use the left and right source columns to create join maps and view sample data.
Note: Join options are not available for FOCUS files.
WebFOCUS |