BW305 SAP Business Warehouse Query Design and Analysis

Describing Data Warehousing
Describing Data Warehouse Architecture
Using Reporting Tools

Using the Navigation Options in Reports
Saving Analysis Views

Creating Simple Queries
Finding a Query
Filtering Query Definition Data
Configuring Query Properties

Creating Restricted Key Figures
Creating Calculated Key Figures
Creating a New Formula with Boolean Operators
Configuring Properties of Key Figures
Using Exception and Nested Exception Aggregation

Creating Structures
Resolving Formula Collision
Designing Detailed Queries with the Cell Editor

Configuring the Properties of Characteristics
Running Display and Navigation Attribute Queries
Adding Hierarchies to Reports
Adding External Hierarchies to a Report
Using Hierarchies and Structures
Creating External Hierarchies

Using Variables
Creating Characteristic Value and Text Variables in Queries
Creating Hierarchy and Hierarchy Node Variables in Queries
Creating Formula Variables in Queries
Activating Business Content Variables

Creating Exceptions in Query Design
Creating Conditions in Query Design

Using the Report-Report Interface

Optimizing Query Performance
Configuring Query Read Mode
Use Performance Monitoring Tools

Managing Query Objects
Describing Authorizations

Outlining Reporting Options for SAP NetWeaver BW