BI Platform
Metadata Repository
BI Metadata Search
Displaying Graphics
HTML Export
Exchanging Metadata in XMI Format
Calling the Metadata Repository as an HTTP Service
OLAP
Special OLAP Functions and Services
Aggregation
Examples of Exception Aggregation Last Value (LAS) and Average (
Examples of Exception Aggregation Average (AV1)
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 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
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 the 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
Selecting Constants
Example: List of Slow-Moving Items
Analysis Authorizations
Report-Report Interface
Editing Sender-Receiver Assignments to the RRI in the BI System
Receivers
Maintaining Assignment Details
Creating a Transaction as a Receiver
Creating a Web Address As a Receiver
Examples for Jumping to Web Pages
BEx Query as Recipient
Example of a BEx Query as a Receiver
Web Applications As Sender
iView As Receiver
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 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
Aggregates and BI Accelerator
Aggregates
Selection Type "All Characteristic Values" ('*')
Selection Type "Fixed Value" (‘F’)
Selection Type "Hierarchy Level" ('H').
BI Accelerator Index
Using the BIA Index Maintenance Wizard
Technical Information About the BI Accelerator Engine
Create and Change
Creating the First Aggregate for an InfoCube
Editing Aggregates Manually
Automatically Selecting and Optimizing Aggregates
Proposals from Queries
Proposals from BI Statistics
Optimizing Proposed Aggregates
Activation and Provision of Data
Activating and Filling Aggregates
Rolling Up Data in Aggregates
Loading Data into Aggregates Efficiently
Further Editing Functions for Aggregates
Activating and Filling BI Accelerator Indexes
Rolling Up Data in BI Accelerator Indexes
System Response Upon Changes to Data
System Response Upon Changes to Data: Aggregate
System Response Upon Changes to Data: BI Accelerator Index
Improving Efficiency Using BI Accelerator Delta Indexes
Status Display and Check Tools
Design and Components of Aggregates
Performing Checks for Aggregates
Check Time
Check Mode
Technical Information
Using the BI Accelerator Monitor
Global Parameters for Indexing
BI Accelerator Index Design
Checking BI Accelerator Indexes (Transaction RSRV)
Statistics for Maintenance Processes of a BI Accelerator Index
Traces for the BI Accelerator
BEx Monitor
Trace Tool Environment
Trace Tool
Log User Actions
Determine a Logged Trace
Execute Logged User Actions Again
Maintenance of Trace Properties
CAT Tool
Administration
OLAP Trace Tool (Old)
Setting an OLAP Trace
Query Monitor
Query Properties
Read Mode
Cache Mode
Accuracy
Not Using Parallel Processing
Processing Queries
Using the Cache Despite Virtual Characteristics and Key Figures
Technical Information
OLAP: Cache Monitor
Global Cache Parameters
Cache Data Removal and Swapping
Cache Structure
Logical File Names
BI Query Runtime Statistics
Analysis of Statistics Data
Maintenance of Statistics Properties
Business Planning
BI Integrated Planning
Modeling Planning Scenarios
InfoProvider
Characteristic Relationships
Data Slices
Aggregation Level
Simple Aggregation Level
Complex Aggregation Level
Filter
Planning Functions
Process Flow of Planning Function: Distributing by Key
Standard Planning Function Types
Forecasting
Forecast Strategies
Automatic Model Selection
Outlier Correction
Trend Dampening
Logging Statistical Key Figures
Ignoring Initial Zeros
Standard Key Date in Planning Functions
Planning Sequences
Variables
Changing Variable Values in the Planning Modeler
Input-Ready Query
Implementing Planning Function Types
Creation of Planning Applications
Creating Planning Applications in the BEx Analyzer
Creating Planning Applications in the BEx Web Application Design
Performing Manual Planning
Manual Planning Functions
Business Planning Portal Role
Transport of Planning Objects
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
Documents
Creating a Document
Editing a Document
Planning Functions
Undoing Data Changes
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
Model Initialization
Forecast Models
Forecast Parameters
Forecast Formulas
Forecast Exit
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
Integration of BEx Web Applications
Creating IFRAMEs for BEx Web Applications
Filter Values from BW-BPS Variables
Filter Values from Row Selection in Planning Layouts
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
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
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
Data Sources for an Analysis Process
Attributes of a Characteristic
InfoProviders
Query
File
Database Table
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
DataStore 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
Data Mining
Decision Trees
Scoring
Regression Analysis
Special Settings for Regression Analysis
Weighted Score Tables
Special Settings for Weighted Score Tables
Settings for All Function Types
ABC Classification
Model Settings
Classification Rules
Clustering
Association Analysis
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