SAP Business Explorer
SAP Business Explorer
Content
SAP 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
Creating Input-Ready Queries
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
Filter
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 from CURRENT MEMBER
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 Rows
Example: Defining Cells for Changes to Key Figures
Examples for Using Variables
Example: List of Slow-Moving Items
BEx Web
Tasks for System Administration
Mass Maintenance and Conversion of Web Templates and Reusable Web Items
Reorganization of Bookmarks
Displaying BI Query Runtime Statistics on the Web
Setting the Size Restriction for Result Sets
Activating the Export Library for SAP Business Explorer
Analysis and Reporting: BEx Web Applications
Analyzing Data in an Analysis Grid (with Navigation and Filter Panes)
Example: Swapping Axes in the Navigation Pane Using Drag and Drop
Example: Moving a Characteristic in the Navigation Pane Using Drag and Drop
Example: Moving a Characteristic in the Rows Using Drag and Drop
Example: Dragging and Dropping Structural Components in the Columns
Example: Dragging a Characteristic to the Columns Using Drag and Drop
Example: Dragging a Characteristic to the Rows Using Drag and Drop
Example: Dragging a Characteristic to a Data Cell Using Drag and Drop
Example: Dragging a Characteristic to a Characteristic Value of Another Characteristic
Example: Dragging a Characteristic Value to a Characteristic Using Drag and Drop
Example: Dragging a Characteristic Value to Another Characteristic Value Using Drag and Drop
Planning Business Data Manually
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 Selection Web Item
Query View Selection with a Dropdown Box
Web Template
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
Creating Print Versions of BEx Applications
Personalizing the Start Views of Web Applications
Web Browser Dependencies
Planning in BEx Web Applications
Cell Locks
Local Cell Locks in a Query (Front End)
Global Cell Locks 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
BEx Patterns
Information Consumer Pattern
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
Using Conditions
Ranked List Condition: Top 5 Products
Linking to Conditions: Bottom 2 Revenue and Invoiced Quantity > 100,000,000
Ranked List Condition with 2 Condition Rows: Top 2 Products and Bottom 2 Products
Ranked List Condition for All Characteristics in Drilldown Independent: Top 3 Products and Top 3 Sales Channels
Query with Condition and Results Row Suppression
Ranked List Condition for Characteristic Combination: Top 10 Combinations from Product and Sales Channel
Threshold Condition for a Characteristic in a Cross-Classified Table
Condition for All Characteristics in Drilldown Independent
Enhanced Basics and Example Scenarios for Conditions
Query with Two Structures and Threshold Value Conditions: And/Or Linking
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 NetWeaver 7.1
Accessibility in BEx
BEx Broadcaster
Configuring Information Broadcasting
Integration with SAP BusinessObjects
Integration with SAP BusinessObjects Dashboards
Creating and Publishing Dashboards with BW Data
Using Dashboards in SAP BW
Using Parameters to Call Dashboards
Integration with SAP Crystal Reports
Creating and Publishing Crystal Reports
BEx Web Integration in SAP BusinessObjects Business Intelligence
Configuring BEx Web Integration
Starting a Server for BEx Web Applications
Starting a Standalone Server for BEx Web Applications
Configuring Server Settings
Checking Connection to BW System
Configuring a Connection Between BEx Web Application Designer and BusinessObjects Business Intelligence
Creating an RFC destination in the ABAP System
Calling and Saving BEx Web Applications in the BI Launch Pad
Calling BEx Web Applications in BEx Web Application Designer
Opening BEx Web Applications in the BI Launch Pad
Saving BEx Web Applications as Bookmarks
Integration with SAP BusinessObjects Analysis