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 |
Selecting Constants |
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 |
Editing Sender/Receiver Assignments to the R/RI in BW |
Creating InfoSet Queries as Receiver Reports |
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 |
Creating Web Applications with the BEx Web Application Designer |
Further Editing Web Templates |
Creating Web Applications with the Web Application Wizard |
Making Settings |
Storage of Stylesheets and Icons |
From Web Template to Web Application |
Determining 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 |
Setting Up the BEx Web Application Designer |
Web Items |
General attributes |
Resetting and Reinitializing Web Items |
Tables |
Chart |
Automatic Axis Labeling for Simple Charts |
Editing Charts |
Configuring Preview Windows |
Undoing Changes |
Formatting the Chart Background |
Formatting Chart Plot Areas |
Changing the Filling and Border of Surfaces |
Changing the Size of Chart Elements |
Changing the Position of Chart Elements |
Removing Chart Elements |
Chart Types |
Editing Chart Types Class 1 |
Editing Chart Types of Class 2 |
Editing Chart Types of Class 3 |
Changing the Chart Type |
Axes and Gridlines |
Showing and Hiding Axes |
Changing the Position of the Tick Marks |
Changing the Scale |
Changing the Point of Intersection of Axes |
Reversing the Order of Categories and Values |
Formatting Axes and Axis Labels |
Changing the Start and End Points of a Value Axis |
Changing the Value Axis Interval |
Changing Minor Tick Mark and Minor Tick Mark Label Intervals |
Adding a Value Range |
Formatting Value Ranges |
Formatting the Value Range Title |
Changing the Title and Values of a Value Range |
Showing and Hiding Grid Lines |
Editing Gridlines |
Data Series and Data Points |
Plotting a Data Series to a Secondary Axis |
Formatting Data Series |
Smoothing Lines |
Adding, Changing and Removing Trendlines |
Formatting Trendline Equations |
Adding and Removing Error Bars |
Editing Error Bars |
Adding and Removing Normal Distributions |
Editing a Normal Distribution |
Formatting the Title of a Normal Distribution |
Formatting the Tachometer Needle Label |
Changing the Value Range of a Tachometer |
Rotating Pie and Ring Charts |
Deactivating the Color Change for a Pie Chart or Doughnut |
Changing the Width of the Doughnut |
Changing the Depth of 3D Charts |
Formatting Walls and Floors |
Changing Quadrants |
Showing and Hiding Drop Lines |
Formatting Data Points |
Changing the Distance between Groups of Data Points |
Changing the Overlapping of Data Points |
Titles, Data Labels and Legends |
Adding and Removing Chart Titles |
Adding and Removing Axis Titles and Units |
Formatting Chart Titles, Axis Titles and Units |
Adding Data Labels |
Formatting Data Labels |
Removing Data Labels |
Changing Texts of Titles, Units and Data Labels |
Adding and Removing Legends |
Formatting Legend Texts and Symbols |
Formatting the Legend Background |
Data Tables |
Showing and Hiding Data Tables |
Formatting Data Tables |
Changing the Page Layout |
Printing Charts |
Dropdown Box |
Radio Button Groups |
Checkboxes |
Generic Navigation Block |
Hierarchical Context Menu |
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 |
Ad-hoc Query Designer |
What If Prediction |
ABC Classification |
BW Stylesheets |
Print Stylesheet |
Web Templates |
Overriding Attributes |
Object Tags |
Object Tag for the Properties of Web Templates |
Adjusting and Enhancing the Context Menu |
Kontextmenü anpassen |
Enhancing the Context Menu |
Object Tag for Data Provider |
Object Tag for Web Items |
Befehl-URLs |
Changing Web Item Attributes |
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 Icon Directory |
Releasing Web Templates |
Ending the Session |
Variables |
Calling up the Variables Screen |
Changing the Values of Variables |
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 |
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 |
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 |
Web Design API for Tables |
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 |
Icons |
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 |
Properties for a characteristic |
Local Properties of a Key Figure |
Local 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, Checkbox, Hierarchical Context |
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 |
Navigation Functions in the Standard Web Template |
Structure of a Standard Web Template |
Accessibility in Web Applications |
Web Browser Dependencies |
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 |
Downloading Pre-calculated Web Templates with the Mobile Engine |
Collaboration & Distribution: Enterprise Portal Integration |
Integration of BW and the Portal |
Integration Using iViews |
Integrating BW Services Using the iView Wizard |
Integration of BW Components into the Portal |
Drag&Relate with the SAP Unifier for BW |
Drag&Relate with the SAP Unifier for SAP R/3 |
Characteristics Compatible with Drag&Relate |
Using the iPanel in the Enterprise Portal 5.0 |
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 |
General Analysis Functions in BEx |
Conditions |
Basics and Example Scenarios for Conditions |
Condition: Top 5 Products |
Condition: Top 3 Products and Top 3 Sales Channels |
Condition: Top 3 Combinations from Product and Sales Channel |
Condition: Top 2 Products and Bottom 2 Products |
Conditions: Bottom 2 Sales and Invoiced Quantity > 100,000,000 |
Using Conditions |
Background Information on Conditions |
Exception Reporting |
Displaying Exceptions: Alert Monitor |
Priority Rule with Formatting Settings |
Aggregation and Calculation Time for Data |
Interpretation of the Results Rows |
Calculate Result As... |
Calculate Single Values As... |
Working with Hierarchies |
Formatted Reporting: Crystal Reports Integration |
Creating & Distributing Formatted Reports |
Opening and Saving Objects in BW |
The Open Dialog |
The Search Dialog |
The Save Dialog |
Personalization in BEx |
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 |