SAP Library - Business Intelligence

Business Intelligence

What's New in BI with SAP NetWeaver 7.0

Business Intelligence: Overview

What Is Business Intelligence?

Integration, Storage and Management of Data

Extraction, Transformation and Loading (ETL)

Data Storage and Data Flow

Control of Processes

Information Lifecycle Management

Extraction to Downstream Systems

Metadata and Documents

Data Analysis and Planning

Online Analytical Processing

Analysis Process Design

Data Mining

Business Planning

Tools for Accessing and Visualizing Data

Query Design

Enterprise Report Design

Web Application Design

Data Analysis in BEx Web Applications

Data Analysis with Microsoft Excel

Embedded BI and Composite Applications

Publishing BI Content

Broadcasting BI Content

Integrating Content from BI into the Portal

Performance

Security

BI Content

Overview of the Architecture of SAP NetWeaver BI

Step-by-Step: From the Data Model to the BI Application in the W

Creating Key Figures

Creating Characteristics

Creating InfoCubes

Creating DataSources for Master Data of Characteristic "Product"

Creating DataSources for Transaction Data

Creating Transformations for Master Data of Characteristic "Prod

Creating Transformations for InfoCubes

Creating Master Data Directly in the System

Loading Master Data for Characteristic "Product"

Loading Transaction Data

Defining Queries

Creating Web Applications

Analyzing Data in the Web Application

Broadcasting Web Applications by E-Mail

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

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

InfoProvider Properties

Additional Functions in DataStore Object Maintenance

DB Memory Parameters

Multidimensional Clustering

Definition of Clustering

Performance Tips for DataStore Objects

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 a Data Store Object

Customer Exits in Remodeling

Monitor and Error Handling

Data Staging

Source System

Connection between Source Systems and BW

Logical System Names

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

Replicating Switches

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

Settings for Delta Transfer

Function Module: Interface Description and Procedure

Testing Extraction

Extraction Using the 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)

Transferring Data Using Staging BAPIs

Transferring Data with SAP Landscape Transformation Replication

Resuming the Load Process

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

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

Operating System Command

Including Operating System Commands as Processes in Process Chai

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

Errors in Data Records

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

Reading Stored Data

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

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

Archiving 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

Exchanging Metadata in XMI Format

Calling the Metadata Repository as an HTTP Service

Documents

Document Classes

BAdIs for Use in Documents

Hyperlinks to Documents

BI Security Manager for Documents

Repository Manager for BI

BI Document Repository Manager

BI Metadata Repository Manager

OLAP

Special OLAP Functions and Services

Aggregation

Examples in the Data Warehousing Workbench

Examples of Exception Aggregation: Last Value and Average

Examples of Exception Aggregation: Average (AV1)

Examples in the BEx Query Designer

Example of Exception Aggregation: Counting

Example of Exception Aggregation: Enhanced Counting

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

Time-Dependent Hierarchy Structures in the Query

Loading Time-Dependent Hierarchies

Intervals

Sign Reversal

Using Sign Reversal

Elimination of Internal Business Volume

Currency Translation

Scenarios for Currency Translation

Currency Translation Type

Defining Target Currencies Using InfoObjects

Creating Variables for Currency Translation Types

Creating Currency Translation Types

Transferring Exchange Rates for Currencies from SAP Systems

Transferring Global Table Entries for Currencies from SAP System

Exchange Rates for Currencies in Flat Files

Uploading Exchange Rates from Flat Files

Currency Translation During Transformation

Currency Translation in Business Explorer

Setting Variable Target Currency in the Query Designer

Multiple Currency Translation Types in One Query

Currency and Unit Display in Business Explorer

Quantity Conversion

General Information About Quantity Conversion

Prerequisites for InfoObject-Specific Quantity Conversion

Quantity Conversion Types

Defining Target Units of Measure Using InfoObjects

Creating Variables for Quantity Conversion Types

Creating Quantity Conversion Types

Transferring Global Table Entries for Units of Measure from SAP

Quantity Conversion During the Transformation

Quantity Conversion in Business Explorer

Setting Variable Target Units of Measure in the Query Designer

Quantity Conversion Scenarios

Example Data – Without Compounding

Conversion with Fixed Target Quantity

Conversion Using Factors from InfoObjects

Conversion with Target Unit of Measure Using Attribute in InfoOb

Conversion with Fixed Target Unit of Measure and Dynamic Determi

Example Data – With Compounding

Conversion with Fixed Target Unit of Measure

Conversion Using Factors from InfoObjects

Conversion with Target Unit of Measure Using Attribute in InfoOb

Conversion with Fixed Target Unit of Measure and Dynamic Determi

Local Calculations

Constant Selection

Example: Market Index

Example: Using Constant Selection with MultiProviders

Analysis Authorizations

Report-Report Interface

Process when Calling the RRI

Editing Sender-Receiver Assignments to the RRI in the BI System

Receivers

BEx Query As a Receiver

Example of a BEx Query as a Receiver

Creating a Transaction As a Receiver

Creating a Web Address As a Receiver

Examples for Web Addresses as Receiver

iView As Receiver

Creating Your Own Report Type as Receiver

Maintaining Assignment Details

SAP DemoContent for Features

Performance Optimization

Performance Optimization with SAP NetWeaver BI Accelerator

Administration of SAP NetWeaver BI Accelerator

Performance Optimization with Aggregates

Aggregates

Selection Type "All Characteristic Values" ('*')

Selection Type "Fixed Value" (‘F’)

Selection Type "Hierarchy Level" ('H').

Create and Change

Creating the First Aggregate for an InfoCube

Editing Aggregates Manually

Design and Components of Aggregates

Further Editing Functions for Aggregates

Automatic Selection and Optimization of Aggregates

Proposals from Queries

Proposals from BI Statistics

Optimizing Proposed Aggregates

Activation and Provision of Data

Activating and Filling Aggregates

Rolling up Data into an Aggregate

System Response to Changes to Master Data and Hierarchies

Loading Data into Aggregates Efficiently

Performing Checks for Aggregates

Check Time

Check Mode

Technical Information

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

Process Flow for Evaluating Non-Cumulative Key Figures

Interpreting Query Results

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

Performance Tips

BEx Monitor

Trace Tool Environment

Trace Tool

Log User Actions

Determine a Logged Trace

Reexecution of Logged User Actions

Maintenance of Trace Properties

CAT Tool

Administration

OLAP Trace Tool (Old)

Setting an OLAP Trace

Query Monitor

Query Properties

Read Mode

Specifying Data Integrity According to the Request Status

Cache Mode

Activating Delta Caching

Specifying the Grouping for Delta Caching

Accuracy

Not Using Parallel Processing

Processing Queries

Using the Cache Despite Virtual Characteristics and Key Figures

Technical Information

OLAP: Cache Monitor

Cache Parameters

Cache Administration Parameters

Technical Information About Old Cache Modes

Cache Data Removal and Swapping

Cache Structure

Logical File Names

BI Query Runtime Statistics

Analysis of Statistics Data

Maintenance of Statistics Properties

Analyzing Statistics Data for a MultiProvider Query

Overview of Statistics Events (Table RSDDSTATEVENTS)

Aggregation of Query Runtime Statistics

Migration Details

Business Planning

BI Integrated Planning

Modeling Planning Scenarios

Modeling Scenarios

InfoProvider

Characteristic Relationships

Characteristic Relationships for Time Characteristics

Data Slices

Aggregation Level

Simple Aggregation Level

Complex Aggregation Level

Filters

Planning Functions

Process Flow of Planning Function: Distribution by Key

Standard Planning Function Types

Unit Conversion

Generate Combinations

Formula

Operators and Functions

Data Declaration

Conditional Statements

Loop Constructs

Notification Output

Function Modules

Examples for Formula Applications

Copy

Delete

Deleting Invalid Combinations

Forecasting

Forecast Strategies

Automatic Model Selection

Outlier Correction

Trend Damping

Logging Statistical Key Figures

Ignoring Initial Zero Values

Repost

Repost (Characteristic Relationships)

Revaluation

Distribution by Key

Distribution by Reference Data

Currency Translation

Standard Key Date in Planning Functions

Planning Sequences

Scheduling Planning Sequences in Process Chains

Planning Sequence for Bottom-Up Planning

Variables

Changing Variable Values in the Planning Modeler

Personalizing Variables

Saving Variants in Planning Functions and Planning Sequences

Input-Ready Query

Defining Inverse Formulas

Example: Inverse Formula

Form-Based Planning

Implementing Planning Function Types

Creation of Planning Applications

Creating Planning Applications in the BEx Analyzer

Command Wizard

Transferring Variable Values

Creating Planning Applications in the BEx Web Application Design

Commands for Planning Applications

Executing a Planning Function (Simple)

Executing a Planning Function

Execute a Planning Sequence (Simple)

Sources for Characteristic Selection and Variables

Additional Examples of Planning Applications in the BEx WAD

Copying Planning Functions (with Dropdown Box Web Item)

Revaluating Planning Functions (with Analysis Web Item)

Documentation (with Analysis Web Item)

Performing Manual Planning

Functions for Manual Planning

Disaggregation (Top-Down Distribution)

Inverse Formulas at Runtime

Examples: Inverse Formulas at Runtime

Cell Fixing

Local Cell Fixing in a Query (Front End)

Global Cell Fixing in a Planning Application (Back End)

Saving Changed Values

Business Planning Portal Role

Transport of Planning Objects

Lock Concept and Lock Management

Management of Lock Settings

Storage of Lock Tables

Selection of Lock Characteristics

Display of Active Locks

Analysis of Locking Conflicts

Display of Master Locks

Sizing of Lock Tables

Performance Tips

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

Making Basic Settings

Hierarchically Structured Planning

BPS Characteristic Hierarchy

Characteristic Combinations

Automatic Execution of Planning Functions

Dynamic Data and Lead Columns

Rolling Planning

Making Advanced 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 Web Interfaces

Components for Web Interfaces

Design Templates for Web Interfaces

Using Your Own Style Sheet (New Design)

CSS Classes for Web Interfaces (Old Design)

Modifying CSS Classes for Web Interfaces (Old Design)

Enhancements 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

Setting a Hierarchy for the Subplan

Setting the Date, Person Responsible and Layouts

Executing Global Planning Sequence upon Status Switch

Adjusting Notification Texts

Maintaining Text with Additional Information

Planning with the Status and Tracking System

Organization of Planning Tasks

Executing Planning

Checking Planning Results

Monitoring Planning Processes

Integrating BI Integrated Planning

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

Modeling an Analysis Process

Creating an Analysis Process

Checking Data

Formulas to Calculate the Statistics

Additional APD Functions

Data Sources for an Analysis Process

Attributes of a Characteristic

Transformations for an Analysis Process

Restricting Amount of Data

Aggregating data

Join Data from Multiple Sources

Unify Data from Two Data Sources (Union)

Hiding Columns

Sorting Data

Formula

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

DataStore Object

File

CRM Attributes

Data Targets for SAP CRM

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

Functions for SAP BW 3.x

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 Print Settings

Tab Page: Print Settings

Defining the Print Layout

Defining the Web Template Setting

DATA_MODE Parameter

Control Query for Pre-calculating Web Templates

Defining Value Set Settings

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

Including Packages in a Process Chain

Managing Bookmarks

ICF Services in BI

BI Suite: Business Explorer

Query Design: BEx Query Designer

BEx Query Designer

Working with BEx Query Designer

Functions of the Menu Bar in the Query Designer

Functions in the Query Menu

Functions in the Edit Menu

Functions in the View Menu

Functions in the Tools Menu

Functions in the Help Menu

Defining New Queries

Restricting Characteristics

Restricting Characteristics: Hierarchies

Selecting Hierarchies

Technical Notes About the Formula Operators

Defining Exception Cells

Defining Conditions

Defining Exceptions

Saving Queries

Displaying and Changing Existing Queries in the Query Designer

Reusable Query Components

Structures

Creating Reusable Structures

Structure Element Texts and Their Language-Dependency

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

Calling the Variable Editor

Defining Variables

Details

Replacement Path

Replacement Path: Replacement with a Characteristic Value

Calculating Variables for Processing Type “Replacement Path”

Variable Replacement Example

Replacement Path: Replacement with Query

Replacement Path: Replacement from Variable

Currencies and Units

Default Values

Defining Default Values for Variables to Allow Overwriting

Defining Restricted Key Figures

Defining Calculated Key Figures

Query Properties

Properties of Query Components

Characteristic Properties

Properties of Characteristic Restrictions and Default Values

Attribute Properties

Selection/Formula/Cell Properties

Row/Column Properties

Properties and How They Are Derived

Switchable Query Components in the Switch Framework

Examples

Example: Defining a Query with Key Figures

Example: Defining Filters, Free Characteristics, Columns and Row

Example: Defining Cells for Changes to Key Figures

Examples for Using Variables

Example: List of Slow-Moving Items

Functions on the BI Server

Copying Queries Between InfoCubes

Deleting Query Objects

BEx Web

Web Application Design: BEx Web Application Designer

BEx Web Application Designer

Screen Areas in the Web Application Designer

Web Items Screen Area

Web Template Screen Area

Properties Screen Area

Errors and Warnings Screen Area

Functions of the Web Application Designer Menu Bar

Functions in the Web Template Menu

Functions in the Edit Menu

Functions in the View Menu

Functions in the Insert Menu

Functions in the Format Menu

Functions in the Tools Menu

Functions in the Table Menu

Functions in the Window Menu

Functions in the Help Menu

Web Templates

Web Template Properties

Layout Design of Web Templates

Context Menu in Web Templates

Merging Cells in an HTML Table

Further Editing Web Templates

Mass Maintenance and Mass Conversion of Web Templates and Reusab

Migration Tool

Migrating Web Templates

Text Input Dialog

Creating ABAP Programs for Maintaining Language-Dependent Texts

Creating a Web Application

Calling the Web Application

Connecting the Data to Be Displayed

Displaying the Data

Interaction in the Web Application

Displaying Additional Information and Layout Design

Reusability in Web Applications

Creating Web Applications with the BEx Web Application Designer

Working with Reusable Web Items

Storing and Including Images and Icons

Formatting of Web Applications

Adjusting and Assigning Portal Themes for SAP NetWeaver BI

Using Portal Themes in SAP NetWeaver BI

Settings for Tables, Trees, Labels and Fields

Pattern Wizard

Configuring Information Consumer Patterns

Web Design API

Web Items

Web Item Grouping: Standard

Analysis

Chart

Automatic Axis Labeling for Simple Charts

Editing Charts

Working with the Chart Designer

Formatting a Chart Using the Wizard

Defining Chart Properties

Changing the Chart Type

Changing the Size and Position of Chart Elements

Formatting Axes and Gridlines

Formatting Texts

Formatting Data Series and Data Points

Reversing the Order of Data

Plotting Data Series on a Secondary Axis

Adding Data Labels

Adding, Changing, and Removing Trend Lines

Rotating Charts

Formatting 3D Effects

Examples of Improved Chart Layout

Example: Configuring How Column Charts Are Displayed

Example: Configuring How Line Charts Are Displayed

Example: Configuring How Pie Charts Are Displayed

Example: Configuring How Multiple Chart Types Are Displayed in a

Data Binding Type CHARACTERISTIC_SELECTION

Data Binding Type QUERY_VIEW_SELECTION

Data Binding Type STATIC_OPTION_LIST

Data Binding Type STATIC_OPTION_LIST_MANUAL

Data Binding Type VARIABLE_SELECTION

Web Item Grouping: Advanced

Parameters for Map Layers

Map Renderers

Parameters for Color Shading

Parameters for Bar Charts

Parameters for Pie Charts and Pie Charts (Split)

Parameters for Dot Density

Parameters for Symbols

Parameters for Symbols (Size-Dependent)

Parameters for Symbols (Color-Dependent)

Parameters for Lines

Parameters for Lines (Size-Dependent)

Parameters for Lines (Color-Dependent)

Additional Cartographical Information

Displaying Additional Cartographical Information

System Messages

Info Field

Input Field

Web Item Group: Miscellaneous

Data Provider – Information

Web Template Parameters

Data Provider Parameters

Parameter Tray

Commands

Commands for Data Providers

Basic Data Provider Commands

Report-Report Interface

Set Data Provider Parameters

Set Zero Value Display

Set Sign Display

Back to Initial State

Back to Previous State

Translating Currencies

Export Data Provider as XML

Data Provider Commands for Axes

Set Hierarchical Display of Axis

Set Position of Results Row

Swap Axes

Remove Drilldown

Drill Down a Characteristic

Exchange Characteristics/Structures

Data Provider Commands for Characteristics

Set Display Attributes

Set Presentation

Display Result Row

Set Sorting

Data Provider Commands for Conditions/Exceptions

Set Condition

Set Status of a Condition

Set Exception

Set Status of an Exception

Call Conditions Dialog

Call Exceptions Dialog

Data Provider Commands for Data Cells

Set Data Cell Properties

Set Local Calculations

Data Provider Commands for Filter Values

Remove All Filter Values

Call Input Help Dialog

Setting Filter Values for a Characteristic

Set Filter Values

Remove Filter Values for a Characteristic

Remove Filter Values for a List of Characteristics

Set Filter Values Using Different Sources

Setting Filter Values Using a Filter

Data Provider Commands for Hierarchies

Set Hierarchy

Expand/Collapse Hierarchy Nodes

Set Node Alignment

Data Provider Commands for Open/Save Functions

Call Open Dialog

Call Save Dialog

Save Query View

Data Provider Commands for Documents

Open Document Browser

Open Dialog for New Document

Commands for Planning Applications

Executing a Planning Function (Simple)

Executing a Planning Function

Execute a Planning Sequence (Simple)

Sources for Characteristic Selection and Variables

Commands for Web Items

Call Chart Properties Dialog

Call Properties Dialog

Setting Web Item Parameters

Back to Initial State

Back to Previous State

Set Status of Module

Commands for Web Templates

Export Web Application

Change Web Template

Display Web Template as Modal Dialog

Close Current Web Template Dialog with Cancel

Close Current Web Template Dialog with OK

Set Web Template

Back to Initial State

Back to Previous State

Delete Personalization

Save Personalization

Creating Commands with the Command Wizard

Parameter Override

Using Parameters to Call Web Applications

Dynamic Parameterization of Commands and Web Items

Use of JavaScript in Web Applications and Web Items

JavaScript API for Executing Commands

Adding Menu Entries with JavaScript

Command Processing

BEx Web Interfaces

Custom Extension Web Item

Creating an ABAP Class for the Custom Extension Web Item

ABAP Interface IF_BICS_CONS_WEBITEM_CUST_EXIT

Inserting a Custom Extension into a Web Template

Simple Example: Displaying a Simple Text and Parameter

Complex Example: Displaying the XML of Two Data Providers

Calling a BSP Page Specifying the Data Provider Status

Analysis Web Item: Using Parameter Modification

Using Modifications

Examples of Modules

Example: Column Width Module

Example: Negative Number Module

Example: Document Content Module

Example: Empty Cells as Non Input-Enabled Module

Web Application Examples

Changing the Display: Table, Chart, Table and Chart

Switching Between Chart and Table Using a Pushbutton

Using JavaScript in the Dropdown Box Web Item

Using Cascading Dropdown Boxes

Creating Planning Applications in the BEx Web Application Design

Using Path Replacement in Commands

Enterprise Reporting

From the Query to the Report

Static and Dynamic Sections in Reports

Row Patterns

Row Pattern Properties

Creating Reports with Report Designer

Inserting Images into Reports

Creating Conditional Formatting

Formatting Hierarchies

Inserting Charts into Reports

Defining Chart Properties

Inserting User-Specific Texts

Reusing Report Sections

Standard Web Template for Reports

BEx Report Designer

Functions in Report Designer

Working with Report Designer

Menu Bar Functions in Report Designer

Functions in the Report Menu

Functions in the Edit Menu

Functions in the View Menu

Functions in the Insert Menu

Functions in the Format Menu

Functions in the Tools Menu

Functions in the Help Menu

Example Scenarios: Creating Different Report Types

Balance Sheet: Aligning Assets and Liabilities

Displaying a Query in a Tabular View

Tasks for System Administration

Mass Maintenance and Mass Conversion of Web Templates and Reusab

Reorganization of Bookmarks

Displaying BI Query Runtime Statistics on the Web

Setting the Size Restriction for Result Sets

Activating the Export Library for SAP NetWeaver BI

Analysis & Reporting: BEx Web Applications

Analyzing Data in an Analysis Grid (with Navigation and Filter P

Example: Swapping Axes in the Navigation Pane Using Drag and Dro

Example: Moving a Characteristic in the Navigation Pane Using Dr

Example: Moving a Characteristic in the Rows Using Drag and Drop

Example: Dragging and Dropping Structural Components in the Colu

Example: Dragging a Characteristic to the Columns Using Drag and

Example: Dragging a Characteristic to the Rows Using Drag and Dr

Example: Dragging a Characteristic to a Data Cell Using Drag and

Example: Dragging a Characteristic to a Characteristic Value of

Example: Dragging a Characteristic Value to a Characteristic Usi

Example: Dragging a Characteristic Value to Another Characterist

Context Menu Functions

Goto

Making Currency Translations

Exporting as a CSV File/Excel File

Setting Bookmarks

Characteristic Properties

Properties of Structure Elements and Data Cells

Data Provider Properties

Axis Properties

Properties of the Web Item

Restricting Data Using Filter Values

Selecting Filter Values

Changing Filter Values

Searching for Values

Maintaining User Settings for the Input Help Dialog Box

Syntax for Directly Entering Values

Defining Formulas Ad Hoc

List of Conditions

Defining and Changing Conditions

List of Exceptions

Defining and Changing Exceptions

Web Items for Setting Filter Values and Hierarchical Filter Sele

Query View Selection with a Dropdown Box

Web Template

Using Documents in Web Applications

Creating a New Document

Display of Documents for InfoProvider Data

Displaying Documents for a Cell

Special Features of Calculated Key Figures and Formulas

Navigating in Maps

Functions in the Geo Function Bar

Displaying Exceptions in Maps and Charts

Using Variables in Web Applications

Working with the Variables Screen

Creating Query Variants

Personalizing Variables in Web Applications

Personalizing the Start Views of Web Applications

Web Browser Dependencies

BEx Web Analyzer

Pushbutton Functions, Navigation Pane, and Context Menu

Function Links

Standard Web Template for Ad Hoc Analysis

BI Patterns

Information Consumer Pattern

Business Explorer Portal Role

BEx Mobile Intelligence

Analysis & Reporting: BEx Analyzer

Refresh / Pause Automatic Refresh

Using Variables in BEx Analyzer

Changing Variable Values

Personalizing Variables

Saving Query Variants

Local Formula

Tools

Global Settings

Context Menu for Selected Cell

Connect / System Information

Navigating in Analysis Mode

Context Menu Functions

Drag and Drop Functions

Selecting Filter Values

Characteristic Properties

Key Figure Properties

Query Properties

Drill Across Worksheets

Defining Conditions in a Workbook

Functions for Manual Planning

Goto

Working in Formula Mode

Precalculating and Distributing Workbooks

Design Mode

Design Functions

Design Mode / Exit Design Mode

Inserting Design Items

Tab Page: Data Provider

Tab Page: Variables

Tab page: Themes

Tab Page: Design Items

Tab Page: Exits

Configuring Data Providers

Moving and Resizing Design Items

Deleting Design Items

Integration with Visual Basic for Applications

General Error and Message Handling

Restrictions in the BEx Analyzer

Working with Documents in BEx Analyzer

General Analysis Functions in BEx

Conditions

Definition of Conditions

Basics and Example Scenarios for Conditions

Ranked List Condition: Top 5 Products

Linking to Conditions: Bottom 2 Revenue and Invoiced Quantity >

Ranked List Condition with 2 Condition Rows: Top 2 Products and

Ranked List Condition for All Characteristics in Drilldown Indep

Query with Condition and Results Row Suppression

Ranked List Condition for Characteristic Combination: Top 10 Com

Threshold Condition for a Characteristic in a Cross-Classified T

Condition for All Characteristics in Drilldown Independent

Enhanced Basics and Example Scenarios for Conditions

Query with Two Structures and Threshold Value Conditions: And/Or

Query with Two Structures and Ranked-List Conditions

Query with a Presentation Hierarchy and Conditions

Query with Two Presentation Hierarchies and Conditions

Query with Hierarchically Displayed Axis and Conditions

How Conditions Interact with Hierarchies

Using Conditions

Background Information on Conditions

Exception Reporting

Defining Exceptions

Local Calculations

Calculate Results As...

Calculate Single Values As...

Aggregation and Calculation Time for Data

Interpretation of Results Rows

Priority Rule with Formatting Settings

Working with Hierarchies

Suppression of Zero Rows and Zero Columns

General Services in BEx

Working with BEx Objects

Working with Queries

Working with Filters

Working with Variables

Working with Structures

Working with Calculated and Restricted Key Figures

Working with Query Views

Working with Data Providers

Working with Reusable Web Items

Working with Broadcast Settings

Opening and Saving Objects in BEx

Selecting Characteristic Values

Searching for Values

Maintaining User Settings for the Input Help Dialog Box

Personalization in BEx

Creating Print Versions of BI Applications

Runtime and Design-Time Cross-Dependencies: SAP BW 3.x and SAP N

Information Broadcasting

Configuration for Information Broadcasting

Tasks for System Administration

Provision of Broadcasting Functions

Setting Up Broadcasting to the Portal

Setting Up Broadcasting in Federated Portal Networks

Setting Up Broadcasting Using WebDAV Repository Managers

Setting Up Broadcasting Using KM Navigation iViews or CM Reposit

KM Properties

Including Event Data Changes in Process Chains

Defining Times for Broadcast Scheduling

Administrating the Precalculation Servers

Administrating the Precalculation Servers (Transaction RSPRECALC

Working with Precalculation Servers

Analyzing Precalculations

Setting Timeouts

Checking Failed Settings

Administrating the Precalculation Servers (Transaction SPRO)

Creating Precalculation Servers

Configuring Alert Management for Generating Alerts

Broadcasting Functions

Creating a Broadcast Setting

Broadcast by E-Mail (Bursting)

Broadcast by Exception

Distribution over Multiple Channels

Precalculating Value Sets

Filling the OLAP Cache

Filling the MDX Cache

User/Language

Management and Monitoring

Administration of Broadcast Settings

Monitoring the Sending of E-Mails

Reorganization of Bookmark IDs and View IDs

User Guide

Calling the BEx Broadcaster

Functions of the BEx Broadcaster

Precalculating and Broadcasting Queries, Query Views, Web Templa

Making General Settings for Precalculation and Creating Links

Filter Navigation

Precalculating and Distributing Workbooks

Broadcast by E-Mail

Broadcast to the Portal

Displaying the Folder Content with the Broadcasting Layout Profi

Printing

Use of Text Variables

Scheduling Broadcast Settings

Finding, Displaying, and Deleting Scheduled Broadcast Settings

Example Scenarios for Information Broadcasting

Distribution of the Monthly Sales Report by E-mail

Ad-hoc Distribution of Unusual Sales Data by E-mail

Providing the Sales Report in the Portal and Notification Upon D

Ad-hoc Distribution of the Sales Report into Collaboration Rooms

Integrating Content from BI into the Portal

Integration from the User’s Viewpoint

Displaying Content from BI in the Portal

Calling Content from BI in the Portal

BI Content in the Navigation Panel

Business Intelligence Portal Role

Integration from the Viewpoint of Administrators and Authors

Overview: Integration and Display Types for Content from BI

Display of Content from BI in the Portal

BEx Web Application or Query as iView in the Portal

BEx Web Application or Query As Document or Link in KM

BEx Analyzer Workbook as an iView in the Portal

BEx Analyzer Workbook As Precalculated Document in KM

BI Documents in Knowledge Management

Document Structure for Metadata

Document Structure for Master Data

Document Structure for InfoProvider Data

Migrating Documents into the CM Repository

Migration iView

Migrating Documents

Web Interface (from BW-BPS) as iView in the Portal

BI Components in Portal

BI Content in the Navigation Panel

Calling Content from BI in the Portal

Calling with Portal Roles

Calling with KM Folders

Calling with the BEx Portfolio

Navigation with BI Content in the Portal

Eventing in the Portal

Navigation in the Portal

Determining the Path of the iView

Transferring Parameters to a BEx Web Application iView

Transfer Parameters to an SAP Transaction

Jumping Using the Report-Report Interface in the Portal

Determining the Path of the iView

Maintaining Sender-Receiver Assignment for BEx Web Application i

Maintaining Sender-Receiver Assignment for SAP Transaction iView

Creating Content from BI for the Portal

Integration Functions in the BEx Broadcaster

Publishing Queries, Web Applications and Reports

Integration Using the Portal Content Studio

Integration Using KM Content

Integration Using Role Upload

Integration of Content from BI into Other Portals

Integrating into an SAP NetWeaver 2004 Portal (SAP EP 6.0)

Creating a System in the SAP NetWeaver 2004 Portal (SAP EP 6.0)

Configuring Single Sign-On (SSO) Between SAP EP 6.0 and the SAP

Integration into an SAP NetWeaver 7.x Portal

Setting Up Access to URLs from BEx in the Federated Portal Netwo

Integration in Third-Party Portals

Integration with SAP BusinessObjects

Xcelsius Enterprise Integration

Creating and Publishing Visualizations of BI Data

Using Visualizations in SAP NetWeaver BI

Using Parameters to Call Visualizations

Crystal Report Integration

Creating and Publishing Crystal Reports

Additional Development Technologies

BI Java SDK

Business Scenario

Components of the SDK

Architectural Overview

Open Standards in the SDK

The J2EE Platform and SAP NetWeaver

Common Warehouse Metamodel

Java Metadata Interface

Java Database Connectivity

Meta Object Facility

XML Metadata Interchange

BI Java Connectors

Configuring BI Java Connector

BI JDBC Connector

Interfaces of the Analytic Server

Multidimensional Interfaces

MDX as Basis for the Interfaces

Mapping Metadata

Examples for CALCULATED MEMBER

MDX Leveling

SAP Variables

BI-Specific Enhancement: Schema Rowset SAP VARIABLES

BI-Specific Enhancement: MDX Syntax

OLAP BAPI

MDDataProvider BW

MDDataProviderBW.GetCatalogs

MDDataProviderBW.GetCubes

MDDataProviderBW.GetDimensions

MDDataProviderBW.GetHierarchies

MDDataProviderBW.GetLevels

MDDataProviderBW.GetMeasures

MDDataProviderBW.GetMembers

MDDataProviderBW.GetProperties

MDDataProviderBW.GetVariables

MDDataSetBW

MDDataSetBW.CheckSyntax

MDDataSetBW.CreateObject

MDDataSetBW.DeleteObject

MDDataSetBW.FindCell

MDDataSetBW.FindTuple

MDDataSetBW.GetAxisData

MDDataSetBW.GetAxisInfo

MDDataSetBW.GetCellData

MDDataSetBW.SelectData

Parameters

Import Parameter: AllProperties

Import Parameter: LvLNumber

Import Character: MemType

Import Parameter: Restrictions

Import Parameter: SelectedProperties

Import Parameter: Treeop

Export Parameter: AggrExceptional

Export Parameter: Catalogs

Export Parameters: Cubes

Export Parameter: Dimensions

Export Parameter: Hierarchies

Export Parameter: Levels

Export Parameter: Measures

Export Parameter: Members

Export Parameter: OptionalProperties

Export Parameter: Properties

Export Parameter: Variables

Import Parameter: Cmd

Import Parameter: CmdParams

Import Parameter CommandText

Import Parameter: Members

Import Parameter: Trace

Export Parameter: AxisDimensions

Export Parameter: AxisInfo

Export Parameter: AxisLevels

Export Parameter: CellData

Export Parameter: Data

Export Parameter: DimPrptys

Export Parameter: Fltcolinfo

Export Parameter: MndtryPrptys

Export Parameter: OptionPrptysKeys

Export Parameter: OptionPrptysVals

Export Parameter: Return

Error Handling

OLE DB for OLAP

Integration and Installation

Installing Frontend Components

OLE DB for OLAP Providers

Microsoft Excel 2007

Connecting Microsoft Excel 2007 to a BI System

Other Third-Party Application Clients

XML for Analysis

Relational Interface

Data Federator