Navigating an LU Schema

When creating or editing a Logical Unit schema the following options are used to navigate, configure and display information:

  • Diagram Outline tab, a representation of the LU schema table’s list.
  • Navigation pane, an overview of the LU schema located in the right corner of the working area.
  • LU working area, where view options can be set.

Click for more information about the Diagram Outline and Toolbars.

How Do I Use the Diagram Outline?

The Diagram Outline displays an overview of the LU structure and can be used to search for a subset of tables included in the Schema.

image

To search for an LU table in an LU schema:

  1. Open the LU Schema window.
  2. Click the Diagram Outline tab in the right panel.
  3. In the Search field, type the name of the table or column and then click it in the displayed list. The table or column is highlighted with a green border.

What is the Navigation Pane?

The Navigation pane in the right corner of an LU schema is used to move between the different areas of a Schema. This is useful when looking at large Logical Units with many tables or hierarchy levels.

image

To hide the Navigation Pane use the context menu and uncheck the Show Overview Control. Studio lets you to reveal it back when needed via the context menu on the Working Area.

What are the LU Working Area View Options?

LU Tables relationship options:\ In the LU working area, right click an LU table object to display a context menu with the following actions:

set as: root 

Sets the table object as the root of this LU.

show only Predecessor nodes

Shows only objects and links that are predecessors of this object / field.

show only successor nodes

Shows only objects and links that are successors of this object / field.

show only connected nodes

Shows all objects and links connected to this object / field.

show all nodes

Shows all objects and links in this table.

clear input links

Clears all input links from objects in the Schema.

clear output links

Clears all output links from this LU table to its children Table Populations.

clear all links

Clears all input and output links in the LU tables.

show data

When clicked, a Query Builder window opens automatically in the newest LU file.

Click for more information about the Data Viewer.

 

For Example

Taking the CONTRACT table from the CUSTOMER LU as an example, the following illustrates key table relationship view options:

Show only predecessor nodes

image

Show only successor nodes image

Show only connected nodes image

Display Options

In the LU working area right click anywhere to display a context menu with the following actions:

Collapse All Views

Collapses the LU table columns.

Expand All Views

Expands the LU tables display.

show all nodes

Shows all objects and links in the LU Schema.

Automatic Layout

Arranges table items in an orderly manner.

Automatic Layout and Fit

 

Arranges table items in an orderly manner and adjusts the Table Population resolution to fit the screen.

When creating or editing a Logical Unit/Data Product schema the following options are used to navigate, configure and display information:

Click for more information about the Schema, Tabs, and Toolbars.

How Do I Use the Table List?

From the project's explorer tree, expand Implemenation > Logical Units/Data Products > [Logical Unit/Data Product Name] > Tables

The explorer tree will show a list of tables and their populations that are in the Logical Unit/Data Product:

  • Each table name is next to a <> icon
  • Each population name is under the table to which it belongs, with the name of the table attached to the beginning of the population name.

image

-- Click on a table name, and the table schema editor for that table will appear in the right window.

-- Click on a population name, and a Broadway flow diagram will appear in the right window.

How Do I Use the Logical Unit/Data Product Schema (diagram outline)?

From the project's explorer tree, expand Implemenation > Logical Units/Data Products > [Logical Unit/Data Product Name] > Schema

The Schema (diagram outline) displays an overview of the LU/DP structure and can be used to create or delete tables, group or ungroup tables, search for a subset of tables included in the Schema, and view the data included in those tables. For detailed instructions how to carry out these tasks, click here.

image

To search for a table using the diagram outline:

  1. Click the Search table or group pull-down menu from the toolbar on top of the diagram outline. image
  2. Enter the name of the table, and choose the table you want from the list that appears. If the table you are looking for does not appear in the list, it either does not exist in the Schema, or you have made a spelling error.
  3. The table is highlighted with a blue outline.

To search for data in a table using the diagram outline, do one of the following:

  • Click the Data Viewer icon in the toolbar ( image ), and the Data Viewer will open. You can use the Data Viewer to execute an SQL query to retrieve data from a table (you select the table from withing the Data Viewer).
  • Click the Table Data Viewer icon in the toolbar ( image ), and the Table Data Viewer will appear in the lower window. You can use the Table Data Viewer to execute an SQL query to retrieve data from the selected table.

For detailed instructions on how to work with a Logical Unit/Data Product, click here

What is the Navigation Map?

The Navigation map is activated by clicking the navigation map icon in the tool bar ( image ).

This view can be used to move between the different areas of a Schema, and can be useful when looking at large Logical Units with many tables or hierarchy levels.

image

What is in the Properties pane?

The properties pane is accessed by clicking the arrow icon on the far right side of the diagram outline:

image

If you have selected a table, the properties pane for that table appears.

image

If you have not selected a table, the properties pane for the LU/DP Schema appears. You can tell that a table has not been selected, but the LU/DP has been selected when a blue frame forms around the LU/DP Schema.

image

Navigating an LU Schema

When creating or editing a Logical Unit schema the following options are used to navigate, configure and display information:

  • Diagram Outline tab, a representation of the LU schema table’s list.
  • Navigation pane, an overview of the LU schema located in the right corner of the working area.
  • LU working area, where view options can be set.

Click for more information about the Diagram Outline and Toolbars.

How Do I Use the Diagram Outline?

The Diagram Outline displays an overview of the LU structure and can be used to search for a subset of tables included in the Schema.

image

To search for an LU table in an LU schema:

  1. Open the LU Schema window.
  2. Click the Diagram Outline tab in the right panel.
  3. In the Search field, type the name of the table or column and then click it in the displayed list. The table or column is highlighted with a green border.

What is the Navigation Pane?

The Navigation pane in the right corner of an LU schema is used to move between the different areas of a Schema. This is useful when looking at large Logical Units with many tables or hierarchy levels.

image

To hide the Navigation Pane use the context menu and uncheck the Show Overview Control. Studio lets you to reveal it back when needed via the context menu on the Working Area.

What are the LU Working Area View Options?

LU Tables relationship options:\ In the LU working area, right click an LU table object to display a context menu with the following actions:

set as: root 

Sets the table object as the root of this LU.

show only Predecessor nodes

Shows only objects and links that are predecessors of this object / field.

show only successor nodes

Shows only objects and links that are successors of this object / field.

show only connected nodes

Shows all objects and links connected to this object / field.

show all nodes

Shows all objects and links in this table.

clear input links

Clears all input links from objects in the Schema.

clear output links

Clears all output links from this LU table to its children Table Populations.

clear all links

Clears all input and output links in the LU tables.

show data

When clicked, a Query Builder window opens automatically in the newest LU file.

Click for more information about the Data Viewer.

 

For Example

Taking the CONTRACT table from the CUSTOMER LU as an example, the following illustrates key table relationship view options:

Show only predecessor nodes

image

Show only successor nodes image

Show only connected nodes image

Display Options

In the LU working area right click anywhere to display a context menu with the following actions:

Collapse All Views

Collapses the LU table columns.

Expand All Views

Expands the LU tables display.

show all nodes

Shows all objects and links in the LU Schema.

Automatic Layout

Arranges table items in an orderly manner.

Automatic Layout and Fit

 

Arranges table items in an orderly manner and adjusts the Table Population resolution to fit the screen.

When creating or editing a Logical Unit/Data Product schema the following options are used to navigate, configure and display information:

Click for more information about the Schema, Tabs, and Toolbars.

How Do I Use the Table List?

From the project's explorer tree, expand Implemenation > Logical Units/Data Products > [Logical Unit/Data Product Name] > Tables

The explorer tree will show a list of tables and their populations that are in the Logical Unit/Data Product:

  • Each table name is next to a <> icon
  • Each population name is under the table to which it belongs, with the name of the table attached to the beginning of the population name.

image

-- Click on a table name, and the table schema editor for that table will appear in the right window.

-- Click on a population name, and a Broadway flow diagram will appear in the right window.

How Do I Use the Logical Unit/Data Product Schema (diagram outline)?

From the project's explorer tree, expand Implemenation > Logical Units/Data Products > [Logical Unit/Data Product Name] > Schema

The Schema (diagram outline) displays an overview of the LU/DP structure and can be used to create or delete tables, group or ungroup tables, search for a subset of tables included in the Schema, and view the data included in those tables. For detailed instructions how to carry out these tasks, click here.

image

To search for a table using the diagram outline:

  1. Click the Search table or group pull-down menu from the toolbar on top of the diagram outline. image
  2. Enter the name of the table, and choose the table you want from the list that appears. If the table you are looking for does not appear in the list, it either does not exist in the Schema, or you have made a spelling error.
  3. The table is highlighted with a blue outline.

To search for data in a table using the diagram outline, do one of the following:

  • Click the Data Viewer icon in the toolbar ( image ), and the Data Viewer will open. You can use the Data Viewer to execute an SQL query to retrieve data from a table (you select the table from withing the Data Viewer).
  • Click the Table Data Viewer icon in the toolbar ( image ), and the Table Data Viewer will appear in the lower window. You can use the Table Data Viewer to execute an SQL query to retrieve data from the selected table.

For detailed instructions on how to work with a Logical Unit/Data Product, click here

What is the Navigation Map?

The Navigation map is activated by clicking the navigation map icon in the tool bar ( image ).

This view can be used to move between the different areas of a Schema, and can be useful when looking at large Logical Units with many tables or hierarchy levels.

image

What is in the Properties pane?

The properties pane is accessed by clicking the arrow icon on the far right side of the diagram outline:

image

If you have selected a table, the properties pane for that table appears.

image

If you have not selected a table, the properties pane for the LU/DP Schema appears. You can tell that a table has not been selected, but the LU/DP has been selected when a blue frame forms around the LU/DP Schema.

image