Maintain Data Elements Tab

This topic is related to the following sections:

• Create & Maintain Subject Areas

• Create & Maintain Datasets

• Bulk Edit of Existing Data Elements

• Maintain Tables and Fields Tab

Data Elements Overview

Data Elements are created and maintained through the Syniti Knowledge Platform, and then imported as a data object into this portion of Syniti Migrate. They are a required prerequisite to Mapping as they serve as the target fields.

Refer to section Data Element Column Details for details.

To access Data Elements, click on the Data Elements tab within a Dataset using pathway Catalog > Dataset Design > Edit Dataset. This page is used to document data elements associated with the Dataset.

The Data Elements tab displays the list of fields that have been toggled as Data Element Active on the Tables and Fields tab. The Data Elements tab of the Dataset contains one panel and all tables are listed in ascending order by Table and then by Fields. It is within this panel that the Data Designer may manage the fields details. The details may be maintained one by one or by using Bulk Edit feature.

The Data Elements grid displays the following columns:

Data Types within the Dataset

Data Types vary depending upon the Working Database used and the Target System used. In the most basic situation, where SQL Server is the Working Database, and SAP ECC or S4H is the Target System, the Data Types for the Tables and Fields and Data Elements tabs are set to the Target System (ECC, S4H) Example:  CHAR, DATS, or NUMC.

The Migration tab contains Data Types for the Working Database being used. For example, the user can view Data Types as:

Alignment of Data Element Values in the List

Note

Edit the order of Data Elements in the multiple panel view by selecting(highlighting) the Data Element and dragging and dropping into the desired order. This automatically adjusts the index of the Data Element(s) you have reordered. If any sort order has been enabled for a column then the drag and drop functionality is disabled, removing the sort order enables drag and drop functionality again.

Activate a Data Element from Tables and Fields

Data Elements may be selected as relevant to the Dataset and marked Active from within the tab for Tables and Fields. Within the lower panel Fields, toggle the Data Element relevancy to Active. This action makes the field display within the tab for Data Elements.

Data Element Column Details

Data Elements provide details for the format of each field including Data Type, Data Length, and Scale. This profiling data may be maintained in the Column Details tab of Data Elements Details page.

Note

There are three profiling scripts stored within the working database SQL Server as stored procedures. The stored procedures allow one table, one schema, or one database to be profiled. The results are stored in two tables (SYN_PROFILE and SYN_PROFILE_VALUES). The stored procedure creates these tables if they do not already exist within the MIGRATE working database. These profiling procedures are:

• Table example - EXEC MIGRATE.dbo.SYN_PROFILE_DATABASE 'TGTECC', 'dbo'

• Database example - EXEC MIGRATE.dbo.SYN_PROFILE_DATABASE 'Adventureworks',NULL

• Schema example - EXEC MIGRATE.dbo.SYN_PROFILE_TABLE 'TGTS4H','dbo','MARA'

  Display the results of this profiling by running the view - SELECT * FROM MIGRATE.dbo.SYN_PROFILE_COLUMN_VALUES from within SQL Server.

Field definitions for Column Details:

Add a New Data Element Independent of Migration (Derived)

The documenting of a process, report, activity, or transaction includes Datasets and Data Elements. Click on the Add  icon to add a new Data Element. Examples of added data elements would include calculated or summarized counts and values in reports or additional validation criteria for a data lake. The Derived Data Element is determined by selecting a Field Type = Derived which updates the page to add Field Mapping for use.

This new Data Element is created by a click on the Add  icon. The details of this newly added data element provides descriptions and formatting associated with the data element. Refer to section Edit Data Element Details for field specific details of this section.

Click SAVE  icon to save the page to activate the FIELD MAPPING button. At this point, the user may enter the Data Mapping Details for this derived field as shown below:

Enter the Mapping Rule, the Datasource, Table, and Field for each of the fields used in this derived field. To add more fields, click on the ADD ROW  button. Field Mapping requires a value to be entered into the field for Comments as it is a required field in order to save a derived field.

When finished with edits, click the Save  icon to complete.

De-Activate a Derived Field from Data Elements

The added data element is stored within a table identified as "Unassigned" within the Tables and Fields tab. If the user should mark this new data element Not Active, it is removed from the list on the Data Elements tab but remains visible in this Unassigned table.

Edit Data Element Details

To maintain individual Data Elements, click on the Edit  icon for the row of data element to change. This action opens the Data Elements Detail page.

The left side of the Data Element page contains the Data Element Details. These fields are supportive of the Data Element's design, usage, classification, and review. Each section of this panel stores valuable information. At the header of this left side panel there are quick use icons as shown below:

Icon	Name	Use
	Save	The Save icon saves the current entries.
	Cancel	The Cancel icon leaves the current page without saving changed data.
	History	The History icon presents a list of the past changes to this Data Element.
	Help	The Help icon links to the page in Syniti help text to provide detailed explanation of this section and use.

While viewing this page in the Edit  mode, the user may enter, or update field values based upon the information listed below:

Note

Vertical section Migration Details is only be visible if the Dataset has been added to a Mapping. The Migration tab is visible as this Dataset is being used as a Migration dataset. The fields allow for edits if the Dataset contains Target Reporting.

The View Details icon is part of the Data Element Details page assist to provide information supporting the associated field.

History of Changes

Provided below is an example of a History of Changes list at the Data Element level. The user clicks on the History  icon to open this page and provide details of the history of changes made to this Data Element.

Note

The Download icon will produce a file on the local drive with details of this table data. The Search icon will provide filtering of data.

Note

As with any page grid of data, on the right upper corner, click the Hamburger Details icon to view the options for show or hide column, filter of rows, and column width. This is extremely handy for situations where the data is fluid and changes or when there are many records that are hard to review in the small window provided for the list. Refer to section Page Grid Options for details.

Once viewing is complete, click the Cancel icon to exit this process.

Field Type Assignment

The Field Type is a configurable field with a drop-down list. The values for this list are added within Administer > Advanced > List Boxes. The values and usage for this field are as follows: