...
Our functionality enables this conversion automatically, as it finds the currency key during the data load and changes the particular amount into a proper value, and stores it in target storage.
You can apply currency conversion to all fields or only to selected ones using the corresponding button "Apply currency conversion" in the transformation screen of the Extraction Process as shown on in the screenshot below.
...
You can also adjust it manually by using the “Go To” button.
...
| Note |
|---|
Note:
|
...
You can apply conversion routine rules to all fields or only to selected ones using the corresponding button "Apply conversion routines" in the transformation screen of the Extraction Process as shown on in the screenshot below. After clicking on that button, the program will loop through selected fields and check their domains. If it finds a conversion routine in the definition of a domain, it will set respective rules and generate value expressions of the following view: "ALPHA ( ESRRE )", where "ALPHA" is a conversion routine and "ESRRE" is a source field.
...
You can also set it manually by using the "Go To" button as shown on in the screenshot below. Search-help will display all conversion routines available on the system.
...
| Note |
|---|
The usage of this business function is dependent on the SNP Glue™ table structure. You need to replace SAP data elements of date-like format with character-like data elements because of the resulting format being character-like. You can set the replacement of data elements to apply automatically in the transaction /DVD/GL_SETT by specifying the parameters DEFAULT_DATE_FORMAT and ROLLNAME_REPLACEMENT_DATE. More information about these parameters and their meaning can be found in the chapter Glue Settings. |
...
| Note |
|---|
The usage of this business function is dependent on the SNP Glue™ table structure. You need to replace SAP data elements of a time-like format with character-like data elements because of the resulting format being character-like. You can set the replacement of data elements to apply automatically in the transaction /DVD/GL_SETT by specifying the parameters DEFAULT_TIME_FORMAT and ROLLNAME_REPLACEMENT_TIME. More information about these parameters and their meaning can be found in the chapter Glue Settings. |
...
The Xfeld to Boolean function allows you to translate the ABAP XFELD or FLAG field to BOOLEAN expressions, e.g. 1/0 or T/F or TRUE/FALSE. You can automatically apply this function on all fields which that use domain XFELD or FLAG by pressing Apply Xfeld to Boolean from the toolbar of the Extractor 2.0 transformation screen.
XFELD_TO_BOOLEAN( VALUE, TRUE_SYMBOL, FALSE_SYMBOL ) → example: function XFELD_TO_BOOLEAN( FAILED, "1", "0" ) will take the value of field FAILED and translate it to 1(TRUE) or 0(FALSE).
...
The original value is transformed into a more meaningful one. For example, you can easily transform the abbreviation 'AA' into a the meaningful term 'American Airlines'.
Keep in mind that the data type needs to be adjusted so that longer texts fit into the target field. More information can be found in the section /wiki/spaces/GLUE/pages/915407129 Data Dictionary - Data Enrichment (Meaningful values).
...
For every data element (e.g., 'AA') there are different ways how to transform values. This information is stored in a database table and can be a part of customizing settings. You can adjust the settings in the SNP Glue™ Cockpit.
...
In the case values of the data, the element RSSID is included in the Master data table, then by a SID conversion, they are converted into a value from this table. However, this conversion makes sense for HANA-optimized cubes without dimension tables and the F table already contains SID values (this points directly to the values in the Master data table). Every part of the process (adjusting fields during table creation and making rules in the extractor) is performed automatically. For example, the source table can look like this:
...
And an An example of converted values in the target table:
...
Assigns the ‘I'(Insert), 'U’(Update), or 'D'(Delete) flag according to changes made for a specific row. This is possible if Fetcher has TRIGGER delta type selected and also the Read deleted entries setting is checked. Otherwise, the target field value stays blank.
CDC timestamp
Assigns the timestamp of the change made for a specific row. This is possible if Fetcher has TRIGGER delta type selected and also the Read deleted entries setting is checked. Otherwise, the target field value stays blank.