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
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 DataSources 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 Storage 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 Storage 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
Use of Master Data and Master Data-Bearing Characteristics
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 at Single Record Level
Deleting Master Data and Texts for a Characteristic
Versioning Master Data
Activating Master Data and Texts
Simulate Loading of Master Data
Master Data Lock
Reorganizing Master Data
InfoProviders
InfoCubes
Star Schema
Dimension
Line Item and High Cardinality
Creating InfoCubes
Real-Time InfoCubes
Additional Functions in InfoCube Maintenance
Checking the Data Loaded in the InfoCube
Non-Cumulative Value Parameter Maintenance
DB Storage 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 Objects
Scenario for DataStore Objects
Standard DataStore Object
DataStore Objects for Direct Update
Write-Optimized DataStore Objects
Creating DataStore Objects
DataStore Object Settings
Additional Functions in DataStore Object Maintenance
DB Storage Parameters
Multidimensional Clustering
Definition of Clustering
DataStore Data and External Applications
Questions and Answers
InfoObjects As InfoProvider
VirtualProviders
VirtualProvider Based on the Data Transfer Process
Creating VirtualProviders Based on the Data Transfer Process
VirtualProvider with BAPI
VirtualProviders with Function Modules
InfoSet
Creating InfoSets
Editing InfoSets
Special Features of InfoCubes in InfoSets
Additional Functions in the InfoSet Builder
Screen Layout: Changing InfoSets
Matching InfoSets
Join Control
Defining Join Conditions
Left Outer Join
Examples of Condition Conversion
Editing InfoProviders in the Join Control
Temporal Join
Most Recent Reporting for InfoObjects
Local Aggregation
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
Dividing a MultiProvider Query into Sub-Queries
Example: List of Slow-Moving Items
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
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
Transferring BI Content DataSources into Active Version
Editing the DataSource in the Source System
Replication of DataSources
Editing DataSources from SAP Source Systems in BI
Using Emulated 3.x DataSources
Data Reconciliation
Delta Process
Functions in the SAP Source System
Maintaining Control Parameters for Data Transfer
Restricting Authorizations for the Extraction
Checking the Delta Queue
Transferring the Application Component Hierarchy
Installing Business Content DataSources
Maintaining Generic DataSources
Delta Transfer into BW
Function Module: Interface Description and Procedure
Testing Extraction
Extraction Using the SAP Query
Notes for Extraction Using the SAP Query
SAP Query: Assignment to a User Group
Editing DataSources & 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
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 DataSources 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 the BI Java Connectors
BI JDBC Connector
BI ODBO Connector
BI SAP Query Connector
BI XMLA Connector
Data Transfer with DB Connect
DB Connect Architecture
Installing the Database Shared Library (DBSL)
Supported Databases
Requests to Database Tables and Database Views
Database Users and Database Schemas
Creating Database Management Systems as Source Systems
Creating DataSources for DB Connect
Generating DataSource 3.x
Using Emulated 3.x DataSources
Localizing Errors
Updating Metadata
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
Transformation
Rule Type
The Transformation Library and Formula Builder
Example for Using the Formula Editor
BAdI: Customer-Defined Functions in the Formula Builder
Aggregation Type
Creating Transformations
Routines in the Transformation
Creating Routines
Example: Start Routine
Example: Characteristic Routine
Example: End Routine
Start Routine Parameters
Routine Parameters for Key Figures or Characteristics
End Routine Parameters
Regular Expressions in Routines
InfoSource
Recommendations for Using InfoSources
Migrating Update Rules, 3.x InfoSources and Transfer Rules
Old Transformation Concept
3.x InfoSource
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
The Transformation Library and Formula Builder
Example for Using the Formula Editor
BAdI: Customer-Defined Functions in the Formula Builder
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
Update of DataStore Object Data
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
Creating Data Transfer Processes for Real-Time Data Acquisition
Creating Data Transfer Processes for Direct Access
Handling Data Records with Errors
Error Stack
Examples for Using the Error Stack
Temporary Storage
Monitor
Where-Used List for Requests
Data Mart Interface
Data Mart Interface Between Several Systems
Using the Data Mart Interface
Generation of the Export DataSource for an InfoProvider
Generating the Master Data Export DataSource
Transferring Transaction Data for the Data Mart Interface
Transferring Texts and Hierarchies for 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
API: RSB_API_OHS_SPOKE_GETLIST
API: RSB_API_OHS_SPOKE_GETDETAIL
InfoSpoke with Transformation Using a BAdI
Open Hub Monitor
Data Warehouse Management
Process Chain
Process
Start Process
Application Process
Operating System Command
Including Operating System Commands as Processes in Process Chai
ABAP Programs
Process Chain Remote
Local Process Chains
Decisions
Including Decision as a Process in the Process Chain
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/Maintain Process Chain Attributes
BW Monitor in CCMS
Send Alerts for Process Chains
Process Chain Logs Display
Repairing/Repeating Terminated Processes
Maintenance of Process Types
Authorizations for Process Chains
Scheduler
Creating InfoPackages
Additional Scheduler Functions
Maintaining Data Transfer Control Parameters for DataSources
Handling Duplicated 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 Scheduler Functions
Maintaining Data Transfer Control Parameters for DataSources
Handling Duplicated Data Records
Handling Data Records with Errors
Subsequent Processing
Monitor for Extraction Processes and Data Transfer Processes
Selection Screen
Request Overview
Detail Screen
Update Simulation in the Monitor
Traffic Lights
Wizard
Administration of InfoProviders
Managing InfoCubes
InfoCube Content
Transferring InfoCube Contents
Selective Deletion
InfoCube Performance
Compressing InfoCubes
Requests in InfoCubes
Automatic Subsequent Processing
Reconstructing InfoCubes
Functional Constraints of Processes
Status Overview of DataStore Objects
Administration of DataStore Objects
DataStore Object Content
Requests in DataStore Objects
Reconstruction of DataStore Objects
Performance Optimization for DataStore Objects
Functional Constraints of Processes
Managing InfoObjects
Information Lifecycle Management
Data Archiving Process
Creating Data Archiving Processes
Scheduling Data Archiving Processes Using ADK Archive Administra
Maintenance of Variants
Scheduling Data Archiving Processes Using Process Chains
Administration of Data Archiving Processes
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
Defining Analysis Authorizations
Settings for Hierarchy Authorizations
Authorizations with Variables
Authorizations for Display Attributes
Authorizations for Navigation Attributes
Authorizations for BI Integrated Planning
Generation of Analysis Authorizations
Assigning Authorization to a User
Error Log
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
Documents
Document Classes
Working with Documents in Knowledge Management
Document Structure for Metadata
Document Structure for Master Data
Document Structure for InfoProvider Data
BI Security Manager for Documents
Migration of Documents into the CM Repository
Migration iView
Migrating Documents
Repository Manager for BI
BI Document Repository Manager
BI Metadata Repository Manager
Working with Documents in Web Applications
Using Documents in Web Applications
Creating New Documents
Displaying Documents for InfoProvider Data
Displaying Documents for a Cell
Special Features of Calculated Key Figures and Formulas
Documents as Online Documentation
Hyperlinks to Documents
Working with Documents in the Data Warehousing Workbench
Processing Documents in the DW Workbench Documents View
Processing Documents in the Documents Screen
Creating Documents
Exporting Documents
Documents as Online Documentation
Working with Documents in the BEx Analyzer
Documents as Online Documentation
Searches in Documents
BAdIs for Use in Documents
Translating Text for BI Objects
Transport System
Object Changeability
Transport-Relevant Metadata Object Types
Versions within the Transport
Standard and BI Transport Connection (A Comparison)
Switching the Standard Transport System On and Off
BI Transport Connection: Transporting Objects
Subsequently Changing Package Assignment
Transporting Roles
Transporting Hierarchy InfoPackages
Transporting BEx Objects
Business Content (Versions)
Installing Business Content
Collection Object Grouping
View of Objects and Object-Specific Recommendations
Installing BI Statistics
Customer and Partner Content
Customer Content
System Landscape
System Settings in the BW System
Delivery of Business Content by SAP
Using Namespaces for Developing BI Objects
Object Changeability in a Customer Content System
Content Delivery by Customers
Transport and Delivery of Source System-Dependant Objects
Transfer Rule and DataSource
Transfer Structure
InfoPackage
Process Chain and Process Variant
Error when Activating Partner Content
Features when Transporting Roles
InfoArea, Application Component and InfoPackageGroup
Comparing ABAP Code
Customer Content in the OLTP System
System Settings in the OLTP System
Business Content Delivery in OLTP Systems by SAP
Creating Partner Content in the OLTP System
Delivery and Use of Partner Content in the OLTP System
Functions in the SAP Source System
Maintaining Control Parameters for Data Transfer
Restricting Authorizations for the Extraction
Checking the Delta Queue
Transferring the Application Component Hierarchy
Installing Business Content DataSources
Maintaining Generic DataSources
Delta Transfer into BW
Function Module: Interface Description and Procedure
Testing Extraction
Extraction Using the SAP Query
Notes for Extraction Using the SAP Query
SAP Query: Assignment to a User Group
Editing DataSources & Application Component Hierarchies
Enhancing DataSources
Partner Content
InfoAreas, Application Components, and InfoPackage Groups
Documents for Content Objects
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
Archiving Request Administration Data
Archiving Request Administration Data
Reloading Request Administration Data
Editing Requests with Archived Administration Data
Archive Administration for Request Administration Data
Clients in BW
Clients: OLTP Systems and the Business Information Warehouse
Administrating Crystal Reports
Managing Crystal Reports (RSCR_ADMIN_REPORTS)
Checking Installation Settings (RSCR_CHECK_INSTALLATION_PARAMS)
Clean Role Tree (RSCR_ROLES_REORG)
Update Role Structure (RSCR_SYNCHRONIZE_ROLES)
Real-Time Data Acquisition
Daemon for Real-Time Data Acquisition
Monitor: Real-Time Data Acquisition
Creating InfoPackages for Real-Time Data Acquisition
Creating Data Transfer Processes for Real-Time Data Acquisition