Logical Unit / Data Product Schema Window

A Logical Unit schema's diagram represents the design for a specific data product dataset, its tables, their relations, population flows, synchronization rules and other business definitions.

In order to open the Logical Unit Schema window, go to the Project Tree, click on the LU Name and then on the Schema.

image

image

The Logical Unit Schema window has 3 main sections:

  • Logical Unit schema's diagram
  • Logical Unit tabs panelLogical Unit side panel
  • Logical Unit toolbar

Logical Unit Schema's Diagram

The Logical Unit schema's diagram is a working area where you can design the Logical Unit’s structure.

  • A Logical Unit schema's diagram displays a hierarchy of all business entities related to a Root Table.
  • Each table can have one or more population/s, where each population is linked to its parent table.

Click for more information about Logical Unit Tables.

Click for more information about LU Table Population.

Customer LU Schema Example

image

image

The Logical Unit schema's diagram displays the Root Table, the hierarchy of the tables included in the Logical Unit and the relationships between them:

  • The Root Table of the LU schema is Customer.

  • Each table is displayed with all of its fields in a scrollable table.

  • Each field is displayed in a separate line, by name with a small colored icon. The icon’s color indicates the data type of the field:

    • Grey: Blob.
    • Red: Text.
    • Green: Real.
    • Blue: Integer.

In order to get a clearer view of the schema's structure, you can group a list of tables. For example, group all Billing tables in the Customer LU.

Click for more information about Grouping and Ungrouping LU Tables.

Logical Unit Side Panel

The side panel is divided into several tabs:

Properties Tab

Contains the properties on an LU level.

References Tab

Used for configuring the Reference Tables that are accessible from this LU.

Enrichment Order Tab

Defines the execution order of Enrichment functions using the upward and downward arrows. Only Enrichment functions - directly related to specific LU tables - are included in the display.

DB Objects Tab

Displays a list of objects in the source database according to the selected DB Interface in the DB Connection field.

DB objects can be refreshed by clicking on the Refresh icon adjacent to the DB Connection drop-down list.

Dragging an object to the diagram creates a new table in the schema.  

Objects Tab

Displays a list of all LU tables defined for the LU. Drag a table into the Logical Unit diagram area in order to add it to the LU schema.

Diagram Outline Tab

Displays an overview of the LU structure, and enables searching a subset of tables that is included in the schema.

The side panel is divided into 2 tabs:

The side panel can be collapsed or expanded by clicking the icon in the upper-right corner of the schema window.

Logical Unit Schema Window Toolbar

The LU schema's diagram window displays the following toolbar:

image

 

Group SubGraph

 

Ungroup SubGraph

 

Tables' Reconciliation - Update Tables From Database

When clicked, the LU tables' schema is refreshed from the source database. This action is required when the LU tables' schema has been updated in the source database.

Note: Only current tables are updated. Tables are manually added or deleted from an LU.

 

Refresh Items - refreshes items from an implementation into the LU schema.

You can customize the schema's toolbar by right-clicking on it and selecting 'Customize…'; a pop-up window shall then open, where you can add/remove toolbars to/from the display:

Click for more information about Group and Ungroup SubGraph Objects.

Click for more information about Fabric Studio Diagrams Toolbars.

Click for more information about LU Refresh Options.

The LU Schema toolbar includes the following elements:

image

Add a new table to the schema by either creating one or selecting one from the list.

Refresh schema's elements that are based on changes made outside this window. For example, when a table was edited via the project tables folder or when population inputs were updated in the population editor.

Find tables' columns mismtaches vs the origin data sources tables, for tables reconcilliation purposes.

Ungroup - remove either selected tables from a group (in case you select tables) or an entire group (if a group is selected).

Group the selected tables.

Schema's Auto Layout - automatically arranges and optimizes visualization.

Open the Data Viewer pop-up window in order to run queries on the current LU's IIDs.

Open the Table Data Viewer's bottom panel (height adjustable). The data will be displayed according to the selected table.

Highlight tables - activated when clicked, as explained here.

Magnifier - activated when clicked; can be moved across the schema's diagram to enlarge existing elements, as explained here.

Navigation Minimap - when clicked, it provides an overview of the whole schema, as explained here.

Zoom in/zoom out.

Search elements (tables, table-groups, tables' columns, populations) in the schema, as explained here.

Previous

Logical Unit / Data Product Schema Window

A Logical Unit schema's diagram represents the design for a specific data product dataset, its tables, their relations, population flows, synchronization rules and other business definitions.

In order to open the Logical Unit Schema window, go to the Project Tree, click on the LU Name and then on the Schema.

image

image

The Logical Unit Schema window has 3 main sections:

  • Logical Unit schema's diagram
  • Logical Unit tabs panelLogical Unit side panel
  • Logical Unit toolbar

Logical Unit Schema's Diagram

The Logical Unit schema's diagram is a working area where you can design the Logical Unit’s structure.

  • A Logical Unit schema's diagram displays a hierarchy of all business entities related to a Root Table.
  • Each table can have one or more population/s, where each population is linked to its parent table.

Click for more information about Logical Unit Tables.

Click for more information about LU Table Population.

Customer LU Schema Example

image

image

The Logical Unit schema's diagram displays the Root Table, the hierarchy of the tables included in the Logical Unit and the relationships between them:

  • The Root Table of the LU schema is Customer.

  • Each table is displayed with all of its fields in a scrollable table.

  • Each field is displayed in a separate line, by name with a small colored icon. The icon’s color indicates the data type of the field:

    • Grey: Blob.
    • Red: Text.
    • Green: Real.
    • Blue: Integer.

In order to get a clearer view of the schema's structure, you can group a list of tables. For example, group all Billing tables in the Customer LU.

Click for more information about Grouping and Ungrouping LU Tables.

Logical Unit Side Panel

The side panel is divided into several tabs:

Properties Tab

Contains the properties on an LU level.

References Tab

Used for configuring the Reference Tables that are accessible from this LU.

Enrichment Order Tab

Defines the execution order of Enrichment functions using the upward and downward arrows. Only Enrichment functions - directly related to specific LU tables - are included in the display.

DB Objects Tab

Displays a list of objects in the source database according to the selected DB Interface in the DB Connection field.

DB objects can be refreshed by clicking on the Refresh icon adjacent to the DB Connection drop-down list.

Dragging an object to the diagram creates a new table in the schema.  

Objects Tab

Displays a list of all LU tables defined for the LU. Drag a table into the Logical Unit diagram area in order to add it to the LU schema.

Diagram Outline Tab

Displays an overview of the LU structure, and enables searching a subset of tables that is included in the schema.

The side panel is divided into 2 tabs:

The side panel can be collapsed or expanded by clicking the icon in the upper-right corner of the schema window.

Logical Unit Schema Window Toolbar

The LU schema's diagram window displays the following toolbar:

image

 

Group SubGraph

 

Ungroup SubGraph

 

Tables' Reconciliation - Update Tables From Database

When clicked, the LU tables' schema is refreshed from the source database. This action is required when the LU tables' schema has been updated in the source database.

Note: Only current tables are updated. Tables are manually added or deleted from an LU.

 

Refresh Items - refreshes items from an implementation into the LU schema.

You can customize the schema's toolbar by right-clicking on it and selecting 'Customize…'; a pop-up window shall then open, where you can add/remove toolbars to/from the display:

Click for more information about Group and Ungroup SubGraph Objects.

Click for more information about Fabric Studio Diagrams Toolbars.

Click for more information about LU Refresh Options.

The LU Schema toolbar includes the following elements:

image

Add a new table to the schema by either creating one or selecting one from the list.

Refresh schema's elements that are based on changes made outside this window. For example, when a table was edited via the project tables folder or when population inputs were updated in the population editor.

Find tables' columns mismtaches vs the origin data sources tables, for tables reconcilliation purposes.

Ungroup - remove either selected tables from a group (in case you select tables) or an entire group (if a group is selected).

Group the selected tables.

Schema's Auto Layout - automatically arranges and optimizes visualization.

Open the Data Viewer pop-up window in order to run queries on the current LU's IIDs.

Open the Table Data Viewer's bottom panel (height adjustable). The data will be displayed according to the selected table.

Highlight tables - activated when clicked, as explained here.

Magnifier - activated when clicked; can be moved across the schema's diagram to enlarge existing elements, as explained here.

Navigation Minimap - when clicked, it provides an overview of the whole schema, as explained here.

Zoom in/zoom out.

Search elements (tables, table-groups, tables' columns, populations) in the schema, as explained here.

Previous