BI Suite: Business Explorer |
Query Design: 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 |
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 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 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 |
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 Row |
Example: Defining Cells for Changes to Key Figures |
Examples for Using Variables |
Example: List of Slow-Moving Items |
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 |
Layout Design of Web Templates |
Context Menu in Web Templates |
Merging Cells in an HTML Table |
Further Editing Web Templates |
Mass Maintenance and Mass Conversion of Web Templates and Reusab |
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 Layout Design |
Reusability in Web Applications |
Creating Web Applications with the BEx Web Application Designer |
Working with Reusable Web Items |
Storing and Including Images and Icons |
Formatting of Web Applications |
Adjusting and Assigning Portal Themes for SAP NetWeaver BI |
Using Portal Themes in SAP NetWeaver BI |
Settings for Tables, Trees, Labels and Fields |
Pattern Wizard |
Configuring Information Consumer Patterns |
Web Design API |
Web Items |
Web Item Grouping: Standard |
Analysis |
Chart |
Automatic Axis Labeling for Simple Charts |
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 |
Class 5 Chart Types |
Formatting a Chart Using 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 |
Examples of Improved Chart Layout |
Example: Configuring How Column Charts Are Displayed |
Example: Configuring How Line Charts Are Displayed |
Example: Configuring How Pie Charts Are Displayed |
Example: Configuring How Multiple Chart Types Are Displayed in a |
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 |
Data Binding Type VARIABLE_SELECTION |
Radio Button Group |
Checkbox Group |
List Box |
Hierarchical Filter |
Web Item Grouping: Advanced |
Web Template |
Container Layout |
Container |
Tab Pages |
Group |
Single Document |
List of Documents |
Maps |
Web Item: 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 |
Info Field |
Input Field |
Web Item Group: Miscellaneous |
Data Provider Information |
Text |
Link |
List of Exceptions |
List of Conditions |
Menu Bar |
Ticker |
Properties Pane |
Context Menu |
Script |
Custom Extension |
Page Break |
Web Template Parameters |
Data Provider Parameters |
Parameter Tray |
Commands |
Commands for Data Providers |
Basic Data Provider Commands |
Report-Report Interface |
Set Data Provider Parameters |
Set Zero Value Display |
Set Sign Display |
Back to Initial State |
Back to Previous State |
Translating Currencies |
Export Data Provider as XML |
Data Provider Commands for Axes |
Set Hierarchical Display of Axis |
Set Position of Results Row |
Swap Axes |
Remove Drilldown |
Drill Down a Characteristic |
Exchange Characteristics/Structures |
Data Provider Commands for Characteristics |
Set Display Attributes |
Set Presentation |
Display Result Row |
Set Sorting |
Data Provider Commands for Conditions/Exceptions |
Set Condition |
Set Status of a Condition |
Set Exception |
Set Status of an Exception |
Call Conditions Dialog |
Call Exceptions Dialog |
Data Provider Commands for Data Cells |
Set Data Cell Properties |
Set Local Calculations |
Data Provider Commands for Filter Values |
Remove All Filter Values |
Call Input Help Dialog |
Setting Filter Values for a Characteristic |
Set Filter Values |
Remove Filter Values for a Characteristic |
Remove Filter Values for a List of Characteristics |
Set Filter Values Using Different Sources |
Setting Filter Values Using a Filter |
Data Provider Commands for Hierarchies |
Set Hierarchy |
Expand/Collapse Hierarchy Nodes |
Set Node Alignment |
Data Provider Commands for Open/Save Functions |
Call Open Dialog |
Call Save Dialog |
Save Query View |
Data Provider Commands for Documents |
Open Document Browser |
Open Dialog for New Document |
Commands for Planning Applications |
Refresh Data |
Save Changed Data |
Reset Changed Data |
Set Data Entry Mode |
Executing a Planning Function (Simple) |
Executing a Planning Function |
Execute a Planning Sequence (Simple) |
Sources for Characteristic Selection and Variables |
Commands for Web Items |
Call Chart Properties Dialog |
Call Properties Dialog |
Setting Web Item Parameters |
Back to Initial State |
Back to Previous State |
Set Status of Module |
Commands for Web Templates |
Save Bookmark |
Load Bookmark |
Start Broadcaster |
Close Browser Window |
Transfer State |
Set Variable Values |
Open Variable Dialog |
Export Web Application |
Change Web Template |
Display Web Template as Modal Dialog |
Close Current Web Template Dialog with Cancel |
Close Current Web Template Dialog with OK |
Set Web Template |
Back to Initial State |
Back to Previous State |
Delete Personalization |
Save Personalization |
Creating Commands with the Command Wizard |
Parameter Override |
Using Parameters to Call Web Applications |
Dynamic Parameterization of Commands and Web Items |
Displaying XML |
Determining Paths |
Using Paths |
JavaScript |
Use of JavaScript in Web Applications and Web Items |
JavaScript API for Executing Commands |
Adding Menu Entries with JavaScript |
Command Processing |
BEx Web Interfaces |
Custom Extension Web Item |
Creating an ABAP Class for the Custom Extension Web Item |
ABAP Interface IF_BICS_CONS_WEBITEM_CUST_EXIT |
Inserting a Custom Extension into a Web Template |
Simple Example: Displaying a Simple Text and Parameter |
Complex Example: Displaying the XML of Two Data Providers |
Calling a BSP Page Specifying the Data Provider Status |
Analysis Web Item: Using Parameter Modification |
Using Modifications |
Examples of Modules |
Example: Column Width Module |
Example: Negative Number Module |
Example: Document Content Module |
Example: Empty Cells as Non Input-Enabled Module |
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 |
Using Cascading Dropdown Boxes |
Creating Planning Applications in the BEx Web Application Design |
Using Path Replacement in Commands |
Enterprise Reporting |
From the Query to the Report |
Static and Dynamic Sections in Reports |
Row Patterns |
Row Pattern Properties |
Creating Reports with Report Designer |
Inserting Images into Reports |
Creating Conditional Formatting |
Formatting Hierarchies |
Inserting Charts into Reports |
Defining Chart Properties |
Inserting User-Specific Texts |
Reusing Report Sections |
Standard Web Template for Reports |
BEx Report Designer |
Functions in Report Designer |
Working with Report Designer |
Design Area |
Field Catalog |
Report Structure |
Format Catalog |
Properties |
Menu Bar Functions in 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 Tools Menu |
Functions in the Help Menu |
Example Scenarios: Creating Different Report Types |
Balance Sheet: Aligning Assets and Liabilities |
Displaying a Query in a Tabular View |
Tasks for System Administration |
Mass Maintenance and Mass Conversion of Web Templates and Reusab |
Reorganization of Bookmarks |
Displaying BI Query Runtime Statistics on the Web |
Setting the Size Restriction for Result Sets |
Activating the Export Library for SAP NetWeaver BI |
Analysis & Reporting: BEx Web Applications |
Analyzing Data in an Analysis Grid (with Navigation and Filter P |
Example: Swapping Axes in the Navigation Pane Using Drag and Dro |
Example: Moving a Characteristic in the Navigation Pane Using Dr |
Example: Moving a Characteristic in the Rows Using Drag and Drop |
Example: Dragging and Dropping Structural Components in the Colu |
Example: Dragging a Characteristic to the Columns Using Drag and |
Example: Dragging a Characteristic to the Rows Using Drag and Dr |
Example: Dragging a Characteristic to a Data Cell Using Drag and |
Example: Dragging a Characteristic to a Characteristic Value of |
Example: Dragging a Characteristic Value to a Characteristic Usi |
Example: Dragging a Characteristic Value to Another Characterist |
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 Sele |
Query View Selection with a Dropdown Box |
Web Template |
Using Documents in Web Applications |
Creating a New Document |
Display of Documents for InfoProvider Data |
Displaying Documents for a Cell |
Special Features of Calculated Key Figures and Formulas |
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 |
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 |
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 |
Functions for Manual Planning |
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 |
Command Wizard |
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 |
General Error and Message Handling |
Restrictions in the BEx Analyzer |
Working with Documents in BEx Analyzer |
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 |
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 Reusable Web Items |
Working with Broadcast Settings |
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 |
Creating Print Versions of BI Applications |
Runtime and Design-Time Cross-Dependencies: SAP BW 3.x and SAP N |
Information Broadcasting |
Tasks for System Administration |
Provision of Broadcasting Functions |
Setting Up Broadcasting to the Portal |
Setting Up Broadcasting in Federated Portal Networks |
Setting Up Broadcasting Using WebDAV Repository Managers |
Setting Up Broadcasting Using KM Navigation iViews or CM Reposit |
KM Properties |
Including Event Data Changes in Process Chains |
Defining Times for Broadcast Scheduling |
Administrating the Precalculation Servers |
Administrating the Precalculation Servers (Transaction RSPRECALC |
Working with Precalculation Servers |
Analyzing Precalculations |
Setting Timeouts |
Checking Failed Settings |
Administrating the Precalculation Servers (Transaction SPRO) |
Creating Precalculation Servers |
Configuring Alert Management for Generating Alerts |
Broadcasting Functions |
Creating a Broadcast Setting |
Broadcast by E-Mail (Bursting) |
Broadcast by Exception |
Distribution over Multiple Channels |
Precalculating Value Sets |
Filling the OLAP Cache |
Filling the MDX Cache |
User/Language |
Management and Monitoring |
Administration of Broadcast Settings |
Monitoring 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 |
Making General Settings for Precalculation and Creating 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 Content from BI into the Portal |
Integration from the Users Viewpoint |
Displaying 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 for Content from BI |
Display of Content from BI 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 Analyzer Workbook as an iView in the Portal |
BEx Analyzer Workbook As Precalculated Document in KM |
BI Documents in Knowledge Management |
Document Structure for Metadata |
Document Structure for Master Data |
Document Structure for InfoProvider Data |
Migrating Documents into the CM Repository |
Migration iView |
Migrating Documents |
Web Interface (from BW-BPS) as iView in the Portal |
BI Components in Portal |
BI Content in the Navigation Panel |
Calling Content from BI 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 |
Creating Content from BI for the Portal |
Integration Functions in the BEx Broadcaster |
Publishing Queries, Web Applications and Reports |
Integration Using the Portal Content Studio |
Integration Using KM Content |
Integration Using Role Upload |
Integration of Content from BI into Other Portals |
Integrating into an SAP NetWeaver 2004 Portal (SAP EP 6.0) |
Creating a System in the SAP NetWeaver 2004 Portal (SAP EP 6.0) |
Configuring Single Sign-On (SSO) Between SAP EP 6.0 and the SAP |
Integration into an SAP NetWeaver 7.x Portal |
Setting Up Access to URLs from BEx in the Federated Portal Netwo |
Integration in Third-Party Portals |
Integration with SAP BusinessObjects |
Xcelsius Enterprise Integration |
Creating and Publishing Visualizations of BI Data |
Using Visualizations in SAP NetWeaver BI |
Using Parameters to Call Visualizations |
Crystal Report Integration |
Creating and Publishing Crystal Reports |