Data Warehousing

The Data Warehouse Concept

Using a Data Warehouse

Architecture of a Data Warehouse

Enterprise Data Warehouse (EDW)

Building and Running a Data Warehouse

Data Warehousing: Step by Step

Data Warehousing Workbench

Data Warehousing Workbench - Modeling

Data Flow in the Data Warehouse

Modeling

Namespaces for BI Objects

Data Flow Display

DataSource

Functions for DataSources

DataSource Maintenance in BI

Editing DataSources from SAP Source Systems in BI

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 3.x DataSources

Migrating 3.x DataSources (UD Connect, Web Service)

Restoring 3.x DataSources

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 the PSA and Updating a Data Target

InfoObject

InfoObject Catalog

Creating InfoObject Catalogs

Additional InfoObject Catalog Functions

InfoObject Naming Conventions

Creating InfoObjects: Characteristics

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 Shape File

Downloading BI Master Data into a dBase File

Maintaining the SAPBWKEY Column

Uploading Edited Shapefiles into BI Systems

Geocoding

Downloading BI Master Data into a dBase File

Geocoding Using ArcView GIS

Converting dBase Files into CSV Files

Tab Page: Master Data/Texts

Tab Page: Hierarchy

Tab Page: Attributes

Tab Page: Compounding

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 BI 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

Conversion Routine RSDAT

SDATE Conversion Routine

WBSEL Conversion Routine

Creating InfoObjects: Key Figures

Tab Page: Type/Unit

Tab Page: Aggregation

Tab Page: Additional Properties

Editing InfoObjects

Additional Functions in InfoObject Maintenance

Using Master Data and Characteristics that Bear Master Data

Master Data Types: Attributes, Texts and Hierarchies

Master Data Maintenance

Creating and Changing Master Data

Maintaining Time-Dependent Master Data

Time-dependent Master Data from Different Systems

Deleting Master Data Selectively

Deleting Attributes and Texts for a Characteristic

Versioning Master Data

Activating Master Data and Texts

Simulate the Loading of Master Data

Master Data Lock

Reorganizing Master Data

Load Master Data to InfoProviders Straight from Source Systems

InfoProviders

InfoCubes

Star Schema

Dimension

Line Item and High Cardinality

Creating InfoCubes

Real-Time InfoCubes

Additional Functions in InfoCube Maintenance

InfoProvider Properties

Checking the Data Loaded in the InfoCube

Non-Cumulative Value Parameter Maintenance

DB Memory Parameters

Partitioning

Partitioning InfoCubes Using the Characteristic 0FISCPER

Repartitioning

Clustering

Definition of Clustering

Selecting MDC Dimensions

Reclustering

Overview of Loadable InfoSources for an InfoCube

DataStore Object

Defining the DataStore Object Type

Standard DataStore Object

Write-Optimized DataStore Objects

DataStore Objects for Direct Update

Scenario for Using Standard DataStore Objects

Scenario for Using Write-Optimized DataStore Objects

Scenario for Using DataStore Objects for Direct Update

Creating DataStore Objects

DataStore Object Settings

Additional Functions in DataStore Object Maintenance

InfoProvider Properties

DB Memory Parameters

Multidimensional Clustering

Definition of Clustering

Integration in the Data Flow

Questions and Answers

InfoObjects as InfoProviders

VirtualProviders

VirtualProvider Based on the Data Transfer Process

Creating VirtualProviders Based on Data Transfer Processes

Creating VirtualProviders Based on 3.x InfoSources

Processing Selection Conditions

VirtualProvider with BAPI

VirtualProviders with Function Modules

Using InfoObjects As VirtualProviders

InfoSet

Creating InfoSets

Editing InfoSets

Special Features of InfoCubes in InfoSets

Additional Functions in the InfoSet Builder

Screen Layout: Changing InfoSets

Comparing and Adjusting InfoSets

Join Control

Defining Join Conditions

Left Outer Join

Examples of Condition Conversion

Editing InfoProviders in the Join Control

Temporal Join

Processing the Time Dependency

Most Recent Reporting for InfoObjects

Interpreting Queries Using InfoSets

Classic InfoSet

Setting-up a Role for the InfoSet Query

Processing Classic InfoSets and Assigning Roles

InfoSet Query

Creating InfoSet Queries

MultiProviders

Creating MultiProviders

Consistency Check for Compounding

Dividing a MultiProvider Query into Sub-Queries

Example: Plan-Actual Data

Example: Sales Scenario

Open Hub Destination

Creating Open Hub Destinations

Database Tables As Destinations

Files as Destinations

Third-Party Tools as Destinations

Field Definition

Remodeling InfoProviders

Remodeling InfoProviders

Remodeling a Data Store Object

Customer Exits in Remodeling

Monitor and Error Handling

Data Acquisition

Source System

Connection between Source Systems and BW

Creating SAP Source Systems

Configurations in BI

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

DataSource in the SAP Source System

Extraction Structure

Copying the BI Content DataSource to the Active Version

Editing the DataSource in the Source System

Replication of DataSources

Editing DataSources from SAP Source Systems in BI

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

Delta Queue Check

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 BI Content DataSources

Maintaining Generic DataSources

Delta Transfer to BI

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

Functions for DataSource 3.x in Data Flow 3.x

Assigning DataSources 3.x to InfoSources 3.x and Fields to InfoO

Transfer Structure in Data Flow 3.x

Transferring Data Using Web Services

Creating Web Service Source Systems

Creating DataSources for Web Services

Transferring Data Using Web Services (Standard)

Closing Requests Using Process Chains

SOAP-Based Transfer of Data (3.x)

XML DataSource (BW DataSource with SOAP Connection)

Creating an XML DataSource

Activating Data Transfer to the Delta Queue

Further Processing Data from the Delta Queue

Transferring Data Using the SOAP Service SAP Web AS

Sending Data to the SOAP Service

Structure of a SOAP Message

Data Transfer Using Web Services

Creating a Web Service for Loading Data

Data Transfer Using SAP XI

Example of Transferring XML Data Using SAP XI

Transferring Data with UD Connect

Creating a UD Connect Source System

Creating a DataSource for UD Connect

Creating DataSource 3.x

Using InfoObjects with UD Connect

Data Types and Their Conversion

Using SAP Namespace for Generated Objects

Using Emulated 3.x DataSources

Using Relational UD Connect Sources (JDBC)

Dataflow 3.x Example: JDBC Source with Transaction Data

Dataflow 3.x Example: JDBC Source with Master Data

BI Java Connectors

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

Updating Metadata

Using 3.x DataSources

Transferring Data from Flat Files

Creating DataSources for File Source Systems

Using Emulated 3.x DataSources

Transferring Data from Flat Files (3.x)

Updating Metadata for Flat Files and External Systems

Data Transfer from External Systems

Updating Metadata for Flat Files and External Systems

Notes on Data Transfer

Load Master Data to InfoProviders Straight from Source Systems

Transformation

Rule Type

The 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

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 for Inversion Routine

Details for Implementing the Inversion Routine

Regular Expressions in Routines

Update Behavior of Fields in the End Routine

InfoSource

Recommendations for Using InfoSources

Migration of Update Rules, 3.x InfoSources, and Transfer Rules

Differences in Routine Concepts

Example for Migration of an Inversion Routine

Old Transformation Concept

3.x InfoSource

3.x InfoSource Types

Scenarios for Flexible Updating

Creating InfoSources (SAP Source System)

Communication Structure

Maintaining Communications Structures with Flexible Updating

Maintaining Communication Structures with Direct Updating

Checking for Referential Integrity

Transfer Structure in Data Flow 3.x

Maintaining Transfer Structures

Processing Transfer Rules

Start Routines in Transfer Rules

Creating Transfer Routines

Inversion Routine

Error Handling in the Transfer Routine

Maintaining InfoSources (Flat File)

Updating Data Flexibly from a Flat File

InfoSource with Flexible Update for Flat Files

Updating Master Data from a Flat File

Uploading Hierarchies from Flat Files

Structure of a Flat Hierarchy File for Loading via IDoc

Structure of a Flat Hierarchy File for Loading Using a PSA

Preview and Simulation of Loading Data from Flat Files

Maintaining InfoSources (External System)

Update Rules

Update Options

Update Process

Creating Update Rules for InfoProviders

Update Types

Update Methods

Automatic Time Conversion

Time Distribution

Splitting Key Figure Values

Creating Different Rules for Different Key Figures for a Charact

Currency Translation in the Update

Update Routines and Start Routines

Creating Update Routines

Error Handling in the Update Routine

Changing Update Rules

Additional Functions in Update Rule Maintenance

Further Processing Data

Further Processing of Data in DataStore Objects

Activation of Data in DataStore Objects

Example for Activating and Updating Data

Including DataStore Objects in Process Chains

Deleting Data from the DataStore Object

Delete by Request

Deleting Data Selectively

Deleting from the Change Log

Deleting Already Updated Data

Further Processing of Data in InfoCubes

Deleting the InfoCube and InfoCube Content

Including InfoCubes in Process Chains

Data Distribution

Data Transfer Process

Creating Data Transfer Processes

Processing Modes of Data Transfer Processes

Creating Data Transfer Processes for Real-Time Data Acquisition

Creating Data Transfer Processes for Direct Access

Handling of Data Records with Errors

Error Stack

Examples for Using the Error Stack

Temporary Storage

Handling Duplicate Data Records

Monitor

Where-Used List for Requests

Simulating and Debugging DTP Requests

Performance Tips for Data Transfer Processes

Data Mart Interface

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

Open Hub Service

Components of the Open Hub Service

Database Tables As Destinations

Files as Destinations

Extraction Mode for the InfoSpoke

Creating InfoSpokes

Including InfoSpokes in Process Chains

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

API: RSB_API_OHS_SPOKE_GETLIST

API: RSB_API_OHS_SPOKE_GETDETAIL

InfoSpoke with Transformation Using a BAdI

Open Hub Monitor

Data Warehouse Management

Performance Optimization in Data Warehouse

General Performance Tips for the Load Process

Performance Tips InfoCubes

Performance Tips for DataStore Objects

Performance Tips for Processing Master Data

Performance Tips for Data Transfer Processes

Performance Tips for Data Transfer from an SAP Source System (Se

Performance Tips for Loading Flat Files:

Performance Tips for ABAP Programming

Load Balancing for Loading and Data Warehouse Processes

Setting Load Balancing for Loading Processes to the BI System

Setting Load Balancing for BI Processes in the Background

Setting Load Balancing for DataStore Object Processes in the Dia

Optimization of Data Retention

Tools for Runtime Analzsis of BI Processes

Process Chain

Process

Start Process

Application Process

Operating System Command

Including Operating System Commands as Processes in Process Chai

ABAP Programs

Local Process Chains

Process Chain Remote

Decisions

Including Decisions as a Process in Process Chains

Workflow

Including a Workflow as a Process in a Process Chain

Executing a Process Chain Within a Workflow

Implementing Your Own Process Type

Collection Process

Process Chain Maintenance

Plan and Check View Functions

Creating Process Chains

Variant Maintenance Tips

Display/Maintenance of Process Chain Attributes

BW Monitor in CCMS

Send Alerts for Process Chains

Monitoring Process Chain Runs

Process Chain Logs Display

Repairing/Repeating Terminated Processes

Maintenance of Process Types

Authorizations for Process Chains

Scheduler

Creating InfoPackages

Additional Functions in InfoPackage Maintenance

Maintaining Data Transfer Control Parameters for DataSources

Handling Duplicate Data Records

Scheduler (3.x)

Maintaining InfoPackages

Procedure for SAP Systems

Procedure for Flat Files

Procedure for External Systems with BAPI Functions

Tab Page: Data Selection

Variable Selection Change in Background Processing

Tab Page: Hierarchy Selection

Tab Page: Processing

Tab Page: Data Targets

Automatic Deletion of Requests from the InfoCube when Loading

Tab Page: Updating

Tab Page: External Data

Scheduling InfoPackages

Selection Criteria for Start Date when Scheduling in Background.

Inserting an InfoPackage into the Process Chain

Variants

Additional Functions in InfoPackage Maintenance

Maintaining Data Transfer Control Parameters for DataSources

Handling Duplicate Data Records

Handling of Data Records with Errors

Subsequent Processing

Monitor for Extraction Processes and Data Transfer Processes

Selection Screen

Request Overview

Detail Screen

Update Simulation in the Extraction Monitor

Detail Screen - Old

Traffic Lights

Wizard

Administration of InfoProviders

Manage InfoCubes

InfoCube Content

Transferring InfoCube Contents

Selective Deletion

InfoCube Performance

Compressing InfoCubes

Requests in InfoCubes

Automatic Further Processing

Reconstruction of InfoCubes

Functional Constraints of Processes

Status Overview of DataStore Objects

Management of DataStore Objects

DataStore Object Content

Requests in DataStore Objects

Reconstruction of DataStore Objects

Runtime Parameters of DataStore Objects

Functional Constraints of Processes

Manage InfoObjects

Information Quality Management

Information Lifecycle Management

Data Archiving Process

Archiving Data

Creating Data Archiving Processes

Special Features of Write-Optimized DataStore Objects

Creating Near-Line Storage Connections

Making Changes to the Data Archiving Process

Scheduling Data Archiving Processes Using Process Chains

Scheduling Data Archiving Processes Using ADK Archive Administra

Maintenance of Variants

Administration of Data Archiving Processes

Creating and Executing Archiving Requests

Status of Archiving Request

Setting Archiving Requests to Invalid

Reloading Archived Data

Loading Archived Data Using a Data Transfer Process

Displaying Stored Data in Queries

Old Data Archiving Concept

Data Archiving Process Flow

Deletion Strategies

Typical Errors and Their Removal

Archiving Object

Deleting or Changing an Archiving Object

Time Restrictions

Archiving Data

Archiving Data from Non-Cumulative InfoCubes

Example of Archiving Data from Non-Cumulative InfoCubes

Checking an Archive File

Reloading Data from Archive Files

Authorizations

Standard Authorizations

Overview: Authorization Objects

Authorization Profiles for Working with the Data Warehousing Wor

Authorization Profiles for Background Users

Authorizations for Query Definition and Information Broadcasting

Examples for Authorizations for the Query Definition

Authorizations for Business Planning and Simulation

Authorizations for Integration with the Portal

Authorizations for Documents

Authorizations for Master Data

Authorizations for Trace Tool Environment

Setting Up Standard Authorizations

Authorization Templates

Analysis Authorizations

Authorization Dimension

Management of Analysis Authorizations

Prerequisites for the Management of Analysis Authorizations

Defining Analysis Authorizations

Settings for Value Authorizations

Authorization for Aggregated Values

Settings for Hierarchy Authorizations

Authorizations with Variables

Authorizations for Display Attributes

Authorizations for Navigation Attributes

Authorizations for BI Integrated Planning

Generation of Analysis Authorizations

Template for DataStore Objects with Authorization Data (Values)

Template for DataStore Objects with Authorization Data (Hierarch

Examples of Generated Authorizations

Assigning Authorizations to Users

Error Log

Optimization of Authorizations

Filling Empty Dimensions and Combining Authorizations

Generalization for Any Number of Dimensions

Combining Authorizations

Change Documents (Legal Auditing)

Migration of Reporting Authorizations to the New Concept

Performing Migration

Repeated Migration or Deletion of an Old Migration

Previous Concept for Reporting Authorizations

Authorizations for Selection Criteria

Authorizations for Display Attributes

Authorizations for Navigation Attributes

Authorizations with Variables

Maintaining Authorizations for Hierarchies

Authorization Check when Executing a Query

Setting Up Reporting Authorizations

Setting Up Reporting Authorizations

Manually Maintaining Reporting Authorizations

Generating Reporting Authorizations

Transporting Additional Information

Authorization Scenarios for BW Reporting

Authorizations for a Few Groups

Individual and Detailed Authorizations

Authorization Using Variables

Using Existing Authorizations

Administration of BI Metadata Search and BI Documents

Retrieval: Search Server Relation Monitor

Tab Page: Metadata Indexing

Tab Page: Generated Document Properties

Characteristic Is Document Property

Tab Page: Document Content Repository

Tab Page: Online Documentation

Tab Page: Indexing Documents

Setting up Indexes for Initial Searches

Valid File Types

Editing Valid File Types

Working with Documents in the Data Warehousing Workbench

Editing Documents in the Document View of DW Workbench

Processing Documents in the Documents Screen

Creating Documents

Exporting Documents

Documents as Online Documentation

Translating Text for BI Objects

Transporting BI Objects, and Creating, Delivering, and Copying B

BI Versioning Concept

Object Dependencies and Consistency

Collecting Objects

Defining Grouping Mode

Checking Settings

Transporting BI Objects

Transport Landscape

Recording Time for Transports

Defining the Recording Time for Transports

Defining Object Changeability

Changing Package Assignments

Troubleshooting (Transport)

Creating and Delivering BI Content

System Landscape

Making System Settings for Content Creation

BI Content Delivery by SAP

BI Content Delivery by SAP in OLTP Systems

Creating and Delivering Customer Content

Using Namespaces for Developing BI Objects

Creating and Delivering Customer Content in the BI System

Setting Object Changeability in Customer Content Systems

Creating and Delivering Customer Content in the OLTP System

Features when Transporting Roles

Development and Delivery of Hierarchy Nodes

Comparing Different ABAP Code Versions

Creating and Delivering Partner Content

Development and Delivery of Hierarchy Nodes

Documents for Content Objects

Copying BI Content to the Active Version

Troubleshooting (Content Activation)

Transportable Object Types

SOBJ: Definition of Transportable Object Types

Special Features of Individual Object Types

Transporting BEx Objects

Transporting Roles

Transporting Hierarchy InfoPackages

Importing Client-Dependent Objects

Special Features of Source-System-Dependent Objects

Enhancements to the BI Versioning Concept

Classification of Source-System-Dependent Objects

Making the Source System Anonymous

Defining the Target Source System

DataSource

InfoPackage

Transformation

Data Transfer Process

Process Chains and Process Variants

Source System-Dependent 3.x Objects

BI Statistics

Technical Content

BW Technical Content FC1

SAP Exit Variable

Variable: Current Calendar Month

Variable: Current Calendar Week

Variable: Current Calendar Year

Variable: Current Quarter

Variable: Current Calendar Day

Variable: Current Workday

Variable: Current Fiscal Year

Variable: Current Fiscal Year / Period

Variable: Cumulated up to Current Fiscal Year Period

Variable: Cumulated up to Last Fiscal Year Period

Variable: Cumulated up to Current Month

Variable: Cumulated up to Last Month

Variable: Cumulated up to Current Day

Variable: Previous Year Cumulated up to Current Day

Determining the Fiscal Year Variant at Query Runtime

Analysis and Repair Environment

Archivation of Request Administration Data

Archive Administration for Request Administration Data

Archiving Request Administration Data

Reloading Request Administration Data

Editing Requests with Archived Administration Data

BI Background Management, Logs and Tools

Setting Parallel Processing of BI Processes

Process Types Supported by BI Background Management

Analyzing Background Jobs and Work Processes

Switching the Dialog Box for Load Distribution for Users On/Off

Deleting Messages and Parameters from BI Background Management

Executing Checking and Conversion Programs

Clients in BW

Clients: OLTP Systems and the Business Information Warehouse

Naming Conventions for Background Jobs

Real-Time Data Acquisition

Daemon for Real-Time Data Acquisition

Request Concept

Closing Requests in the Monitor for Real-Time Data Acquisition

Transferring Transaction Data from SAP Source Systems (RDA)

Transferring Transaction Data Using Web Services (RDA)

Monitor for Real-Time Data Acquisition

Troubleshooting Real-Time Data Acquisition

Creating InfoPackages for Real-Time Data Acquisition

Creating Data Transfer Processes for Real-Time Data Acquisition

Controlling Real-Time Data Acquisition with Process Chains