In the -SS lines tab, you describe
the subschemas that are used by a Logical View, and the subschemas
and subsystems of a Table that is used by the Logical View.
Before you begin
Note: - A subschema is a set of Data Elements that belong to the composition
of a Logical View or Table. The use of subschemas provides a partial
view of this data. For example, a Logical View represents the American
states. You can define a "telephone" subschema that groups the
data that is 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 several subsystems
in the -SS Lines tab of a Logical View. In our
example, you can define two subsystems: a subsystem for the eastern
states and another subsystem for 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 an
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 Add
a subschema line. As a result, an 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
a Pactables Table. A Y type line is added to
the list.
- When you create a subschema or subsystem, a Definition section
opens. You can then define the characteristics of the new subschema
or subsystem . The name and number of the new subschema or subsystem
are automatically displayed on the corresponding line in the list.
- To remove a line from the list, select a line and click Remove.
- To sort the SS lines in the list, select a line and move
it by clicking the corresponding direction button.
Note: The possible actions with the
buttons are also available in the contextual menu of the table.