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