New Features in Version 2022.1

dwc Command Line Interface Update

A new version of the dwc command line interface is released with various technical improvements. To update to the latest version, run npm install -g @sap/dwc-cli

For more information, see Install or Update the SAP Datasphere Command Line Interface.

Text Associations

Business entities now support the definition of attributes with texts and language dependent texts. This enables you to display your data with ID and text, or with a language dependent text, when you preview or analyze your data.

For more information, see Define Attributes.

Exception Aggregation

Beside the standard aggregation types (SUM, MIN, MAX, AVG) you can now also use exception aggregation for measures.

For more information, see Define Measures.

Connections App

To improve usability and provide instant access to creating and managing connections, they have been moved from Space Management into a separate Connections app that you can open from the side navigation area with the  (Connections) button. You can still open the app from the Connections section in Space Management.

For more information, see Create a Connection.

Connection Type Generic SFTP

With the new connection type, you can connect to SFTP-based file shares in your local network to consume CSV, JSON, and other files in data flows.

For more information, see Generic SFTP Connections.

Connection Type Microsoft Azure Blob Storage

With the new connection type, you can connect to Microsoft Azure Blob Storage and use the connection in data flows.

For more information, see Microsoft Azure Blob Storage Connections.

Excel File as a Source in Data Flow

You can now import Excel files (.xlsx, .xls) from a remote file storage to your data flow and configure the worksheet to be used.

For more information, see Creating a Data Flow.

Remote Table Data and View Persistency

Processing Source Changes in the Table Editor

The structure of tables that you import from an Open SQL schema or an HDI container can change over time, with columns added or being removed, for example. You can now click Refresh in the table editor to check for and import these structural changes, with validation messages being displayed if the changes risk impacting objects that use the table as a source.

For more information, see Process Source Changes in the Table Editor.

Controlling the Visibility of Measures and Attributes in Stories

You can hide or show measures and attributes in Stories in a graphical view.

For more information, see Specify Measures to Analyze and Specify Attributes as Keys, Units, and Other Characteristics.

Improved Visibility for Input Parameters in Graphical Views

The number of input parameters in a view is now displayed on its symbol (as a source or output) in the graphical view editor. In addition, when you select an input parameter in the output node side panel, each node in which it is used and, if appropriate, its source is highlighted.

For more information, see Create an Input Parameter in a Graphical View and Visualize Column and Input Parameter Lineages in a Graphical View.

Intelligent Lookup

When combining data, there may be no column in your primary entity that contains data to uniquely identify a record in the other entity, and which would thus allow the creation of a standard join. Or, if such a column (a foreign key) exists, its data may be incomplete or unreliable. This can be particularly common when one of the entities comes from outside your organization. It may require a lot of manual work in spreadsheets to join the entities, and the results of this work may not be easy to reuse when new data arrives.

Intelligent lookup is a business-centric, interactive data harmonization environment for subject matter experts, which lets you iteratively join entities by defining rules to match records and then reviewing the results.

For more information, see Creating an Intelligent Lookup.

Connections Removed from Space Management

Starting with this version, you no longer create and manage connections in spaces but directly in the new dedicated app Connections. You can still open the new app from the Connections section in Space Management.

For more information, see Create a Connection.

Information Message and Disabled Features when Run-Time Database is Not Available

On rare occasions when the run-time database is not available, an information message is displayed and certain features that depend on the run-time are disabled.

For more information, see Save and Deploy Your Space.