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
Query Monitor
Query Properties
Read Mode
Cache Mode
Accuracy
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
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 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
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
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
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
Reporting Agent
Defining Settings for Exceptions
Tab Page: Parameters
Editing a Follow-Up Action: Send Message
Editing Follow Up Actions: Alert Monitor Entry