What's New in SAP Agile Data Preparation 1.0 SP14

Data Acquisition

Clipboard Content Upload

In this version you can copy tabular data from any content from an open file or web browser on your local computer and paste it into a worksheet in SAP Agile Data Preparation.

Import Data from Clipboard

XML Attributes

In this version, your XSD file can now contain the xs:attribute tag when you can upload an XML file.

For more information, see Upload a New File.

Data Preparation

Combine or Split Multiple Columns

In this version, you can combine multiple columns into one or split a column into multiple columns.

For more information, see the following topics:

Date and Time Formatting
In this version, you can import data from an SAP HANA table or view containing columns with the following data types and choose the format to display this data:
HANA Data Type Agile Data Preparation Data Type

DATE

DATE

TIME

TIME

TIMESTAMP

DATETIME

SECONDDATE

DATETIME

Actions on the Column

Edit A Cell

In this version, you can edit the contents of an individual cell if your worksheet contains primary keys.

Edit Cell

Filter Worksheet on a Column Value

In this version, you can filter a worksheet on a specific column value if your worksheet contains primary keys.

Filter Worksheet By Column Value

Add A Column

In this version, you can add a column if your worksheet contains primary keys.

Data Profiling

Functional Dependencies

Data profiling can now determine functional dependencies that exist when one column uniquely determines the value of another column, and SAP Agile Data Preparation provides interactive diagrams to analyze these functional dependencies.

For more information, see Functional Dependencies.

Data Quality

Enhanced Data Quality User Interface

In this version, the dialogs to change the settings for Cleanse Worksheet and Remove Duplicate Records have been enhanced to simplify navigation, be consistent with other dialogs, and improve feedback when items are invalid.

For more information, see the following topics:

Rules Collaboration: Export and Import Rules

In this version, business users and data steward can share rules coming from the worksheets and rules coming from the data domains from a central and managed repository. It will also allow export or import these rules using flat files

For more information, see:

Import Rules

Export Rules

Rules Collection Management

In this version, data stewards can manage rules in a central repository..

For more information, see Rule Collection Management

Worksheet Rules User Interface Enhancements

In this version, the worksheet rules user interface provides enhancements to more easily access rules and specify the ID for each row.

Administration

Customize SAP HANA User Parameters

You can customize a subset of SAP HANA user parameter keys when you install or upgrade SAP Agile Data Preparation.

For more information, see Customize SAP HANA User Parameter Keys.

You can change the key of the following SAP HANA user parameters:
Parameter Key

Purpose

sap.hana.im.adp.firstname

Tracks the first name of the user

sap.hana.im.adp.lastname

Tracks the last name of the user

EMAIL ADDRESS

Tracks the email address of the user