BI Suite: Business Explorer |
Query Design: BEx Query Designer |
The BEx Query Designer |
Working with the 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 Variables 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 |
Examples for Using Variables |
Defining Restricted Key Figures |
Defining Calculated Key Figures |
Query Properties |
Properties of Query Components |
Characteristic Properties |
Attribute Properties |
Selection/Formula Properties |
Properties of the Structure |
Properties of the Filter |
Properties of the Variable |
Properties of the Condition |
Properties of the Exception |
Properties of the Rows/Columns |
Tabular Query Display |
Functions on the BI Server |
Copying Queries Between InfoCubes |
Deleting Query Objects |
BEx Web |
Web Application Design: BEx Web Application Designer |
BEx Web Application Designer |
Screen Areas in the Web Application Designer |
Web Items Screen Area |
Web Template Screen Area |
Properties Screen Area |
Errors and Warnings Screen Area |
Functions of the Web Application Designer Menu Bar |
Functions in the Web Template Menu |
Functions in the Edit Menu |
Functions in the View Menu |
Functions in the Insert Menu |
Functions in the Format Menu |
Functions in the Tools Menu |
Functions in the Table Menu |
Functions in the Window Menu |
Functions in the Help Menu |
Web Templates |
Web Template Properties |
Designing the Layout of Web templates |
Context Menu in Web Templates |
Merging Cells in an HTML Table |
Further Editing Web Templates |
Mass Maintenance and Conversion of Web Templates |
Migration Tool |
Migrating Web Templates |
Text Input Dialog |
Creating ABAP Programs for Maintaining Language-Dependent Texts |
Creating a Web Application |
Calling the Web Application |
Connecting the Data to Be Displayed |
Displaying the Data |
Interaction in the Web Application |
Displaying Additional Information and Designing the Layout |
Reusability in Web Applications |
Creating Web Applications with the BEx Web Application Designer |
Working with Reusable Web Items |
Web Design API |
Web Items |
Web Item Grouping: Standard |
Analysis |
Chart |
Automatic Axis Labeling for Simple Charts |
Report |
Navigation Pane |
Filter Pane |
Button Group |
Dropdown Box |
Data Binding Type CHARACTERISTIC_SELECTION |
Data Binding Type QUERY_VIEW_SELECTION |
Data Binding Type STATIC_OPTION_LIST |
Data Binding Type STATIC_OPTION_LIST_MANUAL |
Radio Button Groups |
Checkbox Group |
List Box |
Hierarchical Filter Selection |
Web item Grouping: Extended |
Web Template |
Container Layout |
Container |
Tab Pages |
Group |
Single Document |
Document List |
Maps |
Map |
Parameters for Map Layers |
Map Renderers |
Parameters for Color Shading |
Parameters for Bar Charts |
Parameters for Pie Charts and Pie Charts (Split) |
Parameters for Dot Density |
Parameters for Symbols |
Parameters for Symbols (Size-Dependent) |
Parameters for Symbols (Color-Dependent) |
Parameters for Lines |
Parameters for Lines (Size-Dependent) |
Parameters for Lines (Color-Dependent) |
Additional Cartographical Information |
Displaying Additional Cartographical Information |
System Messages |
Information Field |
Web Item Grouping: Miscellaneous |
Data Provider – Information |
Text |
Link |
List of Exceptions |
List of Conditions |
Menu Bar |
Ticker |
Properties Pane |
Context Menu |
Script |
Web Template Parameter |
Parameter Tray |
Editing Charts |
Working with the Chart Designer |
Chart Types |
Class 1 Chart Types |
Class 2 Chart Types |
Class 3 Chart Types |
Class 4 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 |
Command Wizard |
Commands for Data Providers |
Basic Data Provider Commands |
Calling the Data Provider Properties Dialog |
Set Data Provider Parameters |
Set Zero Value Display |
Set Sign Presentation |
Data Provider Commands for Axes |
Set Universal Display Hierarchy |
Set Position of Result Row |
Swap Axes |
Remove Drilldown |
Drill Down a Characteristic |
Exchange |
Data Provider Commands for Characteristics |
Set Attributes |
Set Presentation |
Display of Result Row |
Open Characteristic Properties Dialog |
Set Sorting |
Data Provider Commands for Documents |
Open Document Browser |
New Document |
Commands for Planning Applications |
Refresh Data |
Save Changed Data |
Reset Changed Data |
Set Data Entry Mode |
Execute a Planning Function (Simple) |
Execute a Planning Sequence (Simple) |
Commands for Web Items |
Commands for Web Templates |
Start Broadcaster |
Creating Commands with the Command Wizard |
Parameter Override |
Using Parameters to Call Web Applications |
JavaScript |
General Use of JavaScript in Web Applications |
Using JavaScript Within Web Items |
JavaScript API for Executing Commands |
Web Application Examples |
Changing the Display: Table, Chart, Table and Chart |
Switching Between Chart and Table Using a Pushbutton |
Using JavaScript in the Dropdown Box Web Item |
Creating Planning Applications in the BEx Web Application Design |
Enterprise Reporting |
Static and Dynamic Sections in Reports |
Row Pattern |
Properties of Row Patterns |
BEx Report Designer |
Functions of the Report Designer |
Working with the Report Designer |
Design Area |
Field Catalog |
Report Structure |
Format Catalog |
Properties |
Functions of the Menu Bar in the Report Designer |
Functions in the Report Menu |
Functions in the Edit Menu |
Functions in the View Menu |
Functions in the Insert Menu |
Functions in the Format Menu |
Functions in the Extras Menu |
Functions in the Help Menu |
From the Query to the Report |
Creating Reports with the Report Designer |
Creating Conditional Formatting |
Standard Web Template for Reports |
Example Scenarios: Creating Different Report Types |
Balance Sheet: Arranging Assets and Liabilities Beside Each Othe |
Tasks for System Administration |
Mass Maintenance and Conversion of Web Templates |
Reorganization of Bookmarks |
Analysis & Reporting: BEx Web Applications |
Context Menu Functions |
Selecting Filter Values |
Goto |
Currency Translation |
Exporting as a CSV File/Excel File |
Setting Bookmarks |
Characteristic Properties |
Properties of the Structure Element or Data Cell |
Data Provider Properties |
Properties of the Web Item |
Key Figure Definition |
Analysis Grid |
Navigation Pane |
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 New Documents |
Displaying Documents for InfoProvider Data |
Displaying Documents for a Cell |
Navigating in Maps |
Example of Interaction in Maps |
Functions of the Advanced Geo-Function Bar |
Displaying Exceptions in Maps and Charts |
Using Variables in Web Applications |
Variables Screen |
Personalizing Variables in Web Applications |
Personalizing the Start Views of Web Applications |
Web Browser Dependencies |
BEx Web Analyzer |
Pushbutton Functions, Navigation Pane, and Context Menu |
Function Links |
Standard Web Template for Ad Hoc Analysis |
BI Patterns |
Information Consumer Pattern |
Business Explorer Portal Role |
BEx Mobile Intelligence |
Analysis & Reporting: BEx Analyzer |
Analysis Mode |
Analysis Functions |
Open |
Save |
Refresh / Pause Automatic Refresh |
Changing Variable Values |
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 |
Planning Functions |
Goto |
Precalculating and Distributing Workbooks |
Design Mode |
Design Functions |
Design Mode / Exit Design Mode |
Inserting Design Items |
Workbook Settings |
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 |
Configuring Data Providers |
Working in Formula Mode |
Moving and Resizing Design Items |
Deleting Design Items |
General Error and Message Handling |
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 |
Definition of Exceptions |
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 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 Value Help Dialog |
Personalization in BEx |
Data Providers in BI Applications |
Creating Print Versions of BI Applications |
Runtime and Design-Time Cross-Dependencies: SAP BW 3.x and SAP N |
Access to External Data Sources |
Information Broadcasting |
Tasks for System Administration |
Provision of Broadcasting Functions |
Including Event Data Changes in Process Chains |
Defining Times for Broadcast Scheduling |
Administration of the Precalculation Server |
Creating Precalculation Servers |
Broadcasting Functions |
Creating a Broadcast Setting |
Broadcast by E-Mail (Bursting) |
Broadcast by Exception |
Distribution over Multiple Channels |
Filling the Precalculation Store |
Precalculating Value Sets |
Filling the OLAP Cache |
Filling the MDX Cache |
User/Language |
Management and Monitoring |
Administration of Broadcast Settings |
Monitor the Sending of E-Mails |
Reorganization of Bookmark IDs and View IDs |
User Guide |
Calling the BEx Broadcaster |
Functions of the BEx Broadcaster |
Precalculating and Broadcasting Queries, Query Views, Web Templa |
General Settings for Precalculation and the Creation of Links |
Filter Navigation |
Precalculating and Distributing Workbooks |
Broadcast by E-Mail |
Broadcast to the Portal |
Displaying the Folder Content with the Broadcasting Layout Profi |
Printing |
Use of Text Variables |
Scheduling Broadcast Settings |
Finding, Displaying, and Deleting Scheduled Broadcast Settings |
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 |
Integrating BI Content into the Portal |
Integration from the User’s Viewpoint |
Display of BI Content in the Portal |
Calling BI Content in the Portal |
BI Content in the Navigation Panel |
Business Intelligence Portal Role |
Integration from the Viewpoint of Administrators and Authors |
Overview: Integration- and Display Types of BI Content |
Display of BI Content 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 Web Applications or Queries as iViews in Different Portals |
BEx Analyzer Workbook as an iView in the Portal |
BEx Analyzer Workbook As Precalculated Document in KM |
BI Documents in Knowledge Management as an iView |
Web Interface (from BW-BPS) As iView in the Portal |
BI Components in Portal |
Calling BI Content 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 |
BI Content in the Navigation Panel |
Creating BI Content for the Portal |
Integration Functions in the BEx Broadcaster |
Publishing Queries, Web Applications and Reports |
Integration Using the Portal Content Studio |
Integration Using the KM Content |
Integration Using Role Upload |
Crystal Report Integration |
Creating and Distributing Crystal Reports |