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 |
Example: Defining a Query with Key Figures |
Example: Defining Filters, Free Characteristics, Columns and Row |
Example: Defining Cells for Changes to Key Figures |
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 |
Creating Your Own Dialogs |
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 Interface |
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 |
Functions of the BEx Toolbar |
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 Po |
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 an 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 with KM Folders |
Calling with the BEx Portfolio |
Content from 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 Content in the SAP Enterprise Portal |
Differences Between Drag&Relate and the Report-Report Interface |
Creating Business Objects |
Linking Business Objects |
Working with BOR Objects and BW-InfoObjects |
Characteristics Compatible with Drag&Relate |
Defining an iView as a Drag&Relate Source |
Defining an iView as a Drag&Relate Target |
Performing Drag&Relate |
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 |