Filter properties

Use the Filters page of the Properties view of the diagram to specify how items are filtered on the diagram.
Note: You can set the default preferences for these properties in the Preferences window by expanding the Data Management node: Data Management > Diagram > Filters and Sorting. The data objects, and data object properties that you select on the Filters and Sorting page are automatically displayed when you create new overview and blank diagrams. The compartments that you select are automatically displayed only when you create new overview diagrams.

Save the current settings to preferences

You can save the options that you specify on the Filters page by clicking the Save the current settings to preferences link. The options that you specify on the Filters page before you click the link are saved as the default options for diagrams that you create.

Compartment display options

For logical and physical data model diagrams, you can specify whether key and non-key elements are displayed on the diagram.

For logical data model diagrams, you can specify whether the description compartment is shown in the diagram.

For physical data model diagrams, you can also specify whether index or trigger compartments are displayed.

For dimensional data model diagrams, you can specify whether hierarchy compartments are displayed.

Attribute filtering options or Column filtering options

The following filter options are available for entities in a logical data model:
Show not-required attributes
If you select this option, the data objects that are not required are displayed in the diagram or the object that you select in the diagram.
Show required attributes
If you select this option, the data objects that are required are displayed in the diagram or the objects that you select in the diagram.
Show foreign-key attributes
If you select this option, the foreign key attributes are displayed in the diagram or the object that you select in the diagram.
Show non-foreign key attributes
If you select this option, the attributes that are not part of the foreign key are displayed in the diagram or the object that you select in the diagram.
The following filter options are available for tables in a physical data model:
Show null columns
If you select this option, the null columns are shown in the diagram or the object that you select in the diagram.
Show not-null columns
If you select this option, the data objects that are not required (or cannot be null) are shown in the diagram or the object that you select in the diagram.
Show foreign key columns
If you select this option, foreign key columns are shown in the diagram or the object that you select in the diagram.
Show non-foreign key columns
If you select this option, the columns that are not part of a foreign key are shown in the diagram or the object that you select in the diagram.

Foreign key relationship display options

Specify which properties of the foreign key relationship between data objects are displayed in the diagram.

Filtering attributes by name or Filtering columns by name

Specify the names of attributes or columns that you want to filter out from the diagram. Attributes or columns that match the pattern that you specify are not displayed. The pattern is case-sensitive.

Generalization set display options

Specify the properties of generalization sets that you want to display.

Filtering attributes by data type or Filtering columns by data type

Specify the data types of attributes or columns that you want to filter out from the diagram. Attributes or columns that use the data type that you specify in the Hide list are not displayed.

Entity display options or Table display options

Specify the properties of the entity or table that you want to display. For example, if you select the Show qualified entity name option, the fully qualified name (PackageName.EntityName) of an entity is displayed.

Attribute display options or Column display options

Specify the properties of the attributes or columns that you want to display. For example, if you specify the Show data types option, the data type of each attribute or column displays next to the attribute or column name.

You can specify the icon decorations that display next to the data object name.


Feedback