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: . 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.