Opening the Destination Settings #
- Create or select an existing extraction (see also Getting Started with Table).
- Click [Destinations]. The window “Destination Settings” opens.
The following settings can be defined for the destination:
Destination Settings #
Table Name #
determines the name of the target table. You have the following options:
- Same as name of SAP object: Copy the name of the SAP object
- Same as name of extraction: Adopt name of extraction
Custom: Here you can define your own name.
- Append timestamp: adds the current timestamp in the format [_YYYY_MM_DD_hh_mm_ss_fff] to the file name of the extraction.
Column name style #
Defines the style of the column name. Following options are available:
- Code: The SAP technical column name is used as column name in the destination e.g., MAKTX.
- PrefixedCode: The SAP technical column name is prefixed by SAP object name and the tilde character e.g., MAKT~MAKTX
- CodeAndText: The SAP technical column name and the SAP description separated by an underscore are used as column name in the destination e.g., MAKTX_Material Description (Short Text).
- TextAndCode: The SAP description and the SAP technical column name description separated by an underscore are used as column name in the destination e.g., Material Description (Short Text)_MAKTX.
Date conversion #
Convert date strings
Converts the character-type SAP date (YYYYMMDD, e.g., 19900101) to a special date format (YYYY-MM-DD, e.g., 1990-01-01). Target data uses a real date data-type and not the string data-type to store dates.
Convert invalid dates to
If an SAP date cannot be converted to a valid date format, the invalid date is converted to the entered value. NULL is supported as a value.
When converting the SAP date the two special cases 00000000 and 9999XXXX are checked at first.
Convert 00000000 to
Converts the SAP date 00000000 to the entered value.
Convert 9999XXXX to
Converts the SAP date 9999XXXX to the entered value.
Dataset ID of the Table.This will be automatically generated by the MSTR server and can be found in the log. The Dataset ID is set automatically for the default DropAndCreate Update Policy. For other Update policies it can be set manually.
Optional. Set the name of an existing folder under My Objects in Microstrategy. The Cube will be generated in the defined folder.
Describes, how data is written to MSTR. DropAndCreate is the default value. Table will be dropped and created again. Data will be then inserted. Add: add data to the existing table. Dataset ID is required. Update: will update the metric values in the data set where there is already a matching key in the dataset; new records are ignored. Upsert: Upsert will update existing records and then add any new ones as well. Replace: Table will be truncated. Data will be then inserted. Dataset ID is required.
Attributes and metrics
Attributes and metrics will be defined automatically based on the data types of the source object. If you wish to redefine attributes or metrics click on the correspondent button and then click to generate the JSON definition to modify the definition.