Business Intelligence
What's New in BI with SAP NetWeaver 7.0
Business Intelligence: Overview
What Is Business Intelligence?
Integration, Storage and Management of Data
Extraction, Transformation and Loading (ETL)
Data Storage and Data Flow
Control of Processes
Information Lifecycle Management
Extraction to Downstream Systems
Metadata and Documents
Data Analysis and Planning
Online Analytical Processing
Analysis Process Design
Data Mining
Business Planning
Tools for Accessing and Visualizing Data
Query Design
Enterprise Report Design
Web Application Design
Data Analysis in BEx Web Applications
Data Analysis with Microsoft Excel
Embedded BI and Composite Applications
Publishing BI Content
Broadcasting BI Content
Integrating Content from BI into the Portal
Performance
Security
BI Content
Overview of the Architecture of SAP NetWeaver BI
Step-by-Step: From the Data Model to the BI Application in the W
Creating Key Figures
Creating Characteristics
Creating InfoCubes
Creating DataSources for Master Data of Characteristic "Product"
Creating DataSources for Transaction Data
Creating Transformations for Master Data of Characteristic "Prod
Creating Transformations for InfoCubes
Creating Master Data Directly in the System
Loading Master Data for Characteristic "Product"
Loading Transaction Data
Defining Queries
Creating Web Applications
Analyzing Data in the Web Application
Broadcasting Web Applications by E-Mail
Data Warehousing
The Data Warehouse Concept
Using a Data Warehouse
Architecture of a Data Warehouse
Enterprise Data Warehouse (EDW)
Building and Running a Data Warehouse
Enterprise Data Warehouse Layer
Architected Data Mart Layer
LSA Data Domains
InfoSources in the LSA
Data Flow in Business Warehouse
Structure of the Data Warehousing Workbench
Structure of Data Warehousing Workbench: Modeling
Modeling
Data Warehouse Management
Integration with SAP BusinessObjects
Data Warehousing: Step by Step
Analytic Engine
OLAP Engine
Planning Engine
Planning Business Data with BW Integrated Planning
Planning Modeler
Business Planning and Simulation (BW-BPS)
BW Workspace
Workspace Administration
The Assigned MultiProvider
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
Creating CompositeProviders
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
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 Targets 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 an Analytical Index
Managing Analytic Indexes
Publishing SAP HANA Models
Statistics for the Subprocesses of an Analytic Index
Creating CompositeProviders
Extended Checks
Further Functions for Editing CompositeProviders
CRM Attributes
Data Mining Models
Data Mining
BI Suite: Business Explorer
BEx Query Designer
BEx Query Designer
Working with BEx Query Designer
Functions of the Menu Bar in the Query Designer
Functions in the Query Menu
Functions in the Edit Menu
Functions in the View Menu
Functions in the Tools Menu
Functions in the Help Menu
Defining New Queries
Restricting Characteristics
Restricting Characteristics: Hierarchies
Selecting Hierarchies
Defining Selections
Defining Formulas
Percentage Functions
Data Functions
Boolean Operators
Technical Notes about the Formula Operators
Defining Exception Cells
Defining Conditions
Defining Exceptions
Saving Queries
Displaying and Changing Existing Queries in the Query Designer
Reusable Query Components
Structures
Creating Reusable Structures
Structure Element Texts and Their Language-Dependency
Filters
Variables
Variable Types
Using Text Variables
Variable Processing Types
Manual Entry/Default Value
Replacement Path
Customer Exits
Dependencies for Variables of Type Customer Exit
SAP Exit (Delivered Variables)
Authorization
Overview of Variable Types and Processing Types
Calling the Variable Editor
Defining Variables
Details
Replacement Path
Replacement Path: Replacement with a Characteristic Value
Calculating Variables for Processing Type Replacement Path
Variable Replacement Example
Replacement Path: Replacement with Query
Replacement Path: Replacement from Variable
Currencies and Units
Default Values
Defining Default Values for Variables to Allow Overwriting
Defining Restricted Key Figures
Defining Calculated Key Figures
Query Properties
Specifying Data Integrity
Properties of Query Components
Characteristic Properties
Properties of Characteristic Restrictions and Default Values
Attribute Properties
Selection/Formula/Cell Properties
Structure Properties
Filter Properties
Variable Properties
Condition Properties
Exception Properties
Row/Column Properties
Properties and How They Are Derived
Switchable Query Components in the Switch Framework
Examples
Example: Defining a Query with Key Figures
Example: Defining Filters, Free Characteristics, Columns and Row
Example: Defining Cells for Changes to Key Figures
Examples for Using Variables
Example: List of Slow-Moving Items
Managing Queries
BEx Web
Web Application Design: BEx Web Application Designer
Enterprise Reporting
Tasks for System Administration
Mass Maintenance and Mass Conversion of Web Templates and Reusab
Reorganization of Bookmarks
Displaying BI Query Runtime Statistics on the Web
Setting the Size Restriction for Result Sets
Activating the Export Library for SAP NetWeaver BI
Analysis & Reporting: BEx Web Applications
Analyzing Data in an Analysis Grid (with Navigation and Filter P
Example: Swapping Axes in the Navigation Pane Using Drag and Dro
Example: Moving a Characteristic in the Navigation Pane Using Dr
Example: Moving a Characteristic in the Rows Using Drag and Drop
Example: Dragging and Dropping Structural Components in the Colu
Example: Dragging a Characteristic to the Columns Using Drag and
Example: Dragging a Characteristic to the Rows Using Drag and Dr
Example: Dragging a Characteristic to a Data Cell Using Drag and
Example: Dragging a Characteristic to a Characteristic Value of
Example: Dragging a Characteristic Value to a Characteristic Usi
Example: Dragging a Characteristic Value to Another Characterist
Context Menu Functions
Goto
Making Currency Translations
Exporting as a CSV File/Excel File
Setting Bookmarks
Characteristic Properties
Properties of Structure Elements and Data Cells
Data Provider Properties
Axis Properties
Properties of the Web Item
Restricting Data Using Filter Values
Selecting Filter Values
Changing Filter Values
Searching for Values
Maintaining User Settings for the Input Help Dialog Box
Syntax for Directly Entering Values
Defining Formulas Ad Hoc
List of Conditions
Defining and Changing Conditions
List of Exceptions
Defining and Changing Exceptions
Web Items for Setting Filter Values and Hierarchical Filter Sele
Query View Selection with a Dropdown Box
Web Template
Using Documents in Web Applications
Creating a New Document
Display of Documents for InfoProvider Data
Displaying Documents for a Cell
Special Features of Calculated Key Figures and Formulas
Navigating in Maps
Functions in the Geo Function Bar
Displaying Exceptions in Maps and Charts
Using Variables in Web Applications
Working with the Variables Screen
Creating Query Variants
Personalizing Variables in Web Applications
Working with Bookmarks
Creating Print Versions of BI Applications
Personalizing the Start Views of Web Applications
Web Browser Dependencies
Cell Fixing
Local Cell Fixing in a Query (Front End)
Global Cell Fixing in a Planning Application (Back End)
BEx Web Analyzer
Pushbutton Functions, Navigation Pane, and Context Menu
Function Links
Standard Web Template for Ad Hoc Analysis
BI Patterns
Information Consumer Pattern
Integrating Content from BI into the Portal
BEx Mobile Intelligence
BEx Analyzer
Analysis Mode
Analysis Functions
Open
Save
Refresh / Pause Automatic Refresh
Using Variables in BEx Analyzer
Changing Variable Values
Personalizing Variables
Saving Query Variants
Local Formula
Tools
Global Settings
Context Menu for Selected Cell
Connect / System Information
Navigating in Analysis Mode
Context Menu Functions
Drag and Drop Functions
Selecting Filter Values
Characteristic Properties
Key Figure Properties
Query Properties
Drill Across Worksheets
Defining Conditions in a Workbook
Goto
Working in Formula Mode
Precalculating and Distributing Workbooks
Design Mode
Design Functions
Design Mode / Exit Design Mode
Inserting Design Items
Design Items
Analysis Grid
Navigation Pane
List of Filters
Button
Dropdown Box
Checkbox Group
Radio Button Group
List of Conditions
List of Exceptions
Text
Messages
Workbook Settings
Tab Page: General
Tab Page: Data Provider
Tab Page: Variables
Tab page: Themes
Tab Page: Design Items
Tab Page: Exits
Configuring Data Providers
Moving and Resizing Design Items
Deleting Design Items
Integration with Visual Basic for Applications
Creating Planning Applications in the BEx Analyzer
Command Wizard
Passing Variable Values
Planning Business Data Manually
Functions for Manual Planning
General Error and Message Handling
Restrictions in the BEx Analyzer
Working with Linked Documents
General Analysis Functions in BEx
Conditions
Definition of Conditions
Basics and Example Scenarios for Conditions
Ranked List Condition: Top 5 Products
Linking to Conditions: Bottom 2 Revenue and Invoiced Quantity >
Ranked List Condition with 2 Condition Rows: Top 2 Products and
Ranked List Condition for All Characteristics in Drilldown Indep
Query with Condition and Results Row Suppression
Ranked List Condition for Characteristic Combination: Top 10 Com
Threshold Condition for a Characteristic in a Cross-Classified T
Condition for All Characteristics in Drilldown Independent
Enhanced Basics and Example Scenarios for Conditions
Query with Two Structures and Threshold Value Conditions: And/Or
Query with Two Structures and Ranked-List Conditions
Query with a Presentation Hierarchy and Conditions
Query with Two Presentation Hierarchies and Conditions
Query with Hierarchically Displayed Axis and Conditions
How Conditions Interact with Hierarchies
Using Conditions
Background Information on Conditions
Exception Reporting
Defining Exceptions
Local Calculations
Calculate Results As
Calculate Single Values As
Aggregation and Calculation Time for Data
Interpretation of Results Rows
Priority Rule with Formatting Settings
Working with Hierarchies
Suppression of Zero Rows and Zero Columns
General Services in BEx
Working with BEx Objects
Working with Queries
Working with Filters
Working with Variables
Working with Structures
Working with Calculated and Restricted Key Figures
Working with Query Views
Working with Data Providers
Working with Bookmarks
Working with Reusable Web Items
Working with Workbooks
Working with Broadcast Settings
Working with Dashboards
Opening and Saving Objects in BEx
The Open Dialog Box
Search Function
The Save Dialog
Input Help in BEx
Selecting Characteristic Values
Searching for Values
Maintaining User Settings for the Input Help Dialog Box
Personalization in BEx
Runtime and Design-Time Cross-Dependencies: SAP BW 3.x and SAP N
BEx Broadcaster
Configuring Information Broadcasting
Providing and Managing Information Broadcasting
Using Information Broadcasting
Integrating Content from BI into the Portal
Integration from the Users Viewpoint
Displaying Content from BI in the Portal
Calling Content from BI in the Portal
BI Content in the Navigation Panel
Business Intelligence Portal Role
Business Planning Portal Role
Business Explorer Portal Role
Integration from the Viewpoint of Administrators and Authors
Overview: Integration and Display Types for Content from BI
Display of Content from BI in the Portal
BEx Web Application or Query as iView in the Portal
BEx Web Application or Query As Document or Link in KM
BEx Analyzer Workbook as an iView in the Portal
BEx Analyzer Workbook As Precalculated Document in KM
BI Documents in Knowledge Management
Document Structure for Metadata
Document Structure for Master Data
Document Structure for InfoProvider Data
Migration of Documents into the CM Repository
Migrations-iView
Migrating Documents
Web Interface (from BW-BPS) as iView in the Portal
BI Components in Portal
BI Content in the Navigation Panel
Calling Content from BI in the Portal
Calling with Portal Roles
Calling with KM Folders
Calling with the BEx Portfolio
Navigation with BI Content in the Portal
Eventing in the Portal
Navigation in the Portal
Determining the Path of the iView
Transferring Parameters to a BEx Web Application iView
Transfer Parameters to an SAP Transaction
Jumping Using the Report-Report Interface in the Portal
Determining the Path of the iView
Maintaining Sender-Receiver Assignment for BEx Web Application i
Maintaining Sender-Receiver Assignment for SAP Transaction iView
Creating Content from BI for the Portal
Integration Functions in the BEx Broadcaster
Publishing Queries, Web Applications and Reports
Integration Using the Portal Content Studio
Integration Using KM Content
Integration Using Role Upload
Integration of Content from BI into Other Portals
Integrating into an SAP NetWeaver 2004 Portal (SAP EP 6.0)
Creating a System in the SAP NetWeaver 2004 Portal (SAP EP 6.0)
Configuring Single Sign-On (SSO) Between SAP EP 6.0 and the SAP
Integration into an SAP NetWeaver 7.x Portal
Setting Up Access to URLs from BEx in the Federated Portal Netwo
Integration in Third-Party Portals
Integration with SAP BusinessObjects
Xcelsius Enterprise Integration
Creating and Publishing Visualizations of BI Data
Using Visualizations in SAP NetWeaver BI
Using Parameters to Call Visualizations
Integration with SAP Crystal Reports
Creating and Publishing Crystal Reports
Generic Tools and Services
Transporting BW Objects, and Creating, Delivering and Copying BI
BW Versioning Concept
Version Management
Object Dependencies and Consistency
Collecting Objects
Defining Grouping Mode
Checking Settings
Transporting BW Objects
Transport Landscape
Consistency Check for Transport Requests
Recording Time for Transports
Defining the Recording Time for Transports
Defining Object Changeability
Changing Package Assignments
Troubleshooting (Transport)
Creating and Delivering BI Content
System Landscape
Making System Settings for Content Creation
BI Content Delivery by SAP
BI Content Delivery by SAP in OLTP Systems
Creating and Delivering Customer Content
Using Namespaces for Developing BW Objects
Creating and Shipping Custom Content in the BW System
Setting Object Changeability in Customer Content Systems
Creating and Shipping Custom Content in the OLTP System
Features when Transporting Roles
Development and Delivery of Hierarchy Nodes
Comparing Different ABAP Code Versions
Creating and Delivering Partner Content
Development and Delivery of Hierarchy Nodes
Documents for Content Objects
BI Content Analyzer
Implementing Business Content for BI Content Analyzer
Content Administrator
Web Template: BI Cont Analyser_Reporting
Reporting Enhancement
Reporting Enhancement_Graph
Important Settings
Setting Global Settings
Determining Check Execution
Setting Priorities
Setting Exceptions
Including Source-System Dependent Objects
Releasing Packages
Scheduling Check Programs
BI Content Analyzer Checks
Copying BI Content to the Active Version
Troubleshooting (BI Content Activation)
Transportable Object Types
SOBJ: Definition of Transportable Object Types
Special Features of Individual Object Types
Transporting BEx Objects
Transporting Planning Objects
Transporting Roles
Transporting Hierarchy InfoPackages
Importing Client-Dependent Objects
Special Features of Source System-Dependent Objects
Enhancements to the BW Versioning Concept
Classification of Source System-Dependent Objects
Making the Source System Anonymous
Creating and Transporting Source System-Specific Data Flows
Defining the Target Source System
DataSource
InfoPackage
Transformation
Data Transfer Process
Process Chains and Process Variants
Source System-Dependent 3.x Objects
BW Statistics
BEx Query Runtime Statistics
Analysis of Statistics Data
Maintenance of Statistics Properties
Analyzing Statistics Data for a MultiProvider Query
Overview of Statistics Events (Table RSDDSTATEVENTS)
Aggregation of Query Runtime Statistics
Migration Details
Technical Content in BW Administration Cockpit
Web Templates
Web Template: Runtimes of BI Applications
Web Template: Deviations in Runtimes of BI Applications
Web Template: Short-Term Trends in Total Runtimes of BI Applicat
Web Template: Long-Term Trends in Total Runtimes of BI Applicati
Web Template: Runtimes of BI Application Objects
Web Template: Deviations in Runtimes of BI Application Objects
Web Template: Short-Term Trends in Total Runtimes of BI Applicat
Web Template: Long-Term Trends in TotalRuntimes of BI Applicatio
Web Template: Runtimes of InfoProviders
Web Template: Deviations in Runtimes of InfoProviders
Web Template: Short-Term Trends in Total Runtimes of InfoProvide
Web Template: Long-Term Trends in Total Runtimes of InfoProvider
WebTemplate: Aggregated Query RuntimeStatistics: Analysis
Web Template: BI Application Runtimes Overview
Web Template: BI Application Object Runtimes Overview
Web Template: Detailed Query RuntimeStatistics: Analysis
Web Template: Data Manager Statistics: Analysis
Web Template: Deviations in Total Runtimes of DTPs
Web Template: Deviations in Total Runtimes of InfoPackages
Web Template: Deviations in Total Runtimes of Processes
Web Template: Deviations in Total Runtimes of Process Chains
Web Template: Aggregate Rollup
Web Template: DataStore Object Activation
Web Template: Total Runtimes of DTPs
Web Template: Total Runtimes of InfoPackages
Web Template: Total Runtimes of Processes
Web Template: Total Runtimes of Process Chains
Web Template: InfoCube Correctness
Web Template: InfoCube Status
Web Template: InfoCube Status: Analysis
Web Template: DataStore Object Correctness
Web Template: Short-Term Trends in Total Runtimes of DTPs
Web Template: Short-Term Trends in Total Runtimes of InfoPackage
Web Template: Short-Term Trends in Total Runtimes of Processes
Web Template: Short-Term Trends in Total Runtimes of Process Cha
Web Template: Long-Term Trends in Total Runtimes of DTPs
Web Template: Long-Term Trends in Total Runtimes of InfoPackages
Web Template: Long-Term Trends in Total Runtimes of Process Chai
Web Template: Long-Term Trends in Total Runtimes of Processes
Web Template: Process Status
Web Template: Process Status: Analysis
Web Template: Master Data Status: Analysis
Web Template: Master Data Status
Web Template: DataStore Object Status
Web Template: DataStore Object Status:Analysis
Web Template: Process Chain Status
Web Template: No. of Executions per BI Application
Web Template: No. of BI Application Object Executions per User
Web Template: No. of BI Application Executions per User
Web Template: No. of Executions per BI Application Object
Web Template: Long-Term Trends in Total Runtimes of InfoProvider
Web Template: Short-Term Trends in Total Runtimes of InfoProvide
Web Template: Deviations in Runtimes of InfoProviders
Web Template: Runtimes of InfoProviders
Web Template: Long-Term Trends in Total Runtimes of BI Applicati
Web Template: Short-Term Trends in Total Runtimes of BI Applicat
Web Template: Deviations in Runtimes of BI Application Objects
Web Template: Runtimes of BI Application Objects
Web Template: Long-Term Trends in Total Runtimes of BI Applicati
Web Template: Short-Term Trends in Total Runtimes of BI Applicat
Web Template: Deviations in Runtimes of BI Applications
Web Template: Runtimes of BI Applications
Web Template: BI Data Distribution by Table Types
Web Template: BI Data Distribution by Object Types
Web Template: Top N BI Tables
Web Template: BI Data Distribution by Application Component
Web Template: BI Data Distribution by InfoArea
Queries
Runtimes of BI Applications
Deviations in Runtimes of BI Applications
Short-Term Trends in Total Runtimes ofBI Applications
Long-Term Trends in Total Runtimes ofBI Applications
Runtimes of BI Application Objects
Deviations in Runtimes of BI ApplicationObjects
Short-Term Trends in Total Runtimes ofBI Application Objects
Long-Term Trends in Total Runtimes ofBI Application Objects
Runtimes of InfoProviders
Deviations in Runtimes of InfoProviders
Short-Term Trends in Total Runtimes ofInfoProviders
Long-Term Trends in Total Runtimes ofInfoProviders
Aggregated Query Runtime Statistics:Analysis
BI Application Runtimes Overview
BI Application Object Runtimes Overview
Pre-Query: Short-Term Max. in Total Runtimesof BI Applications
Pre-Query: Long-Term Max. in Total Runtimesof BI Applications
Pre-Query: Short-Term Max. in Total Runtimesof BI Application Ob
Pre-Query: Long-Term Max. in Total Runtimesof BI Application Obj
Pre-Query: Short-Term Max. in Total Runtimesof InfoProviders
Pre-Query: Long-Term Max. in Total Runtimesof InfoProviders
Detailed Query Runtime Statistics: Analysis
Data Manager Statistics: Analysis
Deviations in Total Runtimes of DTPs
Deviations in Total Runtimes of InfoPackages
Deviations in Total Runtimes of Processes
Deviations in Total Runtimes of ProcessChains
Aggregate Rollup
DataStore Object Activation
Total Runtimes of DTPs
Total Runtimes of InfoPackages
Total Runtimes of Processes
Total Runtimes of Process Chains
InfoCube Correctness
InfoCube Status
InfoCube Status: Analysis
DataStore Object Correctness
Short-Term Trends in Total Runtimes ofDTPs
Short-Term Trends in TotalRuntimes of InfoPackages
Short-Term Trends in Total Runtimes ofProcesses
Short-Term Trends in Total Runtimes ofProcess Chains
Long-Term Trends in Total Runtimes ofDTPs
Long-Term Trends in Total Runtimes ofInfoPackages
Long-Term Trends in Total Runtimes ofProcesses
Long-Term trends in Total Runtimes ofProcess Chain
Pre-Query: Short-Term Maximum in TotalRuntimes of InfoPackages
Pre-Query: Short-Term Maximum in TotalRuntimes of DTPs
Pre-Query: Short-Term Maximum in TotalRuntimes of Processes
Pre-Query: Short-Term Max in Total Runtimesof Process Chains
Pre-Query: Long-Term Maximum in TotalRuntimes of Process Chains
Pre-Query: Long-Term Maximum in TotalRuntimes of Processes
Pre-Query: Long-Term Max. in Total Runtimesof DTPs
Pre-Query: Long-Term Maximum in TotalRuntimes of InfoPackages
Process Status
Process Status: Analysis
Master Data Status: Analysis
Master Data Status
DataStore Object Status
DataStore Object Status: Analysis
Process Chain Status
BI Data Distribution by Table Types
BI Data Distribution by Object Types
Top N System Tables
BI Data Distribution by Application Component
BI Data Distribution by InfoArea
MultiProvider
Front End and OLAP Statistics (Aggregated)
Front End and OLAP Statistics (Details)
Front-End and OLAP Statistics (Highly Aggregated)
Data Manager Statistics (Details)
DTP Statistics
InfoPackage Statistics
Process Statistics
Process Status
BI Object Request Status
Variables
Variable: BI Application Object Type
Variable: BI System
Variable: BI Application Type
Variable: InfoProvider Type
Variable: Last 24 Hours
Variable: Last 48 Hours
Variable: Top 5 DTPs for Short Term (Pre-Query)
Variable: Top 5 InfoPackages for ShortTerm (Pre-Query)
Variable: Top 5 Process Chains for ShortTerm (Pre-Query)
Variable: BI Application for Short Term(Pre-Query)
Variable: BI Application Objects forShort Term (Pre-Query)
Variable: InfoProviders for Short Term(Pre-Query)
Variable: Top 5 Process Variants for Short Term (Pre-Query)
Variable: Top 5 Process Variants for Long Term (Pre-Query)
Variable: BI Application Objects forLong Term (Pre-Query)
Variable: Top 5 Process Chains for LongTerm (Pre-Query)
Variable: Top 5 InfoPackages for LongTerm (Pre-Query)
Variable: InfoProviders for Long Term(Pre-Query)
Variable: Top 5 DTPs for Long Term (Pre-Query)
Variable: BI Application for Long Term(Pre-Query)
Variable: Process Type
InfoCubes
Front-End and OLAP Statistics (Aggregated)
Front-End and OLAP Statistics (Details)
Data Manager Statistics (Details)
DTP Statistics
DTP Statistics
InfoPackage Statistics
Data Manager Statistics (Details)
Front End and OLAP Statistics (Details)
Front End and OLAP Statistics (Aggregated)
InfoPackage Statistics
Process Statistics
Process Statistics
Process Status
BI Object Request Status
Front-End and OLAP Statistics (Highly Aggregated)
Front-End and OLAP Statistics (Highly Aggregated)
Front-End and OLAP Statistics (Highly Aggregated)
InfoSources
DTP Statistics
InfoPackage Statistics
Process Chain Statistics
Process Status
BI Object Request Status
Data Manager Statistics (Details)
Front-End and OLAP Statistics (Details)
Front-End and OLAP Statistics (Aggregated)
Key Figures
Average Data Manager Time per BI Application Object
Average Duration
Average Front-End Time per BI Application
Average OLAP Time per BI Application
Average OLAP Time per BI Application Object
Average Unassigned Time per BI Application
Average Planning Time per BI Application
Average Total Time per BI Application
Average Total Time per BI Application Object
Average Total Time per BI Application in the Last 24 Hours
Average Total Time per BI Application in the Last 30 Days
Average Total Time per BI Application Object in the Last 24 Hour
Average Total Time per BI Application Object in the Last 30 Days
Average Data Manager Time per BI Application
Counter for BI Applications
Counter for Queries
Database Records Selected
Deviation in Average Total Time per BI Application
Deviation in Average Total Time per BI Application Object
DM Statistics: DM Initialization
DM Statistics: DM Hierarchy
DM Statistics: DM Nav. Attrs.
DM Statistics: DM Postprocessing
Data Manager Statistics: SID Processing
DM Statistics: Read DM Data
Total Data Manager Time
Duration
End Date
End Time
End Time Stamp
Number of Errors
Number of Erroneous Records
Number of Erroneous Requests
Number of Not Activated Records
Number of Not Activated Requests
Number of Not Aggregated Records
Number of Not Aggregated Requests
Number of Not Compressed Records
Number of Not Compressed Requests
Number of Not Yet Started Runs
Number of Ongoing Runs
Number of Qualitatively Incorrect Records
Number of Qualitatively Incorrect Requests
Number of Records
Characteristics
BI Object
BI Object Type
BI Sub Object Type
DTP Command
DTP Sub-Step
DataStore Object
Data Package ID
Data Transfer Process
Processing Mode
InfoPackage
InfoProvider
InfoProvider Type
Last Aggregated Request
Last Loaded Request
Last Compressed Request
Last Qualitatively Correct Request
Last Technically Correct Request
Open Hub Destination
Process Chain Log ID
Process Instance (GUID)
Process Instance (SID)
Process Status
Process Chain ID
Process Type
Process Variant
Source Object
Source Object Type
Transformation Services
Web Item
Web Template
Importance
Time Stamp of Last Change of Flag QualitativelyCorrect
Time Stamp of Last Change of Flag TechnicallyCorrect
Time Stamp of Last Aggregation
Time Stamp of Last Compression
Time Stamp of Last Change
Time Stamp of Last Loading
Time Stamp of Last Activation
Time Stamp of Last Change of Status (Errors)
Target Object Type
Target Object
BI Object Type
BI Sub Object Type
Step Counter During Query Execution
Data Package ID
DataStore Object
Data Transfer Process
DTP Command
DTP Sub-Step
Front-End Session
Importance
InfoPackage
InfoProvider
InfoProvider Type
InfoProvider Type
Last Aggregated Request
Last Loaded Request
Last Compressed Request
Last Qualitatively Correct Request
Last Technically Correct Request
Open Hub Destination
Process Chain Log ID
Process Instance (GUID)
Process Instance (SID)
PartProvider Used During Monitored Step
Processing Mode
Process Status
Process Chain ID
Process Type
Process Variant
Query (Navigation) Step
Query Runtime Object
Source Object
Source Object Type
OLAP Statistics: Event
OLAP Statistics: Step Type
Process Chains
Content Master Data
Data Load Statistics # Delta
Data Load Statistics # Init
Query Runtime Statistics # Delta
Query Runtime Statistics # Init
System Master Data
DataSources
DTP Statistics
InfoPackage Statistics
Process Chain Status
Process Chain Statistics
BI Object Request Status
Data Manager: Detailed Data
OLAP: Aggregated Data
OLAP: Detailed Data
Data Manager: Detailed Data
OLAP: Highly Aggregated Data
BW Administration Cockpit
Displaying the Data Load Status
Monitoring Processes
Monitoring the Status of BI Object Requests
Monitoring the Status of InfoProvider Requests
Analyzing the Data Load Status
Displaying Query Runtime Statistics
Monitoring Query Runtime Statistics
Analyzing Query Runtime Statistics
Displaying Data Load Statistics
Monitoring Data Load Statistics
Analyzing Data Load Statistics
Displaying BI Usage Statistics
Monitoring BI Application and BI Application Object Usage Statis
Analyzing BI Usage Statistics
Monitoring Database Usage Statistics
Technical Content
BW Technical Content FC1
SAP Exit Variable
Variable: Current Calendar Month
Variable: Current Calendar Week
Variable: Current Calendar Year
Variable: Current Quarter
Variable: Current Calendar Day
Variable: Current Workday
Variable: Current Fiscal Year
Variable: Current Fiscal Year / Period
Variable: Cumulated up to Current Fiscal Year Period
Variable: Cumulated up to Last Fiscal Year Period
Variable: Cumulated up to Current Month
Variable: Cumulated up to Last Month
Variable: Cumulated up to Current Day
Variable: Previous Year Cumulated up to Current Day
Determining the Fiscal Year Variant at Query Runtime
Test and Trace Tools
Query Monitor
Query Properties
Read Mode
Cache Mode
Activating Delta Caching
Specifying the InfoProvider Grouping for Delta Caching
Calculating with High Accuracy
Not Using Parallel Processing
Processing Queries
Using the Cache Despite Virtual Characteristics and Key Figures
Operations in BWA
Query as InfoProvider
Technical Information
Analysis and Repair Environment
Trace Tool Environment
Trace Tool
Log User Actions
Determine a Logged Trace
Reexecution of Logged User Actions
Maintenance of Trace Properties
CAT Tool
Administration
OLAP Trace Tool (Old)
Creating an OLAP Trace
SAP DemoContent for Features
BW Metadata Search
Using SAP NetWeaver Enterprise Search for the BW Metadata Search
Documents
Document Classes
Hyperlinks to Documents
BAdIs for Use in Documents
BW Security Manager for Documents
Administration of BW Metadata Search and BW Documents
Retrieval: Search Server Relation Monitor
Tab page: Metadata Indexing
Tab Page: Generated Document Properties
Characteristic Is Document Property
Tab Page: Document Content Repository
Tab Page: Indexing Documents
Setting Up Document Indexing
Valid File Types
Editing Valid File Types
Web Services und ICF Services in BW
Functions for SAP BW 3.5 (SAP NetWeaver 2004)
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 Value Set Settings
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
Bookmark Administration
Additional Development Technologies
BI Java SDK
Business Scenario
Components of the SDK
Architectural Overview
Open Standards in the SDK
The J2EE Platform and SAP NetWeaver
Common Warehouse Metamodel
Java Metadata Interface
Java Database Connectivity
Meta Object Facility
XML Metadata Interchange
BI Java Connector
Configuring BI Java Connector
BI JDBC Connector
Interfaces in the Analytic Server
Open Analysis Interfaces
Standard Interfaces
MDX as Basis for the Interfaces
Mapping Metadata
Examples for CALCULATED MEMBER
MDX Leveling
SAP Variables
BW Specific Enhancement: Schema Rowset SAP VARIABLES
BW-Specific Enhancement: MDX Syntax
OLAP BAPI
MDDataProvider BW
MDDataProviderBW.GetCatalogs
MDDataProviderBW.GetCubes
MDDataProviderBW.GetDimensions
MDDataProviderBW.GetHierarchies
MDDataProviderBW.GetLevels
MDDataProviderBW.GetMeasures
MDDataProviderBW.GetMembers
MDDataProviderBW.GetProperties
MDDataProviderBW.GetVariables
MDDataSetBW
MDDataSetBW.CheckSyntax
MDDataSetBW.CreateObject
MDDataSetBW.DeleteObject
MDDataSetBW.FindCell
MDDataSetBW.FindTuple
MDDataSetBW.GetAxisData
MDDataSetBW.GetAxisInfo
MDDataSetBW.GetCellData
MDDataSetBW.SelectData
Parameters
Import Parameter: AllProperties
Import Parameter: LvLNumber
Import Character: MemType
Import Parameter: Restrictions
Import Parameter: SelectedProperties
Import Parameter: Treeop
Export Parameter: AggrExceptional
Export Parameter: Catalogs
Export Parameters: Cubes
Export Parameter: Dimensions
Export Parameter: Hierarchies
Export Parameter: Levels
Export Parameter: Measures
Export Parameter: Members
Export Parameter: OptionalProperties
Export Parameter: Properties
Export Parameter: Variables
Import Parameter: Cmd
Import Parameter: CmdParams
Import Parameter CommandText
Import Parameter: Members
Import Parameter: Trace
Export Parameter: AxisDimensions
Export Parameter: AxisInfo
Export Parameter: AxisLevels
Export Parameter: CellData
Export Parameter: Data
Export Parameter: DimPrptys
Export Parameter: Fltcolinfo
Export Parameter: MndtryPrptys
Export Parameter: OptionPrptysKeys
Export Parameter: OptionPrptysVals
Export Parameter: Return
Error Handling
OLE DB for OLAP
Integration and Installation
Installing Frontend Components
OLE DB for OLAP Providers
Microsoft Excel 2007
Connecting Microsoft Excel 2007 to a BW System
Using OLE DB for OLAP Providers
XML for Analysis
MDX Test Environment
Executing an MDX Statement
Web Service Interface
Managing Easy Queries
Easy Query API
Example: Easy Query API
Relational Interface
Data Federator
Using Queries as InfoProviders
Integration with SAP BusinessObjects