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
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 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
Implementation Scenario: 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
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 HPA Indexes
Aggregates
Selection Type "All Characteristic Values" ('*')
Selection Type "Fixed Value" (‘F’)
Selection Type "Hierarchy Level" ('H').
HPA Index
Technical Information About the HPA 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
Creating HPA Indexes
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 HPA Indexes
Rolling Up Data in HPA Indexes
Additional Editing Functions for HPA Indexes
System Response Upon Changes to Data
System Response Upon Changes to Data: Aggregate
System Response Upon Changes to Data: HPA Index
Improving Efficiency Using HPA Delta Indexes
Status Display and Check Tools
Design and Components of Aggregates
Performing Checks for Aggregates
Check Time
Check Mode
Technical Information
Design and Properties of HPA Indexes
Checking the Data in a HPA Index
Statistics for the Maintenance Processes of a HPA Index
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 and Key Figures
Technical Information
OLAP: Cache Monitor
Global Cache Parameters
Cache Data Removal and Swapping
Cache Structure
Logical File Names
Metadata Repository
BI Metadata Search
Displaying Graphics
HTML Export
Exchanging Metadata in XMI Format
Calling the Metadata Repository as an HTTP Service
Business Planning
BI Integrated Planning
Modeling Planning Scenarios
Characteristic Relationships
Data Slices
Aggregation Level
Simple Aggregation Level
Complex Aggregation Level
Filter
Variables
Planning Functions and Planning Function Types
Process of a Planning Function: Distributing by Key
Predefined Planning Function Types
Implementing Your Own Planning Function Types
Standard Key Date in Planning Functions
Planning Sequences
Input-Ready Query
Business Planning Portal Role
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
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
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 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
Including Packages in a Process Chain
Managing Bookmarks
ICF Services in BI