BI Suite: Business Explorer
Query Design: BEx Query Designer
Functions of the BEx Query Designer
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
Save Queries
Using Variables: The Variable Wizard and the Variable Editor
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
Defining Variables with the Variable Wizard
Details
Special Features with Dynamically Changeable Variables
Default Values
Replacement Path
Replacement Path: Replacement with a Characteristic Value
Calculating Variables for Processing Type “Replacement Path”
Variable Replacement Example
Replacement Path: Replacement with Query
Characteristic
Currencies and Units
Changing Variables in the Variable Editor
Examples for Using Variables
Query Properties
Properties of Query Components
Characteristic Properties
Attribute Properties
Structure Properties
Selection/Formula Properties
Restricted Key Figure Properties
Calculated Key Figure Properties
Defining Conditions
Defining Exceptions
Conditions/Exceptions: Inserting, Changing, Deleting Rows
Tabular Query Display
Defining Calculated Key Figures
Defining Restricted Key Figures
Structures
Creating Reusable Structures
Structure Element Texts and Their Language-Dependency
Displaying and Changing Existing Queries in the Query Designer
Functions on the BW Server
Copying Queries Between InfoCubes
Deleting Query Objects
BEx Web
Web Application Design: BEx Web Application Designer
BEx Web Application Designer
Functions of the Web Application Designer Menu Bar
The Web Items Window
The Template Window
The Properties Window
From Web Template to Web Application
Creating Web Applications with the BEx Web Application Designer
Further Editing Web Templates
Enhanced Editing in Text Mode
Mass Maintenance and Conversion of Web Templates
Creating Web Applications with the Web Application Wizard
Determining Settings
Storage of Stylesheets and Symbols
Web Template Properties
Designing the Layout of Web Templates
Context Menu in Web Templates
Merging Cells in an HTML Table
Working with the Library for Web Items
Web items
General Attributes
Table
Chart
Automatic Axis Labeling for Simple Charts
Dropdown Box
Radio Button Groups
Checkboxes
Generic Navigation Block
Hierarchical Filter Selection
Filters
Label
Text Elements
List of Exceptions
List of Conditions
Alert Monitor
Role Menu
Ticker
Maps
Map Attributes
Attributes for Map Layers
Special Attributes for Color Shading
Special Attributes for Bar Charts
Special Attributes for Pie Charts
Special Attributes for Pie Charts (split)
Special Attributes for Dot Density
Special Attributes for Symbols
Special Attributes for Symbol (Size-dependent)
Special Attributes for Symbol (Color-dependent)
Special Attribute: Line
Special Attribute: Line (Size-dependent)
Special Attributes for Lines (Color-dependent)
Array Attributes
Map Renderer
Additional Cartographical Information
Displaying Additional Cartographical Information
Single Document
List of Documents
Object Catalog of the Web Application
Data Provider – Information
Web Template
Broadcaster
Query View – Selection
Key Figure Overview
Ad-hoc Query Designer
ABC Classification
What If Prediction
Web Template Properties
Editing Charts
Working with the Chart Designer
Chart Types
Class 1 Chart Types
Class 2 Chart Types
Class 3 Chart Types
Formatting a Chart with the Wizard
Defining Chart Properties
Changing the Chart Type
Changing the Size and Position of Chart Elements
Assigning Colors
Formatting Areas
Using Textures
Formatting Lines
Formatting Axes and Gridlines
Formatting Texts
Formatting Data Series and Data Points
Reversing the Order of Data
Plotting Data Series on a Secondary Axis
Adding Data Labels
Adding, Changing, and Removing Trend Lines
Rotating Charts
Formatting 3D Effects
BW Stylesheets
Print Stylesheet
Web Templates
Overriding Attributes
Object Tags
Object Tag for the Properties of Web Templates
Adjusting and Enhancing the Context Menu
Adjusting the Context Menu
Enhancing the Context Menu
Object Tag for Data Provider
Object Tag for Web Items
Command URLs
Changing Web Item Attributes
Resetting and Reinitializing Web Items
Commands for Web Templates
Calling up Web Templates
Calling Parameterized Web Templates
Default Variables for Web Applications
Switching Web Templates
Personalizing Web Templates
Creating Bookmarks
Changing Symbol Directory
Releasing Web Templates
Ending the Session
Variables
Calling up the Variables Screen
Changing the Values of Variables
Calling the Broadcaster
Calling the Open Dialog
Data Provider - Commands
General Data Provider Commands
Properties of Data Providers
Resetting and Reinitializing Data Providers
Back and Back to Start
Jumping Using Report-Report Interface
Exporting Data
Saving the Query View
Displaying a Copy of the Data Provider on a New Page
Calling the Ad-hoc Query Designer
Filter
Removing Filters
Drilldown
Remove Drilldown
Switching Characteristics/Structures
Swap Axes
Setting the Navigational Status
Sorting
Setting Properties of Display Attributes
Results Row Position
Suppressing Result Rows
Setting the Display
Displaying Documents
Dialogs
Calling Dialog Query Properties
Calling Up Dialog Box for Formula Definition
Calling up Input Help
Calling the Characteristic Properties Dialog
Calling a Dialog for Currency Translation
Calling a Dialog for Defining Exceptions
Calling a Dialog for Defining Conditions
Calling a Dialog for Cell Properties
Save Query View Dialog Box
Exceptions and Conditions
Commands for Exceptions
Setting the Status of an Exception
Commands for Conditions
Setting the Status of a Condition
Commands for Currency Translation
Commands for Values Cells
List Calculations
Operations for Display Hierarchies
Command Sequences
Using Forms
Use of JavaScript Functions
Send Commands
Execute URL in the Same Window
Execute URL in a New Window
URL from a New Window in the Opening Window
Closing Windows
Executing a Form in a New Window
Executing a Form in the Opening Window
Enhancing the Context Menu with JavaScript
Adding a Menu Entry using JavaScript
Command Processing
Properties of Page Objects
Web Item Attributes
Characteristics for Data Providers
Specifying Properties for Web Templates
Calendar for Date Filter
Logon Language
Language-Dependent Texts
Creating ABAP Programs for Maintaining Language-Dependent Texts
More Complex Examples of Applications
Dynamically Changing Attributes
Using Several Tab Pages
Example Scenario for the Parameter NO_OUTPUT
XML Web Item: Data Provider Information
Web Design API for Tables
Creating and Using ABAP Classes
Table Interace
Attributes
Datasets
AXIS_INFO
AXIS_DATA
CELL_DATA
TXT_SYMBOLS
Events
Manipulating Cell Contents
Headers
Scaling Factors
Characteristic Values
Attribute Values
Structural Components
Data Cells
Error Cells
Labeling Area of the Navigation Block
Filter Area of the Navigation Block
Service Methods
Creating Navigation URLs
Information on the Navigation Status
Information on a Specific Cell
Symbols
Sending Messages
JavaScript Functions
Determining Specific Attributes for the Table Interface
Analysis & Reporting: BEx Web Applications
Context Menu Functions
Select Filter Value
Searching in Hierarchies
Changing Filter Values
Goto
Currency Translation
Exporting as a CSV File / MS Excel 2000 File
Setting Bookmarks
Characteristic Properties
Properties of the Key Figure
Properties of the Query
Key Figure Definition
Table
Generic Navigation Block
List of Conditions
Defining and Changing Conditions
List of Exceptions
Defining and Changing Exceptions
Label
Dropdown Box, Radio Button Group, Checkboxes, Hierarchical Filte
Web Template
Query View – Selection
Key Figure Overview
Ad-hoc Query Designer Functions
Ad-hoc Query Designer: Defining New Queries
Characteristic Properties
Selection/Formula Properties
Structure Properties
Query Properties
Ad-hoc Query Designer: Defining New Queries with the Wizard
Ad-hoc Query Designer: Changing Queries
Using Documents in Web Applications
Creating New Documents
Finding Documents
Displaying Documents for InfoProvider Data
Displaying Documents for a Cell
Special Features of Calculated Key Figures or Formulas
Displaying Documents in the List of Documents Web Item
Displaying Documents for a Column or a Row
Navigating in the List of Documents Web Item
Creating Documents in the Web item List of Documents
Navigating in Maps
Example of Interaction in Maps
Functions of the Advanced Geo-Function Bar
Displaying Exceptions in Maps and Charts
Using What If Prediction in Web Applications
Using ABC Classification in Web Applications
Using Variables in Web Applications
The Variables Screen
Personalizing Variables in Web Applications
Personalizing the Start Views of Web Applications
Standard Web Template for Ad-hoc Analysis
Accessibility in Web Applications
Web Browser Dependencies
BEx Web Analyzer
BEx Mobile Intelligence
Creating a Mobile Application
Supported Web Items
Automatic Device Recognition
PDA Application
WAP Application
i-Mode Applications
Online Scenario
Alert Scenario
Offline Scenario
Downloading Web Templates with the BEx Download Scheduler
Downloading Web Templates with WebDav and Web Folder
Analysis & Reporting: BEx Analyzer
BEx Toolbar Functions
Open
Save
Refreshing Queries
Changing Queries
Personalizing Variables in the BEx Analyzer
Goto
OLAP Functions for Active Cells
Formatting
Layout
Tools
Settings
Evaluating Query Data
Navigation and Navigation Functions
Selecting Filter Values
Filter Values: Formulating Selection Conditions
BEx Map
Geographical Data Analysis with BEx Map
Analyzing Data Geographically Using the BEx Map
Saving Query Variants
Query Properties
Translating Currencies
Information Functions
Queries in Workbooks
Cell Areas of a Query
Creating Workbook Templates
Removing Queries from Workbooks
Displaying Changes for Queries in Workbooks
Detaching Queries
Positioning Query Cell Areas
Displaying Text Elements
Background Information on Excel Functions
Sheet Protection
Integration with Visual Basic for Applications
Precalculating and Distributing Workbooks
General Analysis Functions in BEx
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
Displaying Exceptions: Alert Monitor
Local Calculations
Calculate Result As...
Calculate Single Values As...
Aggregation and Calculation Time for Data
Interpretation of the Results Rows
Priority Rule with Formatting Settings
Working with Hierarchies
Suppression of Zeros and Zero Columns
General Services in BEx
Opening and Saving Objects in BW
The Open Dialog
The Search Dialog
The Save Dialog
Personalization in BEx
Information Broadcasting
Tasks for System Administration
Including an Event Data Change in a Process Chain
Defining Times for Broadcast Scheduling
Administration of the Precalculation Server
Creating Precalculation Servers
Monitoring the Sending of E-mails
Reorganization of Bookmark IDs and View IDs
User Guide
Functions of the BEx Broadcaster
Calling the BEx Broadcaster
Precalculating and Distributing Queries and Web Templates
General Settings for Precalculation and the Creation of Links
Filter Navigation
Precalculating and Distributing Workbooks
Sending by E-Mail
Exporting into the Enterprise Portal
Displaying Folder Contents with Broadcasting Layout Profile
Scheduling Broadcast Settings
Find, Display and Delete Scheduled Broadcast Settings
Publishing BEx Web Applications and Queries
Business Explorer Portal Role
Example Scenarios for Information Broadcasting
Distribution of the Monthly Sales Report by E-mail
Ad-hoc Distribution of Unusual Sales Data by E-mail
Providing the Sales Report in the Portal and Notification Upon D
Ad-hoc Distribution of the Sales Report into Collaboration Rooms
Integration into the SAP Enterprise Portal
Integration of SAP BW and SAP EP
Differences SAP BW 3.5 – SAP EP 6.0 & SAP BW 2.x/3.x – SAP EP 5
Differences between SAP EP 5.0 and SAP EP 6.0
Integration of SAP BW 3.5 and SAP EP 6.0
Integration from the User’s Viewpoint
Display of Content from SAP BW in the Enterprise Portal
Calling Content from SAP BW in the Enterprise Portal
Content from SAP BW in the Navigation Panel
Integration from the Viewpoint of Administrators and Authors
Overview: Integration and Display Types of BW Content in the Por
Display of Content from SAP BW in the Enterprise Portal
BEx Web Application or Query as iView in the Enterprise Portal
BEx Web Application or Query As Document or Link in Knowledge Ma
BW Workbook as an iView in the Enterprise Portal
BW Workbook as Precalculated Document in Knowledge Management
BW Documents in Knowledge Management as iView
Web Interface (from BW BPS) as iView in the Enterprise Portal
Components from SAP BW in the Enterprise Portal
Calling Content from SAP BW in the Enterprise Portal
Calling with Portal Roles
Calling from KM Folders
Calling with the BEx Portfolio
Content from the SAP BW in the Navigation Panel
Generating Content from SAP BW for the Enterprise Portal
Integration Functions in the Web Application Designer
Integration Functions in the Query Designer
Integration Functions in the BEx Broadcaster
Integration Functions in the BEx Analyzer
Integration Using the Portal Content Studio
Integration Using KM Content
Integration Using Role Upload
Integration Using the Role Menu and the Alert Monitor
Integration of SAP BW 3.5 and SAP EP 5.0
Integration Using Roles
Integration Using iViews
Integrating BW Services Using the iView Wizard
Integration of BW Components into the Portal
Using the iPanel in the Enterprise Portal 5.0
Integration of SAP BW 3.x and SAP EP 6.0
Drag&Relate with BW Contents in the Enterprise Portal
Drag&Relate Scenarios
Background Information on Drag&Relate Between BW and R/3
Working with R/3 Objects and BW InfoObjects
Drag&Relate-Enabled Characteristics
Organizing: BEx Browser
Selecting and Opening Documents
Working with the Business Explorer Browser
BEx Browser: Administration
Creating Logos and Folder Symbols
The Business Explorer Browser on the Web
Formatted Reporting: Crystal Reports Integration
Creating & Distributing Formatted Reports