SAP Library - SAP Business Information Warehouse

SAP Business Information Warehouse

New Features and Changes in SAP BW 3.5

Data Warehousing

Administrator Workbench

Settings in the Administrator Workbench

Modeling

Namespaces for BW Objects

Data Flow Display

DataSource

Persistent Staging Area

Types of Data Update with PSA

Checking and Changing Data

Checking and Changing Data Using PSA-APIs

Versioning

Database Memory Parameters

Deleting Requests from the PSA

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 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 Data Targets

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

Error Handling in the Update Routine

Changing Update Rules

Transferring Update Rules from a Template

Additional Functions in Update Rule Maintenance

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

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 SAP BW

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

WBSEL Conversion Routine

SDATE Conversion Routine

IDATE 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

InfoCube

Star Schema

Dimension

Line Item and High Cardinality

Creating InfoCubes

Additional Functions in InfoCube Maintenance

Checking the Data Loaded in the InfoCube

Non-Cumulative Value Parameter Maintenance

Database Memory 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

Data Targets

InfoObject as Data Target / InfoProvider

Basic InfoCube

Transactional InfoCubes

ODS Object

Scenario for ODS Objects

Example for Updating Data in an ODS Object

Creating ODS Objects

ODS Object Settings

Additional Functions in ODS Object Maintenance

Activate Data in ODS Objects

Updating ODS Object Data

Including ODS Objects in Process Chains

Deleting Data from the ODS Object

Delete by Request

Deleting Data Selectively

Deleting from the Change Log

Deleting Already Updated Data

Transactional ODS Object

ODS Data and External Applications

Questions and Answers

InfoProviders

Virtual InfoCubes

SAP RemoteCube

Creating a SAP RemoteCube

RemoteCube

Virtual InfoCubes with Services

InfoSet

Creating InfoSets

Editing InfoSets

Additional Functions in the InfoSet Builder

Screen Layout: Changing InfoSets

Matching InfoSets

Join control

Defining Join Conditions

Left Outer Join

Editing InfoProviders in the Join Control

Temporal Join

Most Recent Reporting for InfoObjects

Interpreting Reports Using InfoSets

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

Parallelization of Subqueries Versus Sequential Processing

Slow Moving Item Scenario

Staging Scenarios

Data Storage Properties

Staging Scenarios with Persistent Data Storage

Staging Scenarios without Persistent Data Storage

Data Retrieval

Source System

Connection between Source Systems and BW

Creating SAP Source Systems

Creating SAP Source Systems Automatically

Creating SAP Source Systems Manually

Transferring Global Settings

Creating External Systems

Creating File Systems

Check Source System

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

Customizing Extractors

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

Metadata Upload for SAP Systems

SOAP-Based Transfer of Data

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

Data Transfer with UD Connect

UD Connect Architecture

Creating a DataSource for UD Connect

Using InfoObjects with UD Connect

Data Types and Their Conversion

Using SAP Namespace for Generated Objects

Using Relational UD Connect Sources (JDBC)

Example: JDBC Source with Transaction Data

Example: JDBC Source with Master Data

Checking Availability for UD Connect

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

Generating DataSources

Localizing Errors

Updating Metadata

Data Transfer from Flat Files

Updating Metadata for Flat Files and External Systems

Data Transfer from External Systems

Updating Metadata for Flat Files and External Systems

Data Mart Interface

Data Mart Interface Between Several Systems

Using the Data Mart Interface

Generation of the Export DataSource for a Data Target

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

Open Hub Service

Components of the Open Hub Service

Extraction to Database Tables

Extraction to Flat Files

Extraction Mode for the InfoSpoke

Creating InfoSpokes

Including InfoSpokes in Process Chains

Extraction to Non-SAP Systems

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_GETDETAIL

API: RSB_API_OHS_SPOKE_GETLIST

InfoSpoke with Transformation Using a BAdI

Open Hub Monitor

Data Warehouse Management

Process Management

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

InfoPackage Group

Maintaining InfoPackage Groups

Scheduling an InfoPackage Group

Update Simulation in the Monitor

Traffic Lights

Wizard

Managing Data Targets

Managing InfoCubes

InfoCube Content

Transferring InfoCube Contents

Selective Deletion

InfoCube Performance

Compressing InfoCubes

Requests in the InfoCube

Automatic Subsequent Processing

Reconstructing InfoCubes

Lock Logic for Processes

Status Overview of ODS Objects

Managing ODS Objects

ODS Object Content

Requests in an ODS Object

Reconstructing an ODS object

Performance Optimization for ODS Objects

Lock Logic for 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 Process Chains

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

Data Archiving

Data archiving 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

Overview: Authorization Objects

Authorization Profiles for Working with the AWB

Authorization Profiles for Background Users

Authorizations for Working with the Business Explorer

Authorizations for the Query Definition

Example for Reporting Authorizations

Authorizations to Work with a Query

Authorizations for Selection Criteria

Authorizations for Display Attributes

Authorizations for Navigation Attributes

Maintaining Authorizations for Hierarchies

Authorizations with Variables

Authorization Check when Executing a Query

Authorizations for Business Planning and Simulation

Authorization for Documents

Authorizations for Master Data

Maintaining Authorizations

Authorization Templates

Setting up Authorizations with Role Maintenance

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

Documents

Document Classes

Documents as Online Documentation

Processing Documents in the AWB Documents View

Processing Documents in the Documents Screen

Creating Documents

Exporting Documents

Hyperlinks to Documents

Searches in 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

Generating Metadata Documentation Initially

Tab Page: Generated Properties

Characteristic Is Document Property

Tab Page: Online Documentation

Valid File Types

Editing Valid File Types

BAdIs for Use in Documents

Translating a Text for BW Objects

Transports

Object Changeability

Transport-Relevant Metadata Object Types

Versions within the Transport

Standard and BW Transport Connection (A Comparison)

Switching the Standard Transport System On and Off

Transport Connection: Transporting Objects

Subsequently Changing Package Assignment

Transporting Roles

Transporting BEx Objects

Business Content (Versions)

Installing Business Content

Collection Object Grouping

View of Objects and Object-Specific Recommendations

Installing BW Statistics

Customer and Partner Content

Customer Content

System Landscape

System Settings in the BW System

Delivery of Business Content by SAP

Using a Namespace for the Development of BW 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

Customizing Extractors

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 Statistics

Activating Data Transfers for BW Statistics

InfoCubes

BW Statistics MultiProvider

BW Statistics – OLAP

BW Statistics - OLAP, Detail Navigation

BW Statistics - Aggregates

BW Statistics - WHM

BW Statistics: Condensation of InfoCubes

BW Statistics: Deleting Data from InfoCubes

BW Statistics – Metadata

Application Component

Workbook

Type of data read

Automatic/Manual Posting

BW Metadata Repository: Association Type

BW System

Report/Report Interface InfoCube

Report/Report Interface Query

InfoCube from which Aggregate Was Supplied with Data

Calendar year / month

Calendar year / Quarter

Calendar Year / Week

Calendar day

Communication Structure

Runtime Category

Characteristic Value

Delete Data from InfoCube Mode

Navigation Step

ODS

OLAP reading on/off

BW Metadata Repository Object

BW Metadata Repository Object Type

Reporting Agent Settings

Reporting Agent Package

OLAP Processor Method

Process Type (WHM)

Currency Translation Type

WHM Transfer Type

Transfer Rules

Key Figures

Number of Database-Selects

Number of Frontend Sessions

Number of Navigations

Number of Texts Read

Number, All Data Records

Number of Texts Read

Number, Deleted Data Records

Formatting Transferred to Frontend

Total (OLAP)

Total Number of Records (WHM)

Total time (OLAP)

Total Load Time(WHM)

Frequency

Condenser: Number of Updated Records

Condenser: Number of Added Records

Condenser: Number of Deleted Records

Condenser: Number of Marker Updates

Condenser: Number of Added Markers

Condenser: Number of Selected Records

Condenser: Summarization Ratio

Condenser Runtime

Read-Cycles (Fetch) OLAP Processor

Last Used (Day)

Last Used (Time)

ODBO: External Calls for Function Module

ODBO: Size of the Internal Buffer

Start date

Start time

Records (WHM Process)

Records, Read for Aggregate Structure

Records, Written To Aggregate

Records Selected from the Database

Records Transferred from the Database

Time (WHM Method)

Time, Analysis

Time, Creating Indices

Time, Authorization Check

Time, Data Manager Authorizations for Non-Cumulatives

Time, Data Manager Determining SIDs for RemoteCube

Time, Data Manager Reading from BasicCube

Time, Data Manager Reading from ODS

Time, Data Manager Reading from RemoteCube

Time, Data Manager InfoCube Access

Time, Analyzing Dimension Tables

Time, Inputting Variables

Time ,Frontend

Time, OLAP Processor Initialization

Time, Reading to the Database

Time, Reading Texts/Master Data

Time, Records Deletion

Time, General ODBO

Time, ODBO: Data Requests

Time, ODBO: Initialization

Time, ODBO: Conversion into Flat Table Form

Time, ODBO: Axes Preparation

Time, ODBO: Data Records Preparation

Time, OLAP Processor

Time, Deleting Partitions

Time, Counting Records

Time That the System Was Unable to Assign

Time of Total Deletion Procedure

Time, Construction of Temporary Tables

Time Between Navigation Steps

Time: Adding when Rolling Up in Aggregate

Time: Reading when Rolling Up in Aggregate

Cells Transferred to the Frontend

BW Statistics Queries

BW Statistics MultiProvider Structures

Data Records (OLAP)

Total Time and Records (OLAP)

Last Use (Individual Record)

Last Use (Navigations)

Average Times and Records (Navigation)

Using Aggregates

Times (OLAP)

Times (OLAP) for Diagrams

Times and Data Records (OLAP)

Times and Records (WHM)

BW Statistics MultiProvider Queries

Chart: OLAP Records per InfoCube

Chart: OLAP Times per InfoCube

Fill Variable: Navigation Steps for Time Period

Rolling up Aggregates

Compressing Data into InfoCubes

Query Runtime

Deleting Data in InfoCubes

Deleting Data in InfoCubes – Detail, Times

Deleting Data in InfoCubes – Details, Records

Deleting Data in InfoCubes - Overview

Mean Time per Query

OLAP Usage

OLAP Usage per User

OLAP Usage for Each User (Total Number of Records)

OLAP Usage for Each User (Overall Time)

OLAP Usage for Each User (Time)

OLAP Usage per InfoCube

OLAP Usage by InfoCube (Records)

OLAP Usage for Each InfoCube (Time)

OLAP Usage per Query

OLAP Usage per Query (Time)

OLAP Use by Date

OLAP Usage According to Time

WHM Use per InfoCube

WHM Use per InfoSource

WHM Use per Day

WHM Use for Each Time

OLAP Performance with/without Read on Demand / Aggregates

Transfer Method: Loading Data

Using InfoCubes: OLAP / WHM

Using InfoCubes: OLAP / WHM - Records

Using InfoCubes: OLAP / WHM - Time

Using InfoCubes: Reporting / Loading

Using Hierarchies

Using InfoCubes

InfoCube BW Statistics Queries - OLAP, Detail

Using Hierarchies

Using InfoCubes / Aggregates to Navigate

Using InfoObjects

Using InfoObjects to Navigate

BW Data Slice

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

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)

Enhancements to the SAP Business Information Warehouse

BI Platform

OLAP

Special OLAP Functions and Services

Aggregation

Scenarios for the Use of an Exception Aggregation

Hierarchies

Options for Hierarchical Modeling

Hierarchy Nodes

Link Nodes

Loading Hierarchies

Loading Hierarchies Using a Process Chain

Special Features when Loading using the PSA

Loading Data as Subtrees

Creating Hierarchies

Modeling Nodes and Leaves

Editing Hierarchies

Functions of Hierarchy Processing

Level Maintenance

Hierarchy Attributes

Activating Virtual Time Hierarchies

Hierarchy Properties

Hierarchy Version

Maintaining Hierarchy Versions

Time-Dependent Hierarchies

Loading Time-Dependent Hierarchies

Intervals

Sign Reversal

Using Sign Reversal

Elimination of Internal Business Volume

Currency Translation

Scenarios for Currency Translation

Currency Translation Type

Specification of the Target Currency from an InfoObject

Creating Variables for Currency Translation Types

Creating Currency Translation Types

Editing Currency Translation Types

Transferring Translation Currency Exchange Rates on R/3 Systems

Transferring Global Table Contents: Currencies from R/3 Systems

Exchange Rates for Currencies in a Flat File

Uploading Exchange Rates from Flat Files

Currency Translation in the Update

Currency Translation in the Business Explorer

Setting Variable Target Currency in the Query Designer

Multiple Currency Translation Types in One Query

Currency and Unit Display in Business Explorer

Local Calculations

Selecting Constants

Slow Moving Item Scenario

Reporting Authorizations

Report-Report Interface

Editing Sender-Receiver Assignments to the R/RI in BW

Receiver

Maintaining Assignment Details

Creating Transactions as Receivers

Creating Web Addresses as Receivers

Examples for Jumping to Web Pages

BEx Query as Receiver

Example of a BEx Query as a Receiver

Web Applications as Senders

Performance Optimization

Non-Cumulatives

Modeling Non-Cumulatives with Non-Cumulative Key Figures

Non-Cumulative Key Figures

Time Reference Characteristic

Aggregation Behavior of Non- Cumulative Key Figures

Validity Area

Maintaining the Validity Area

Transferring Non-Cumulative Data into SAP BW

Procedure for Evaluating Non-Cumulative Key Figures

Interpreting Query Results

Excurs.: Mod. Non-Cumul. Key Figs with Differing Time Ref. Chars

Performance Tips

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

Loading Data into Aggregates Efficiently

Automatically Selecting and Optimizing Aggregates

Proposals from Queries

Proposals from BW Statistics

Optimizing Proposed Aggregates

Adjusting Changes to Hierarchies and Attributes

MOLAP Store

Conditions for BW InfoCubes

MOLAP Aggregate

MOLAP Cube (Root Aggregate)

Create MOLAP Cube

BEx Monitor

OLAP Trace Tool

Setting an OLAP Trace

Not Using Parallel Processing

Using the Cache Despite Virtual Characteristics/Key Figures

Technical Information

OLAP: Cache Monitor

Global Cache Parameters

Cache Data Removal and Swapping

Cache Structure

Logical File Name

Metadata Repository

Searching for Metadata

Displaying Graphics

HTML Export

Exchanging Metadata in XMI Format

Calling the Metadata Repository as an HTTP service

Business Planning and Simulation (BW-BPS)

Overview of Planning with BW-BPS

Planning Environment

Buffer Concept (BW-BPS)

Planning Area

Editing a Planning Area

Data Slices

Multi-Planning Area

Multi-Planning Area: Application Examples

Variables

Defining Variables

Using Variables

Characteristic Relationships

Defining Characteristic Relationships

Where-Used List for Characteristic Relationships

Planning Level

Planning Package

Set Up of Planning Architecture

Planning Profile

Editing and Managing Planning Profiles

Manual Planning

Planning Layout

Determining Basic Settings

Hierarchically Structured Planning

BPS Characteristic Hierarchy

Characteristic Combinations

Automatic Execution of Planning Functions

Dynamic Data and Lead Columns

Rolling Planning

Determining Detail Settings

Configuring Data Columns

Formatting Generated Layout in the Preview

MS Excel-Specific Formatting Options

Editing Styles

Editing the Layout Template

Setting Totals Rows

Documents in the Planning Layout

Entering Plan Data

Automatic Sign Assignment

Local Functions

Manual Data Entry

Locking Cells, Unlocking Cells

Top-Down Distribution

Revaluate

Planning Layout: Environment-Specific Attributes

Locking Transaction Data

Customizing with Reference to the Locking Concept

Editing Plan Data Automatically

Data Transfer to Planning Functions

Trace Mode for Planning Functions

Copy

Distribute

Repost

Reposting (Characteristic Relationships)

Delete (Invalid Combination)

Revaluation

Forecasting

Forecast Strategies

Automatic Model Selection

Optimization of Smoothing Factors for Exponential Smoothing

Outlier Correction

Trend Dampening

Setting Negative Forecast Values to Zero

Logging Statistical Key Figures

Ignoring Initial Zeros

Model Initialization

Forecast (Old)

Model Selection

Manual Model Selection

Automatic Model Selection

Exit Function for Forecasting

Forecast Parameters

Obligatory Forecast Parameters

Optional Forecast Parameters

Exit Function for The Log Display

Formula

Formula Operands (in Dependency on Key Figure and Characteristic

Exit Function

Currency Translation

Currency Translation: Notes on Modeling

Unit Conversion

Unit Conversion: Notes on Modeling

Planning Sequences

Planning Folder

Editing a Planning Folder

Editing a Planning Folder: Details

Planning Folder: Portfolio Graphic

Automatic Execution of Layout-Dependent Planning Functions

Automatic Execution of Global Functions

Documents in Planning Folders

Executing a Planning Folder

Web Interface Builder

Creating and Editing a Web Interface

Components for Web Interfaces

CSS Classes for Web Interfaces

Modifying CSS Classes for Web Interfaces

Status and Tracking System

Authorization Objects in the STS

Maintaining Web Services for STS

Customizing the Status and Tracking System

Executing Customizing

Determining a Hierarchy for the Subplan

Determining Date, Person Responsible, Layouts

Executing Global Planning Sequence upon Status Switch

Adjusting Notification Texts

Maintaining Text with Additional Information

Overview: Planning with the Status and Tracking System

Planning with the Status and Tracking System

Executing Planning

Checking Planning Results

Monitoring Planning Processes

Transport

Translation

Data Modeling: Key Figure Model and Account Model

Architecture and System Landscape (BW-BPS)

Application Programming Interface (API)

Workflow Scenarios for BW-BPS

Technical Realization

Preparation and Customizing

Workflow: Manual Planning and Planning Function

Workflow: Planning Session with One Layout

Workflow: Planning Session with Several Layouts

Analysis Process Designer

Structure of the Analysis Process Designer

Data Sources for an Analysis Process

Attributes of a Characteristic

Transformations for an Analysis Process

Limiting Data Volume

Aggregating data

Joining Data from Multiple Sources (Join)

Hiding Columns

Sorting Data

Transforming Lists into Data Records

Transformation of Data Records into Lists

ABAP routines

Data Mining Methods

Data Targets for an Analysis Process

Attributes of a Characteristic

ODS Object

CRM Attributes

Data Targets for SAP CRM

Data Mining Models

Modeling an Analysis Process

Creating an Analysis Process

Checking Data

Formulas to Calculate the Statistics

Additional APD Functions

Special Settings for Regression Analysis

Weighted Score Tables

Special Settings for Weighted Score Tables

Settings for All Function Types

Activities in the Data Mining Workbench

Creating, Changing, and Activating a Model

Resetting or Deleting a Model

Executing What If Analysis

Using the Where Used List

Exporting Model as PMML

Maintaining DataSource for Association Rules

Activities in the Analysis Process Designer (APD)

Creating Analysis Process for Training

Analysis Process for Data Mining Transformations

Analysis Process for Executing the Prediction

Evaluating a Decision Tree Model

Transformation for Weighted Score Tables

Transformation for ABC Classification

Loading Mining Results into SAP BW

Loading Mining Results into SAP CRM

Reporting Agent

Defining Settings for Exceptions

Tab Page: Parameters

Editing a Follow-Up Action: Send Message

Editing 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

Parameter DATA_MODE

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

Scheduling a Package as a Job

Inserting a Package into a Process Chain

Managing Bookmarks

ICF Services in SAP BW

BI Suite: Business Explorer

Query Design: BEx Query Designer

Functions of the BEx Query Designer

Defining New Queries

Restricting Characteristics

Restricting Characteristics: Hierarchies

Selecting Hierarchies

Technical Notes about the Formula Operators

Defining Exception Cells

Save Queries

Using Variables: The Variable Wizard and the Variable Editor

Variable Types

Using Text Variables

Variable Processing Types

Manual Entry / Default Value

Replacement Path

Customer Exits

Dependencies for Variables of Type Customer Exit

SAP Exit (delivered variables)

Authorization

Overview of Variable Types and Processing Types

Defining Variables with the Variable Wizard

Details

Special Features with Dynamically Changeable Variables

Default Values

Replacement Path

Replacement Path: Replacement with a Characteristic Value

Calculating Variables for Processing Type “Replacement Path”

Variable Replacement Example

Replacement Path: Replacement with Query

Characteristic

Currencies and Units

Changing Variables in the Variable Editor

Examples for Using Variables

Query Properties

Properties of Query Components

Characteristic Properties

Attribute Properties

Structure Properties

Selection/Formula Properties

Restricted Key Figure Properties

Calculated Key Figure Properties

Defining Conditions

Defining Exceptions

Conditions/Exceptions: Inserting, Changing, Deleting Rows

Tabular Query Display

Defining Calculated Key Figures

Defining Restricted Key Figures

Structures

Creating Reusable Structures

Structure Element Texts and Their Language-Dependency

Displaying and Changing Existing Queries in the Query Designer

Example: Defining a Query with Key Figures

Example: Defining Filters, Free Characteristics, Columns and Row

Example: Defining Cells for Changes to Key Figures

Functions on the BW Server

Copying Queries Between InfoCubes

Deleting Query Objects

BEx Web

Web Application Design: BEx Web Application Designer

BEx Web Application Designer

Functions of the Web Application Designer Menu Bar

The Web Items Window

The Template Window

The Properties Window

From Web Template to Web Application

Creating Web Applications with the BEx Web Application Designer

Further Editing Web Templates

Enhanced Editing in Text Mode

Mass Maintenance and Conversion of Web Templates

Creating Web Applications with the Web Application Wizard

Determining Settings

Storage of Stylesheets and Symbols

Web Template Properties

Designing the Layout of Web Templates

Context Menu in Web Templates

Merging Cells in an HTML Table

Working with the Library for Web Items

Automatic Axis Labeling for Simple Charts

Dropdown Box

Radio Button Groups

Checkboxes

Generic Navigation Block

Hierarchical Filter Selection

Attributes for Map Layers

Special Attributes for Color Shading

Special Attributes for Bar Charts

Special Attributes for Pie Charts

Special Attributes for Pie Charts (split)

Special Attributes for Dot Density

Special Attributes for Symbols

Special Attributes for Symbol (Size-dependent)

Special Attributes for Symbol (Color-dependent)

Special Attribute: Line

Special Attribute: Line (Size-dependent)

Special Attributes for Lines (Color-dependent)

Array Attributes

Map Renderer

Additional Cartographical Information

Displaying Additional Cartographical Information

Single Document

List of Documents

Object Catalog of the Web Application

Data Provider – Information

Web Template

Broadcaster

Query View – Selection