SAP has released version 2024.9 of SAP Datasphere. Enhancements in administration, data cataloging, data integration, and data modeling.
There are 1 administration, 2 data cataloging, 4 data integration, and 5 data modeling enhancements in version 2024.9 of SAP Datasphere.
Administration
1 You can now add a visual tenant type indicator to distinguish which system you are using. For example, between a test or production system. When enabled, a colored information bar is visible to all users of the tenant, and the browser favicon is updated with the matching color. Display Your System Information
You can add a title and choose a color for the system information. It’s a very simple, but very useful enhancement. Users should know what system they are using. It’s critical during the SIT, UAT phase of the project.
Data Cataloging
1 You can add an SAP Datasphere, SAP BW bridge system to the catalog. With this addition, metadata for the following objects from SAP BW Cloud systems are monitored and extracted to the catalog.
- ADSO (Advanced DataStore Object)
- AREA — (InfoArea)
- HCPR (Composite Provider)
- IOBJ (InfoObject)
- LSYS (Source System)
- RSDS (DataSource)
- TRCS (InfoSource)
- TRFN (Transformation)
Once extracted, you can publish these objects as assets to the catalog. Connecting to Data Sources
In addition to SAP Datasphere and SAP Analytics Cloud, you can now connect to SAP BW Bridger and add objects to the catalog. The catalog does not automatically extract new or updated metadata from the source system. To synchronize the catalog with the source system, choose Synchronize System.
2 Assets from SAP Datasphere, SAP BW bridge source systems appear in the impact and lineage diagram. Evaluating Catalog Assets
Since the SAP BW Bridge is now one of the systems for Catalog Assets, you can see the SAP BW Bridge in the visual impact and lineage analysis diagram.
Data Integration
1 For the connection types SAP ABAP, SAP BW, SAP ECC, and SAP S/4HANA On-Premise, we’ve added RFC Serialization to the advanced connection properties. The property is available with Data Provisioning Agent version 2.3.7.2 or higher. You can use it to specify whether to use fast column-based serialization or row-based serialization when transferring data. The default is column-based serialization.
Remote Function Call (RFC) is one of the connection options for all SAP ABAP, SAP BW, SAP ECC, and SAP S/4HANA on-premises systems. Now you can take advantage of the serialization feature of RFC. Check out RFC: New Fast Serialization (New) and How to Profit from FAST RFC Serialization by @thomas_weiss
2 When the source system is not available, you can disable real-time data replication from the Remote Tables monitor or from the table editor of the Data Builder. The data access of your remote table is switched from Replicated (Real-time) to Replicated (Snapshot), and the replicated data are kept to allow further consumption or actions on the object such as deleting or changing the properties of the connection. Disabling Real-Time Data Replication
It’s as simple as selecting one or more remote tables in the Remote Tables Monitor and clicking Data Replication Disable Real-Time Data Replication, which changes the data access from Replicated (Real-Time) to Replicated (Snapshot).
3 For local tables as the source of a replication flow, you can now also use local tables that are enabled for delta capturing. However this is still only possible for load type Initial Only ( not Initial and Delta). Add a Source
When creating replication flows, you can select Datasphere itself as the source connection, the source container is automatically defined as the space you are in. The load type is automatically set to Initial Only because Initial and Delta is not currently supported!
4 To ensure better resilience, the SQL procedure to persist view data is always executed asynchronously.
If the persistent view data is asynchronous, you need to look at all views in the Data Integration Monitor.
Data Modeling
1 When you create a data flow and the data source come from Open Connectors, you can define filter conditions to apply on the data. Add a Source
Now not only for CDI, OData, and ABAP CDS but also for Open Connectors sources you can add filters. Check out Open Connectors Connections.
2 When an association in the underlying views or tables of an analytic model is changed or deleted, you can still save the analytic model, but you get an error message and the status of the analytic model changes to design time error.
Hmm, is it really an enhancement? Before this enhancement, what was the state of the analytical models when the underlying view association was changed or deleted?
3 You can now create and update modeling objects of any type from the command line (CLI) using the following commands: Manage Modeling Objects via the Command Line.
- datasphere objects <object-type> create — space <id> — file-path <file>.json
- datasphere objects <object-type> update — space <id> — technical-name <name> — file-path <file>.json
The syntax of datasphere objects as you see more options to handle:
datasphere objects <object-type> list
— space id
[ — technical-names <name>[,…]]
[ — output <file>.json]
[ — select “<property[,…]>”]
[ — filter “<property operator value>[ and|or …]”]
[ — top <n>]
[ — skip <n>]
4 If your SAP S/4HANA Cloud connection supports using replication flows to load data to local tables, the Import Entities dialog will now default to this data access setting. Importing Entities with Semantics from SAP S/4HANA
With Import Entities, you can automatically create more Business Builder and Data Builder entities for CDS views by leveraging their rich semantics to import higher-level objects and track and include associations to dimensions, hierarchies, and text entities.
5 You can now create non-cumulative measures for analytic models. This type of measure is used for cases where measure values describe a state that is not changing every day. For example, you can use non-cumulative measures to calculate the stock in a warehouse, or the bank balance of an account. Create a Non-Cumulative Measure
Another simple nice extension. Once you create the measure of the analytical model, select Non-Cumulative Measure and provide the base calculation.
References
- What’s New in SAP Datasphere. April 23, 2024. Version 2024.9
- What’s New in SAP Datasphere Version 2024.9 — Apr 23, 2024 at medium.com/@tncykarc
- SAP Managed Tags:
2 Comments
