The -SS lines tab is used to describe the
list of the subschemas used by a Logical View, and the subschemas
and subsystems of a Table used by the current Logical View.
Before you begin
Note: - A subschema is a set of Data Elements which belong to the composition
of a Logical View or Table. The use of subschemas provides a partial
view of this data. For example, you have a Logical View that represents
the American states. You can define a 'telephone' subschema which
groups the data related to the telephone coding (city number and area
code.
- A subsystem is a selection of Table items within a Table, each
one being a different subset of data. You can define subsystems only
if you use Pactables. In this case, you can define several subsystems in the SS
lines of a Logical View. In our example, you have two subsystems
which represent the 'eastern' states and the 'western' states.
About this task
It is possible to define 10 subschemas for each Table/Logical
View and 10 subsystems for each Table. The subsystems are identified
by lines with a 'Y' type and subschemas by lines with a 'S'
type. Both
must be given a number and a name.
Procedure
- To add a new subschema in the list of the SS lines, click
the Add a subschema line and button. As a result, a 'S'
type line is added to the list of SS lines.
- To create a subsystem, in the list of the SS lines, click Add
a subsystem line. The button is active only if you
use Pactables. Then, a 'Y' type line is added to the list.
- When you create a subschema or subsystem, a definition section displays in the right part of the
list so that you can define the characteristics of the new subschema
or subsystem such as its name and number, and for subsystems, you
must specify the maximum number of occurrences. The name and number of
the new subschema or subsystem are automatically displayed on the corresponding line
in the list.
- To remove a line in the list, select a line and click Remove.
- To sort the SS lines in the
list, select a line and click the ↑ to move up a line in the list
or ↓ to move down a line in the list.