Acquiring, Preparing, and Modeling Data with SAP Datasphere
Acquiring, Preparing, and Modeling Data with SAP Datasphere
Content
Acquiring, Preparing, and Modeling Data with SAP Datasphere
Creating, Finding, and Sharing Objects
Working in SAP Datasphere Spaces
Repository Explorer
Natural Language Search
Folders
Sharing Entities and Task Chains to Other Spaces
Importing and Exporting Objects in CSN/JSON Files
Importing Objects from a CSN/JSON File
Exporting Objects to a CSN/JSON File
Importing and Exporting Objects via the Command Line
Discovering Data and Assets in the Catalog
Searching for Data Products and Assets in the Catalog
Natural Language Search
Filter Category Details
Installing Data Products
Data Product Details
Installing Marketplace Data Products
Marketplace Data Product Details
Managing Marketplace Data Products
Reviewing Data Provider Profiles
Accessing Catalog Assets
Catalog Asset Details
Acquiring Data
Semantic Onboarding
Importing Objects with Semantics from SAP Systems
Importing Entities with Semantics from SAP S/4HANA
Importing Entities with Semantics from SAP HANA Cloud
Importing Entities with Semantics from SAP BW∕4HANA or SAP BW Bridge
Importing Tables and Views from Sources
Import Remote Tables
Review and Edit Imported Table Properties
Restrict Remote Table Data Loads
Replicate Remote Table Data
Accelerate Table Data Access with In-Memory Storage
Process Source Changes in the Table Editor
Process Source Changes for Several Remote Tables
Modify or Duplicate Remote Tables
Previewing, Filtering and Reordering Remote Tables Data
Creating a Local Table
Columns
Column Data Types
Load or Delete Local Table Data
Maintain Local Table Data
Partitioning Local Tables
Capturing Delta Changes in Your Local Table
Creating a Local Table from a CSV File
Column Properties and Profiling
Apply Data Transforms
Concatenate Columns
Split a Column
Extract Text to a New Column
Change the Case of a Text Column
Find and Replace Data
Filter and Delete Rows
Creating a Replication Flow
Add the Source for a Replication Flow
SAP S/4HANA and Other ABAP Sources for Replication Flows
Cloud Storage Provider Sources for Replication Flows
SAP ECC and SAP BW Sources for Replication Flows
Confluent Kafka Sources for Replication Flows
Secure File Transfer Protocol (SFTP) Sources for Replication Flows
SQL and Script View Source Objects for Replication Flows
Add the Target for a Replication Flow
SAP Datasphere Targets for Replication Flows
Cloud Storage Provider Targets for Replication Flows
Google BigQuery Targets for Replication Flows
Apache Kafka Targets for Replication Flows
Confluent Kafka Targets for Replication Flows
SAP Signavio Targets for Replication Flows
Secure File Transfer Protocol (SFTP) for Replication Flows
Configure a Replication Flow
Reusing Objects as Source or Target in Several Replication Flows
Configure Email Notification for Replication Flow Failure at Object Level
Source and Target Connections and Load Types for Replication Flows
Unsupported Data Types in a Replication Flow
Define Filters in a Replication Flow
Define Mappings in a Replication Flow
Define Custom Projection Logic in a Replication Flow
Modify a Replication Flow
Premium Outbound Integration
Sizing, Capacity Planning, and Load Balancing for Replication Flows
Run a Replication Flow
Delete a Replication Flow, or a Replication Object
Creating a Data Flow
Use Replication Flows and Transformation Flows to Load and Write Data
Add a Source to a Data Flow
Create a Join in a Data Flow
Create a Union in a Data Flow
Create a Projection in a Data Flow
Create a Calculated Column in a Data Flow
Create an Aggregation in a Data Flow
Create a Script in a Data Flow
Create an Input Parameter in a Data Flow
Add or Create a Target Table in a Data Flow
Script Operator Python Reference
Process Source/Target Changes in a Data Flow
Run a Data Flow
Creating a Task Chain
Run a Task Chain
Run Parallel Tasks in a Task Chain
Nest and Share Task Chains
Run Open SQL Procedures in a Task Chain
Run SAP BW Bridge Process Chains in a Task Chain
Run API Tasks in a Task Chain
Configure Email Notification
Create Input Parameters in Task Chains
Create Output Parameters in Task Chains
Select Task Ports in a Task Chain
Managing Tasks via the REST API
Acquiring and Preparing Data in the Object Store
Creating a Local Table (File)
Capturing Delta Changes in Your Local Table (File)
Data Types Supported By Local Tables (File)
Preview and Edit Local Table (File) Data
Deleting Local Table (File) Records
Creating a Transformation Flow in a File Space
Converting Local Table Data Types from a HANA Space to a File Space
List of Functions Supported by a Transformation Flow (in a File Space)
Creating a Python Operator
Python Operator Reference
Preparing Data
Creating a Graphical View
Add a Source to a Graphical View
Create a Join in a Graphical View
Create a Union in a Graphical View
Reorder, Rename, and Exclude Columns in a Graphical View
Create a Calculated Column in a Graphical View
Create a Geo-Coordinates Column in a Graphical View
Create a Currency Conversion Column in a Graphical View
Create a Unit Conversion Column in a Graphical View
Insert Column Values in a SQL Expression
Create an Input Parameter in a Graphical View
Filter Data in a Graphical View
Aggregate Data in a Graphical View
Apply a Data Access Control to a Graphical or SQL View
Persist Data in a Graphical or SQL View
Edit Custom CSN Annotations in a View or Table
Visualize Column and Input Parameter Lineages in a Graphical View
Process Source Changes in a Graphical View
Replace a Source in a Graphical View
Creating an SQL View
Process Source Input Parameters in an SQL View
Process Source Changes in an SQL View
Creating a Transformation Flow
Create a Graphical View in a Transformation Flow
Create an SQL View in a Transformation Flow
Create or Add a Target Table to a Transformation Flow
Run a Transformation Flow
Processing Changes to Sources and Target Tables
Process Target Changes in the Transformation Flow Editor
Process Source Changes in the Graphical View Editor
Process Source Changes in the SQL View Editor
Creating an Intelligent Lookup
Prepare Input and Lookup Entities
Create an Exact Match Rule
Create a Fuzzy Match Rule
Configure the View Output by an Intelligent Lookup
Process Matched Results
Process Review Results
Process Multiple Match Results
Process Unmatched Results
Example: Harmonizing County Data for UK Charging Sites
Example: Adding Latitude and Longitude Data with a Multi-Rule Intelligent Lookup
Creating an Entity-Relationship Model
Create a Table in an E/R Model
Create a View in an E/R Model
Create an Association in an E/R Model Diagram
Add Related Entities to an E/R Model Diagram
Using the Source Browser
Add Objects from the Repository
Import an Object from a Connection or Other Source
Import Multiple Objects from a Connection
Viewing Object Data
Analyzing View Performance
Modeling Data in the Data Builder
Modeling Facts, Dimensions, Text Entities, and Hierarchies
Create a Fact to Contain Measurable Data
Create a Dimension to Categorize Data
Create a Fiscal Time Dimension
Create a Text Entity for Attribute Translation
Create an External Hierarchy for Drill-Down
Create a Hierarchy with Directory
Specify Measures to Analyze
Specify Attributes as Keys, Units, and Other Characteristics
Specify Semantic Types for Measures and Attributes
Set Key Columns to Uniquely Identify Records
Create an Association to Define a Semantic Relationship Between Entities
Add a Hierarchy to a Dimension
Enable Time-Dependency for a Dimension or Text Entity
Converting Currency and Unit Values
Enabling Currency Conversion with TCUR* Tables and Views
Enabling Unit Conversion with T006* Tables and Views
Generate Semantic Information
Analytical Datasets (Deprecated)
Create a Story Filter (Deprecated)
Creating an Analytic Model
Dimensions in the Analytic Model
Create an Analytic Model Directly From a View or Table
Add a Fact to an Analytic Model
Replace the Fact Source of an Analytic Model
Changing the underlying Analytic Model
Add a Dimension to an Analytic Model
Add a Prefix or a Suffix to Dimension Attributes
Add a Fiscal Time Dimension
Create a Measure in an Analytic Model
Create a Calculated Measure
Functions for Calculated Measures
Create a Restricted Measure
Functions for Restricted Measures
Create a Count Distinct Measure
Create a Conversion Measure for Currencies
Use Variables for Conversion
Scenarios for Currency Conversion
Create a Conversion Measure for Units
Aggregation and Exception Aggregation
Create a Non-Cumulative Measure
Non-Cumulative Measures
Example for a Non-Cumulative Measure
Create a Variable in an Analytic Model
Create a Standard Variable
Time-Related Variables
Create a Restricted Measure Variable
Create a Filter Variable
Create a Reference Date Variable
Derived Variables
Dynamic Default
Create a Structure for an Analytic Model
Create a Calculated Structure Member
Create a Restricted Structure Member
Configure Collision Handling
Apply a Data Access Control to an Analytic Model
Create a Global Filter in an Analytic Model
Preview Data in an Analytic Model
Sharing Analytic Models to Other Spaces
Exposing Data For Consumption
Modeling Data in the Business Builder
Example for Using the Business Builder
Business Builder Start Page
Creating a Business Entity
Define Measures
Measure Types
Use Currency Conversion
Aggregation and Exception Aggregation
Define Attributes
Attribute Types
Define a Key
Define Associations
Define Input Parameters
Add an External Hierarchy
Authorization Scenario
Creating an Authorization Scenario
Assigning an Authorization Scenario
Using an Authorization Scenario in a Consumption Model
Creating a Fact Model
Define Measures
Define Attributes
Expose Dimension Sources
Define Filters
Creating a Consumption Model
Define Attributes
Attribute Types
Define Measures
Add an External Hierarchy
Define Filters
Define Perspectives
Change the Data Source of a Business Entity
Create Versions of an Object
Previewing Data in Business Builder Objects
Saving and Deploying Data Objects
Importing SAP BW∕4HANA Models
Imported Objects
Object Lifecycles and Dependencies
Saving and Deploying Objects
Validating Objects
Validating View Data
Collect Unassigned Fact Records for Inclusion in Aggregations and Visualizations
Releasing Stable Views for Consumption
Packages
Impact and Lineage Analysis
Modifying Objects That Have Dependent Objects
Review the Objects That Depend on Your Table or View
Namespaces
Reviewing and Restoring Object Versions
Deleting Objects
SQL and SQLScript Reference
SQL Reference
SQL Functions Reference
SQLScript Reference