Administrator Workbench
Metadata Repository
Searching for Metadata
Displaying Graphics
Exchange of Metadata in XMI Format
Business Content (Versions)
Installing Business Content
Installing BW Statistics (Technical Content)
Modeling
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 BW Master Data into a dBase File
Maintaining the SAPBWKEY Column
Uploading Edited Shapefiles into BW
Geocoding
Downloading BW 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
Reference Characteristics
Navigation Attribute
Creating Navigation Attributes
Transitive Attributes as Navigation Attributes
Creating InfoObjects: Key Figures
Tab Page: Type/Unit
Tab Page: Aggregation
Non-cumulatives
Non-Cumulative Key Figures
Time Reference Characteristic
Validity Period
Maintaining the Validity Area
Transferring Non-Cumulative Data into BW
Aggregational Behavior of Non-Cumulative Values
Procedure for Evaluating Non-Cumulative Values
Excursus: Modeling Non-Cumulative Values with Differing Time Ref
Performance Tips
Tab Page: Additional Properties
Elimination of Internal Business Volume
Editing InfoObjects
Additional Functions in the InfoObject Maintenance
InfoCube
Star Schema
Dimension
Line Item Dimension
Creating InfoCubes
Additional Functions in InfoCube Maintenance
Checking the Data Loaded in the Basis InfoCube
Checking the Data Consistency for an InfoCube
Non-Cumulative Value Parameter Maintenance
Database Storage Parameters
Partitioning
Partitioning InfoCubes using the Characteristic 0FISCPER
Deleting the InfoCube and InfoCube Content
Overview of Loadable InfoSources for an InfoCube
Including InfoCubes in Process Chains
Aggregates
Aggregation Levels
Aggregation Level "All Characteristic Values" ('*')
Aggregation Level "Hierarchy Level" ('H').
Aggregation Level "Fixed Value" (‘F’)
Editing Aggregates
Creating the First Aggregate for an InfoCube
Displaying Aggregates and their Components
Activating and Filling Aggregates
Rolling up Data into an Aggregate
Further Editing Functions for Aggregates
Efficiently Loading Data into Aggregates
Automatically Selecting and Optimizing Aggregates
Proposals from Queries
Proposals from BW Statistics
Optimizing Proposed Aggregates
MOLAP Store
Conditions for BW InfoCubes
MOLAP Aggregate
MOLAP Cube (Root Aggregate)
Create MOLAP Cube
Data Targets
Using 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
Activating Master Data and Texts
Simulate Loading of Master Data
Master Data Lock
Reorganizing Master Data
Basic InfoCube
Transactional InfoCubes
ODS Object
Scenario for ODS Objects
Example for Updating Data in an ODS Object
Creating ODS Objects
Activating Data in the ODS Object
Updating ODS Objects
Including ODS Objects in Process Chains
Deleting Data from the ODS Object
Delete by Request
Deleting Selectively
Deleting from the Change Log
Deleting Already Updated Data
Status Overview of ODS Objects
Transactional ODS Object
ODS Data and External Applications
ODS Object Performance
Questions and Answers
Hierarchies
Hierarchy Nodes
Link Nodes
Loading Hierarchies
Loading Hierarchies Using a Process Chain
Special Features when Loading Data Using the PSA
Loading Subtree Hierarchies.
Functions of Hierarchy Maintenance
Creating Hierarchies
Options for the Combination of Nodes and Leaves
Reporting-relevant Hierarchy Settings
Editing Hierarchies
Copying Hierarchies
Activating Hierarchies
Node Attributes
Hierarchy Versions
Maintain Hierarchy Versions
Time-dependent Hierarchies
Loading Time-dependent Hierarchies
Hierarchy Intervals
Reversing the Sign
Using Sign Reversal
Hierarchy Modeling Options
Update Rules
Update Options
Update Process
Creating Update Rules for Data Targets
Creating a Start Routine
Update Types
Update Methods
Automatic Time Conversion
Time Distribution
Splitting Key Figure Values
Creating Different Rules for Different Key Figures for a Charact
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
Changing Update Rules
Transferring Update Rules from a Template
Currency Translation in the Update
Additional Functions in Update Rule Maintenance
Source System
Connection between Source Systems and BW
Creating an SAP Source System
Creating an SAP Source System Automatically
Creating an SAP Source System Manually
Creating External Systems
Creating File Systems
Data Extraction from SAP Source Systems
DataSource
Transferring Business Content DataSources into Active Version
Maintaining DataSources
Assigning DataSources to InfoSources and Fields to InfoObjects
Extraction Structure
Transfer Structure
Delta Process
Transferring Data in XML Format
XML DataSource (BW DataSource with SOAP Connection)
Creating an XML DataSource
Loading XML Data
The Structure of an XML Document
Transferring Data with DB Connect
DB Connect Architecture
Installing the Database Shared Library (DBSL)
Supported Databases
Database Tables/ Views Requirements
Creating Database Management Systems as Source Systems
Generating DataSources
Metadata Upload for SAP Systems
Updating Metadata for Flat Files or External Systems
Check Source System
Data Mart Interface
Data Mart Interface Between Several Systems
Using the Data Mart Interface
Generating the InfoCube Export DataSource
Generating the Master Data Export DataSource
Transferring Transaction Data for the Data Mart Interface
Transferring Texts and Hierarchies for the Data Mart Interface
Data Mart Interface in the Myself System
InfoSource
InfoSource Types
Scenarios for Flexible Updating
Creating InfoSources (R/3 Source System)
Communication Structure
Maintaining Communications Structures with Flexible Updating
Maintaining Communication Structures with Direct Updating
Check for Referential Integrity
Transfer Structure
Maintaining Transfer Structures
Processing Transfer Rules
Start Routine in Transfer Rules
Creating Transfer Routines
Maintaining an InfoSource (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)
InfoProviders
Virtual InfoCubes
SAP RemoteCube
Creating a SAP RemoteCube
RemoteCube
Virtual InfoCubes with Services
InfoSet
Creating InfoSets
Editing InfoSets
Variants: Editing InfoSets
Screen Layout: Changing InfoSets
Join Control
Defining Join Conditions
Editing InfoProviders in the Join Control
Temporal Join
Classic InfoSet
Setting-up a Role for the InfoSet Query
Processing Classic InfoSet and Assigning Roles
InfoSet Query
Creating InfoSet Queries
MultiProviders
Dividing a MultiProvider Query into Sub-Queries
Executing Sub-Queries for a MultiProvider in Parallel
Slow Moving Item Scenario
Staging Scenarios
Data Storage Properties
Staging Scenarios with Persistent Data Storage
Staging Scenarios without Persistent Data Storage
Open Hub Service
Components of the Open Hub Service
Extraction Mode for the InfoSpoke
Creating InfoSpokes
Including InfoSpokes in Process Chains
InfoSpoke with Transformation Using a BAdI
Open Hub Monitor
Data Mining
Decision Trees
Scoring
Special Settings for Function Types
ABC Classification
Performing ABC Classification
Model Settings
Classification Rules
Clustering
Association Analysis
Creating, Changing, and Activating a Model
Creating, Changing, and Activating a Source
Training and Valuating a Model
Executing the Prediction
Executing What If Prediction
Creating Target Groups in SAP CRM
Creating Hierarchy in SAP BW
Maintaining DataSource
Loading the Mining Results into SAP BW
Updating ODS Objects with Mining Results
Resetting or Deleting a Model or Source
Administration
Scheduler
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: Update
Tab Page: External Data
Scheduling InfoPackages
Selection Criteria for Start Date when Scheduling in Background.
Variants
Additional Scheduler Functions
Maintaining Data Transfer Control Parameters for DataSources
Handling Double Data Records
Treating Data Records with Errors
Monitoring
Monitor
Selection Screen
Request Overview
Detail Screen
Update Simulation in the Monitor
Traffic Lights
Wizard
Persistent Staging Area
Types of Data Update with PSA
Checking and Changing Data
Checking and Changing Data Using PSA-APIs
Versioning
Database Storage Parameters
Deleting Requests from the PSA
InfoPackage Group
Maintaining InfoPackage Groups
Scheduling an InfoPackage Group
Adjusting Changes to Hierarchies and Attributes
Status Overview of ODS Objects
Managing Data Targets
Managing InfoCubes
InfoCube Content
Transferring InfoCube Contents
Selective Deletion
InfoCube Performance
InfoCube Compression
Requests in the InfoCube
Automatic Further Processing
Restructuring InfoCubes
Managing ODS Objects
ODS Object Content
Requests in an ODS Object
Reconstructing an ODS object
Managing InfoObjects
Process Control
Process Chains
Process
Start Process
Application Processes
Operating System Command
Including an OS Command as a Process in a Process Chain
ABAP Programs
Remote 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
Reading the PSA and Updating a Data Target
Collection Process
Process Chain Maintenance
Creating a Process Chain
Variant Maintenance Tips
Process Chain Attributes
BW Monitor in CCMS
Process Chain Logs Display
Restarting Terminated Processes
Subsequent Processing
Event Collector
Creating an Event Collector
Scheduling the Event Collector
Editing an Event Collector
Reporting Agent
Defining Exceptions Settings
Tab Page: Parameter(s)
Editing a Follow-Up Action: Send Message
Processing Follow Up Actions: Alert Monitor Entry
Example for Alert Texts
Editing the Follow-Up Action: Export
BAdI: Export of BW Alerts (RSRA_ALERT)
Interface (IF_EX_RSRA_ALERT)
Interface Method INITIALIZE
SUBMIT Interface Method
Parameter I_T_ALERT_DEFINITION
Parameter I_TX_ALERT_CONTAINER
Parameter FLT_VAL
Defining the Print Setting
Tab Page: Print Settings
Defining the Print Layout
Defining Web Template Settings
DATA_MODE Parameter
Control Query for Pre-calculating Web Templates
Defining the Value Set Setting
Defining Crystal Reports Queries Settings
Parameterizing the Crystal Reports Queries Setting
Processing the Scheduling Package
Creating a Scheduling Package
Assigning Reporting Agent Settings
Schedule a package as a Job
Inserting a Package into a Process Chain
Managing Bookmarks
Documents
Managing Documents in BW
Retrieval: Search Server Relation Monitor
Tab Page: Content Repository
Tab Page: Indexing for a Search
Setting up Indexes for Initial Searches
Tab Page: Generic Properties
Valid File Types
Editing Valid File Types
Processing Documents in the AWB Documents View
Documents for Metadata
Documents as Online Documentation
Documents for Master Data
Document for InfoProvider Data
Processing Documents in the Documents Screen
Creating Documents
Importing Documents
Exporting Documents
Hyperlinks to Documents
Searches in Documents
Translating a Text for BW Objects