Analytic Manager
Online Analytic Processor
Special OLAP Functions and Services
Aggregation
Multi-Dimensional Exception Aggregation
Rules for Standard Aggregation and Exception Aggregation
Aggregation Steps
Currency Aggregation
Aggregation and Special Values
Hierarchy Exception Aggregation NGA and NHA
Formula Calculation
Basic Functions
Percentage Functions
Data Functions
FIX Operator
FIX Operator and Various Aggregations
FIX Operators and Various Constant Selections and Aggregations
FIX Operator and Restricted Key Figures
FIX Operator and Restricted Constants
Mathematical Functions
Trigonometric functions
Boolean Operators
Formula Calculation and Special Values
Examples in the Data Warehousing Workbench
Exception Aggregation Last Value (LAS) and Average (AV0)
Exception Aggregation Average (AV1)
Examples in the BEx Query Designer
Counting Exception Aggregations
Extended Counting of Exception Aggregations
Operations on the Result Set
Suppression of Zero Rows and Columns
Hiding Nodes with Just One Child
Local Calculations
Conditional Totals Suppression (in the Result Row)
Example: Combination of Various Operations
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
Uploading Hierarchies from Flat Files
Making DataSource Settings for Loading Hierarchy Files
Structure of a Flat Hierarchy File for Loading Using a PSA
Structure of a Flat Hierarchy File for Loading via IDoc
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
Stock Coverage
Creating the Key Figure for Stock Coverage
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 Systems
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 Systems
Quantity Conversion During 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 InfoObject
Conversion with Fixed Target Unit of Measure and Dynamic Determination Without Options
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 InfoObject
Conversion with Fixed Target Unit of Measure and Dynamic Determination Without Options
Constant Selection
Creating a Constant Selection on a Single Characteristic (CSC)
Constant Selection on a Characteristic (CSC)
Example: Constant Selection on a Compound Characteristic
Creating Constant Selection on a Structure Element (CSE)
Cells with Constant Selection on the Element (CSE) and Constant Selection on the Characteristic (CSC)
Object Generation
Constant Selection and Formula Aggregation
Constant Selection and Non-Cumulative Values
Constant Selection in Examples
Example 1: Query with Two Structures and a Combination of CSE and CSC
Example 2: Query with Two Structures and Empty Cell for CSC
Example 3: Query with CSC
Example 4: Non-Effective Constant Selection
Using Constant Selection for a Market Index
Using Constant Selection for MultiProviders
CURRENT MEMBER Variables
Example Query for Using a CURRENT MEMBER Variable
Examples of Using the CMR Operator
Displaying Unposted Values in the Query Result
Navigation Attributes in the Drilldown
Navigation Attributes in the Drilldown and Universal Display Hierarchy
Compound Characteristics in the Drilldown
Comparable Time Characteristics in the Drilldown
Non-Comparable Time Characteristics in the Drilldown
Unposted Values for Fiscal Year Periods
Unposted Values and Formula Variables
Editing Short Texts in Queries
Example: Classification in a Query
Example: Entering Comments in a Query
Using Precalculated Value Sets (Buckets)
Standard Queries
Analysis Authorizations
Using the Report-Report Interface
Process when Calling the RRI
Changing and Creating Sender/Receiver Assignments
Receivers
BEx Query as Recipient
Example of a BEx Query as a Receiver
Creating a Transaction as a Receiver
Creating a Web Address As a Receiver
Examples of Web Addresses as Receivers
iView as Receiver
Creating Your Own Report Type As a Receiver
Maintaining Assignment Details
Performance Optimization
Using the SAP HANA Database
Indexing BW Data in the SAP HANA Database
Tab: SAP HANA/BWA Index Settings
Statistics for Maintenance Processes in SAP HANA Indexes
Tracing in the SAP HANA Database
Creating and Managing BWA Indexes in the BW System
SAP BW Accelerator Index
Technical Information About the SAP BW Accelerator Engine
Indexing BW Data in SAP BW Accelerator
Tab: BWA Index Settings
Tab: Indexing Performance
Tab: Memory Management
Indexing BW Data for SAP BusinessObjects Explorer
Activating BW Objects for SAP BusinessObjects Explorer
Activation and Provision of Data
Activating and Filling SAP BW Accelerator Indexes
Rolling Up Data to a SAP BW Accelerator Index
System Response to Data Modifications
System Response to Data Modifications: SAP BW Accelerator Index
Improving Efficiency Using BWA Delta Indexes
Monitoring SAP BW Accelerator
Monitoring BWA Indexes
Maintaining Global BWA Index Settings
Tab: Indexing Performance
Tab: Indexing Process
Tab: System Settings
Tab: Memory Settings
Tab: Check Settings
Tab Page: Workspace Settings
Displaying a SAP BW Accelerator Index
Analyzing and Repairing BWA Indexes
Tests for BWA Indexes in Transaction RSRV
Checking Data Consistency in SAP BW Accelerator
Checking the Consistency of BWA Indexes (Check Center)
Statistics for Maintenance Processes in SAP BW Accelerator Indexes
Tracing SAP BW 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 BW Statistics
Optimizing Proposed Aggregates
Activation and Provision of Data
Activating and Filling Aggregates
Rolling Up Data into Aggregates
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
Configuring the Validity Area
Determining the Effective Time Filter
Validity and Aggregation
Examples: Aggregations and Validity
Examples: Validities and Constant Selection
Transferring Non-Cumulative Data into the BW 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
OLAP Cache Monitor
Cache Parameters
Cache Structure
Planning Processor
Planning Business Data with BW Integrated Planning
Planning Modeler
BW Workspace
Workspace Administration
The Assigned Main Provider
Activating Data Backups for Local Providers
Settings for Excel Files
Tips for Editing Workspaces
Managing the Folder Structure
Enhancement Spot for BW Workspaces
BW Workspace Designer
My Workspace
Graphical View
Copying and Managing key Figures
Creating CompositeProviders in BW Workspace Designer
Generating a Link Proposal
External and Internal Display of Characteristic Values
Union / Inner Join / Left Outer Join
Creating Local Providers
Creating Local Providers: File as Source
Data Analysis for CSV Files
Creating Local Providers: BEx Query as Source
Creating Local Providers: DataSource as Source
Creating a Local Characteristic
Editing Master Data
Changes to the Central InfoObject
Using Local Providers for BW Integrated Planning
Analysis Process Designer
Structure of the Analysis Process Designer
Modeling an Analysis Process
Creating an Analysis Process
Checking Data
Formulas for Calculating Statistics
Additional Functions in the APD
Data Sources for an Analysis Process
Attributes of a Characteristic
InfoProvider
Query
File
Database Table
Analysis Authorizations
Transformations for an Analysis Process
Limiting Data Volume
Aggregating Data
Joining Data from Multiple Sources
Unifying Data from Two Data Sources (Union)
Hiding Columns
Sorting Data
Formula
Transforming Lists into Data Records
Transforming Data Records into Lists
ABAP Routine
Data Mining Methods
Data Targets for an Analysis Process
Attributes of a Characteristic
DataStore Object
File
Analytic Index
Creating Analytic Indexes in Analysis Process Designer
Managing Analytic Indexes
Statistics for the Subprocesses of an Analytic Index
Creating CompositeProviders that Consist of Analytic Indexes
Extended Checks
Further Functions for Editing CompositeProviders
CRM Attributes
Data Targets for SAP CRM
Data Mining Models
Data Mining