Knowledge Base Academy Community My Tickets

Home Knowledge Base Academy Community My Tickets

Fabric 7.0

Knowledge Base LU Schema Window

LU Schema Window

A Fabric project has a tree-like structure known as the Project Tree; it displays entities in a hierarchical order. The Project Tree is displayed on the left side of the K2View Fabric Studio window and its Logical Units (LUs) are located under the Logical Units branch.

The following objects are located under each Logical Unit (LU) in the Project Tree:

Schema.
Java - Globals and Functions.
Resources, files that can be saved as part of a project. E.g., an Excel file.
Tables.
Broadway.

Translations.
Parsers.
Instance Groups: lists of instances to be migrated into Fabric for the LU.
Jobs.
IIDFinder.

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

Logical Unit Schema Window

The Logical Unit Schema window has three main sections:

Logical Unit Schema Diagram

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

A Logical Unit schema 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

The Logical Unit schema 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 make the structure of the table schema clearer, group or ungroup 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 Tabs Panel

Properties Tab	Contains the properties on an LU level.
References Tab	Used to configure the Reference Tables that are accessible from this LU.
Enrichment Order Tab	Defines the execution order of Enrichment functions using the up and down arrows. Only Enrichment functions - directly related to specific LU tables - are included in the display.
DB Objects Tab	Displays the list of objects in the source database according to the DB Interface selected in the DB Connection field. DB objects can be refreshed by clicking on the Refresh icon adjacent to the DB Connection dropdown list. Dragging an object to a diagram creates a new table in the schema.
Objects Tab	Displays the list of all LU tables defined for the LU. Drag the 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 a search of a subset of tables included in the schema.

Logical Unit Properties Panel

The properties panel displays the schema properties. It can be collapsed or expanded by clicking the icon in the upper right corner of the schema window.

Sync

Sets the sync timeout and sync method on an LU level.

Sets the Event functions that are triggered following a Sync's success or failure or following a successful Delete instance.

Misc

Contains various settings such as storage, cache location and Enable data encryption.

Dependent References

Used to configure the Reference Tables that are accessible from this LU.

The LU Diagram window displays the following toolbar - by default:

You can customize your window by adding or deleting toolbars to/from diagram windows:

	Group SubGraph.
	Ungroup SubGraph.
	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.

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:

	Refresh Schema's elements that are based on changes done externally to this window. For example, when a table was edited via the project tables folder or when population inputs were updated at the population editor.
	Magnifier - activated when clicked; can be moved anywhere over the schema diagram in order to magnify existing features.
	Ungroup, Remove the selected tables from the group, in case you select tables; Remove the group if a group is selected.
	Group the selected tables.
	Add a new table to the schema by either creating one or selecting one from the list.
	Schema auto-layout.
	Open the Data Viewer popup in order to run queries on IID of the current LU.
	Open the Table Data Viewer bottom panel. The data will be displayed according to the selected table.
	Open the schema's mini-map and navigation panel.
	Zoom in/zoom out.
	Search a table or a table's group in the LU schema.