Modeling
Graphical Modeling
Creating Data Flows or Data Flow Templates
Adding Objects and Connections to the Data Flow
Using SAP Data Flow Templates
Naming Conventions for SAP Dataflow Templates
Naming Conventions for InfoProviders of SAP Dataflow Templates
Naming Conventions for InfoSources and DTPs for SAP Dataflow Templates
LSA100: Basic Flow - Layering Data & Logic
LSA110: Basic Flow Extensions - CM & Harmonization InfoSource
LSA300: Tactical Scalability - Flow Split Logical Partitioning
LSA310: Scalability - Flow Split and InfoSources
LSA315: Scalability - InfoSources & Single ERP Source
LSA320: Scalability - Entire Data Flow Split
LSA330: Scalability - Flow Split Using a Pass Thru DataStore Object
LSA400: Scalability & Domains - Strategic Flow Split
LSA410: Scalability & Domains - Strategic Flow Collect
LSA420: Scalability & Domains - Business Transformation Layer
Showing and Creating Documentation
Saving Data Flow Documentation as an HTML File
Additional Functions in Graphic Data Flow Modeling
Enterprise Data Warehouse Layer
DataSource
Functions for DataSources
DataSource Maintenance in BW
Editing DataSources from SAP Source Systems in BW
Creating DataSources for File Source Systems
Creating a DataSource for UD Connect
Creating DataSources for DB Connect
Creating DataSources for Web Services
Emulation, Migration and Restoring DataSources
Using Emulated 3.x DataSources
Migrating a DataSource 3.x Manually (SAP Source System, File, DB Connect)
Migrating 3.x DataSources (UD Connect, Web Service)
Restoring 3.x DataSources Manually
Persistent Staging Area
DB Memory Parameters
Deleting Requests from the PSA
Previous Technology of the PSA
Persistent Staging Area
Types of Data Update with PSA
Checking and Changing Data
Checking and Changing Data Using PSA-APIs
Versioning
DB Memory Parameters
Reading PSA and Updating a Data Target
Creating InfoObjects
Creating InfoObject Catalogs
Additional Functions in the InfoObject Catalog
InfoObject Naming Conventions
Creating InfoObjects: Characteristic
Tab Page: General
Tab Page: Business Explorer
Mapping Geo-Relevant Characteristics
Static and Dynamic Geo-Characteristics
Shapefiles
Delivered Geo-Characteristics
SAPBWKEY Maintenance for Static Geo-Characteristics
Creating a Local Copy of the Shapefile
Downloading BW Master Data into a dBase File
Maintaining the SAPBWKEY Column
Uploading Edited Shapefiles into BW Systems
Geocoding
Downloading BW Master Data into a dBase File
Geocoding Using ArcView GIS
Converting dBase Files into CSV Files
Tab: Master Data/Texts
Tab Page: Hierarchy
Tab Page: Attributes
Tab Page: Compounding
Tab Page BWA Index
Characteristic Compounding with Source System ID
Assigning a Source System to a Source System ID
Navigation Attribute
Creating Navigation Attributes
Performance of Navigation Attributes in Queries and Value Help
Transitive Attributes as Navigation Attributes
Conversion Routines in the BW System
ALPHA Conversion Routine
BUCAT Conversion Routine
EAN11 Conversion Routine
GJAHR Conversion Routine
ISOLA Conversion Routine
MATN1 Conversion Routine
NUMCV Conversion Routine
PERI5 Conversion Routine
PERI6 Conversion Routine
PERI7 Conversion Routine
POSID Conversion Routine
PROJ Conversion Routine
REQID Conversion Routine
IDATE Conversion Routine
RSDAT Conversion Routine
SDATE Conversion Routine
WBSEL Conversion Routine
Creating InfoObjects: Key Figure
Tab Page: Type/Unit
Tab Page: Aggregation
Tab Page: Further Properties
Editing InfoObjects
Additional Functions in InfoObject Maintenance
Modeling InfoObjects as InfoProviders
Using Master Data and Master Data-Bearing Characteristics
Master Data Types: Attributes, Texts, and Hierarchies
Creating and Changing Master Data
Maintaining Time-Dependent Master Data
Time-Dependent Master Data from Different Systems
Deleting Master Data at Single Record Level
Deleting Attributes and Texts for a Characteristic
Activating Master Data
Versioning Master Data
Reorganizing Master Data
Simulate Loading of Master Data
Master Data Lock
Loading Master Data from Source Systems Directly into InfoProviders
Creating InfoProviders
InfoProvider Types
Decision Tree for InfoProviders
InfoProvider for Storing Reusable Data
InfoProvider for Defined Reporting and Analysis Requests
InfoProvider for Ad Hoc Reporting and Analysis Requests
Creating DataStore Objects
Setting the DataStore Object Type
DataStore Object Types
Standard DataStore Object
Write-Optimized DataStore Object
Creating DataStore Objects for Direct Update
APIs of the DataStore Object for Direct Update
Scenario for Using Standard DataStore Objects
Scenario for Using Write-Optimized DataStore Objects
Scenario for Using DataStore Objects for Direct Update
SAP-HANA-Optimized Activation of DataStore Objects
SAP HANA-Optimized DataStore Object (Obsolete)
DataStore Object Settings
Additional Functions in DataStore Object Maintenance
InfoProvider Properties
DB Memory Parameters
Partitioning
Partitioning InfoProviders Using Characteristic OFISCPER
Repartitioning
Multidimensional Clustering
Definition of Clustering
Performance Tips for DataStore Objects.
Integration in the Data Flow
Using Semantic Partitioning
Creating a Semantically Partitioned Object
The Wizard
Creating Transformations for a Semantically Partitioned Object
Creating a DTP for a Semantically Partitioned Object
Creating Process Chains for a Semantically Partitioned Object
Managing Semantically Partitioned Objects
Repartitioning Semantically Partitioned Objects
BAdI: Partitioning Semantically Partitioned Objects
Converting Semantically Partitioned Objects to SAP HANA-Optimized Objects
Integration of Physical Partitioning
Transformation
Rule Type
Transformation Library and Formula Builder
Example for Using the Formula Editor
BAdI: Customer-Defined Functions in the Formula Builder
Structure of Implementation of a Function
Implementation of a Category
Aggregation Type
Rule Group
Creating Transformations
Assigning InfoObjects for Reading Master Data
Assigning InfoObjects for Converting Amounts or Currencies
Assigning InfoObjects for Time Conversion
Conditional Update through Semantic Grouping
Creating a Transformation for a Hierarchy
Examples of a Hierarchy Transformation
Copying Transformations
Error Analysis in Transformations
Testing Rules
Routines in Transformations
Creating Routines
Example: Start Routine
Example: Characteristic Routine
Example: End Routine
Start Routine Parameters
Routine Parameters for Key Figures or Characteristics
End Routine Parameters
Creating Inversion Routines
Inversion Routine Parameters
Example of Inversion Routine
Details for Implementing the Inversion Routine
Regular Expressions in Routines
InfoSource
Recommendations for Using InfoSources
Migrating Update Rules, 3.x InfoSources and Transfer Rules
Differences in Routine Concepts
Example of Migration of an Inversion Routine
Differences When Processing Units
Transformation 3.x
Architected Data Mart Layer
Creating InfoCubes
Enhanced Star Schema
Dimension
Line Item and High Cardinality
Real-Time InfoCubes
InfoCube with Data Persistency in the BWA
Restrictions for the InfoCube with Data Persistence in the BWA
SAP HANA-Optimized InfoCube
Converting Standard InfoCubes to SAP HANA-Optimized InfoCubes
Additional Functions in InfoCube Maintenance
InfoProvider Properties
Checking the Data Loaded into the InfoProvider
Checking the Data Consistency for an InfoCube
Non-Cumulative Value Parameter Maintenance
DB Memory Parameters
Partitioning
Partitioning InfoProviders Using Characteristic OFISCPER
Repartitioning
Clustering
Definition of Clustering
Selection of MDC Dimensions
Reclustering
Recommendations for Modeling InfoCubes
Overview of Loadable InfoSources for an InfoCube
Creating HybridProviders
HybridProvider Structure Based on a DataStore Object
Structure of HybridProviders Based on Direct Access
Modeling Direct Data Access
Creating VirtualProviders Based on Data Transfer Processes
Creating Data Transfer Processes for Direct Access
Structure of the VirtualProvider with Data Transfer Process
Processing Selection Conditions
Creating VirtualProviders Based on 3.x InfoSources
Creating VirtualProviders with BAPI
Creating VirtualProviders with Function Modules
Description of the Interfaces
Modeling Data Flows for Characteristics with Direct Access
Modeling Data Flows for Hierarchies with Direct Access
Creating InfoSets
Special Features of InfoCubes in InfoSets
Additional Functions in the InfoSet Builder
Matching InfoSets
Defining Join Conditions
Join Control
Left Outer Join
Antijoin
Examples of Condition Conversion
Temporal Join
Processing the Time Dependency
Most Recent Reporting for InfoObjects
Recommendations for Modeling InfoSets
BEx Queries Based on InfoSets
Interpreting Queries Using InfoSets
Creating MultiProviders
Recommendations for Modeling MultiProviders
Consistency Check for Compounding
Pruning Queries on MultiProviders
Administering Pruning for MultiProviders
Dividing a MultiProvider Query into Subqueries
Example: Plan-Actual Data
Example: Sales Scenario
Virtual Data Mart Layer
CompositeProvider
Creating CompositeProviders in the Data Warehousing Workbench
Recommendations for Modeling CompositeProviders
Creating VirtualProviders Based on an SAP HANA Model
Using Virtual Master Data
Creating TransientProviders on SAP HANA Models
TransientProviders Derived from an Analytic Index
Data Acquisition
Source System
Connection between Source Systems and BW
Logical System Names
Creating SAP Source Systems
Configurations in BW
Configurations in the SAP Source System
Transferring Global Settings
Creating External Systems
Creating File Systems
Creating Database Management Systems as Source Systems
Creating a UD Connect Source System
Check Source System
Data Extraction from SAP Source Systems
Creating SAP Source Systems
Configurations in BW
Configurations in the SAP Source System
Transferring Global Settings
Creating a Dummy Source System
DataSource in the SAP Source System
Extraction Structure
Copying BI Content DataSources to the Active Version
Editing the DataSource in the Source System
Replication of DataSources
Replicating Switches
Editing DataSources from SAP Source Systems in BW
Displaying Data Lineage for DataSource Fields
Using Emulated 3.x DataSources
Data Reconciliation
Delta Process
Functions in the SAP Source System
Maintaining Control Parameters for Data Transfer
Data Transfer with qRFC Outbound Queue
Restricting Authorizations for Extraction
Checking the Delta Queue
Monitoring Delta Queues
Functions of the Delta Queue Monitor
Monitoring Requests in the Delta Queue Monitor
Terminating Subscriptions for Inactive Subscribers
Installing Application Component Hierarchies
Installing BW Content DataSources
Maintaining Generic DataSources
Settings for Delta Transfer
Function Module: Interface Description and Procedure
Testing Extraction
Extraction Using SAP Query
Notes on Extraction Using SAP Query
SAP Query: Assignment to a User Group
Editing DataSources and Application Component Hierarchies
Enhancing DataSources
Data Transfer Using Web Services
Creating Web Service Source Systems
Creating DataSources for Web Services
Transferring Data Using Web Services (Standard)
Closing Requests Using Process Chains
Transferring Data Using Operational Data Provisioning
Notes about Transferring Data from SAP HANA Using ODP
Notes About Transferring Data from SAP Business ByDesign Systems Using ODP
Creating an ODP Source System
Creating DataSources for ODP Source Systems
Transferring Data with UD Connect
Creating a UD Connect Source System
Creating a DataSource for UD Connect
Using Emulated 3.x DataSources
Using InfoObjects with UD Connect
Data Types and Their Conversion
Using SAP Namespace for Generated Objects
Using Relational UD Connect Sources (JDBC)
BI Java Connector
Configuring BI Java Connector
BI JDBC Connector
Transferring Data Using DB Connect
DB Connect Architecture
Installing the Database Shared Library (DBSL)
Supported Databases
Requirements for Database Tables and Database Views
Database Users and Database Schemas
Creating Database Management Systems as Source Systems
Creating DataSources for DB Connect
Localizing Errors
Update Metadata
Transferring Data from Flat Files
Creating DataSources for File Source Systems
Using Generic BW Deltas
Using Emulated 3.x DataSources
Transferring Data Using Staging BAPIs
Transferring Data with SAP Data Services.
Creating SAP Data Services Source Systems
Creating Source Data Stores in the Data Services System
Creating DataSources for Data Transfer with SAP Data Services
Creating InfoPackages for Data Transfer with SAP Data Services
Transferring Data with SAP Landscape Transformation Replication Server
Transferring Data from SLT Using Operational Data Provisioning
Transferring Data from SLT Using Web Service
Resuming the Load Process
Distributing Data to Other Systems
Exchanging Data Between BW Systems.
Data Mart Interface Between Several Systems
Using the Data Mart Interface
Generating Export DataSources for InfoProviders
Generating Master Data Export DataSources
Data Transfer Using the Data Mart Interface
Exchanging Data Between BW Systems via the ODP Source System
Extracting Data from the BW System
Distributing Data from the BW System
Creating Open Hub Destinations
Selecting Database Tables as Destinations
Selecting Files As Destinations
SAP Data Services and Third-Party Tools as Destinations
Extracting Data to a Third-Party Tool
APIs for Third-Party Tools as Destinations
API: RSB_API_OHS_DEST_SETPARAMS
API: RSB_API_OHS_3RDPARTY_NOTIFY
API: RSB_API_OHS_REQUEST_SETSTATUS
API: RSB_API_OHS_DEST_GETLIST
API: RSB_API_OHS_DEST_GETDETAIL
API: RSB_API_OHS_DEST_READ_DATA_RAW
API: RSB_API_OHS_DEST_READ_DATA
Field Definition
Open Hub Service (3.x)
Remodeling InfoProviders
Remodeling an InfoCube
Remodeling a DataStore Object
Customer Exits in Remodeling
Monitor and Error Handling
Editing Data Flows
Displaying the Data Flow for an Object
Generating Simple Wizard-Based Data Flows
Copying a Data Flow
Overview of Data Flow Copy Processes
Migrating a Data Flow
Creating and Editing Migration Projects
Executing Migration Projects
Notes on Handling Special Objects During Migration
Monitoring Migration Projects
Checking a Migrated Data Flow
Transporting Migration Projects
Deleting a Migration Project
Analyzing Metadata with the Metadata Repository
Namespaces for BW Objects