Enterprise Reporting, Query, and Analysis
Getting Involved
Working with the Development Environment
Go and Create
Defining New Queries
Creating Reports with the Report Designer
Creating Web Applications with the BEx Web Application Designer
Example 4: BI iView
Core Development Tasks
Developing User Interfaces
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
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
Accessibility in Web Applications
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
Workbook Settings
Developing Business Logic
Installing Business Content
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
Customer and Partner Content
Using Connectivity and Interoperability
Report-Report Interface
Editing Sender-Receiver Assignments to the RRI in the BI System
Receivers
Maintaining Assignment Details
Creating a Transaction as a Receiver
Creating a Web Address As a Receiver
Examples for Jumping to Web Pages
BEx Query as Recipient
Example of a BEx Query as a Receiver
Web Applications As Sender
iView As Receiver
Web Service for Accessing Query Data
Open Analysis Interfaces
MDX as Basis for the Interfaces
Mapping Metadata
Examples for CALCULATED MEMBER
MDX Leveling
SAP Variables
BI-Specific Enhancement: Schema Rowset SAP VARIABLES
BI-Specific Enhancement: MDX Syntax
OLAP BAPI
MDDataProvider BW
MDDataProviderBW.GetCatalogs
MDDataProviderBW.GetCubes
MDDataProviderBW.GetDimensions
MDDataProviderBW.GetHierarchies
MDDataProviderBW.GetLevels
MDDataProviderBW.GetMeasures
MDDataProviderBW.GetMembers
MDDataProviderBW.GetProperties
MDDataProviderBW.GetVariables
MDDataSetBW
MDDataSetBW.CheckSyntax
MDDataSetBW.CreateObject
MDDataSetBW.DeleteObject
MDDataSetBW.FindCell
MDDataSetBW.FindTuple
MDDataSetBW.GetAxisData
MDDataSetBW.GetAxisInfo
MDDataSetBW.GetCellData
MDDataSetBW.SelectData
Parameters
Import Parameter: AllProperties
Import Parameter: LvLNumber
Import Character: MemType
Import Parameter: Restrictions
Import Parameter: SelectedProperties
Import Parameter: Treeop
Export Parameter: AggrExceptional
Export Parameter: Catalogs
Export Parameters: Cubes
Export Parameter: Dimensions
Export Parameter: Hierarchies
Export Parameter: Levels
Export Parameter: Measures
Export Parameter: Members
Export Parameter: OptionalProperties
Export Parameter: Properties
Export Parameter: Variables
Import Parameter: Cmd
Import Parameter: CmdParams
Import Parameter CommandText
Import Parameter: Members
Import Parameter: Trace
Export Parameter: AxisDimensions
Export Parameter: AxisInfo
Export Parameter: AxisLevels
Export Parameter: CellData
Export Parameter: Data
Export Parameter: DimPrptys
Export Parameter: Fltcolinfo
Export Parameter: MndtryPrptys
Export Parameter: OptionPrptysKeys
Export Parameter: OptionPrptysVals
Export Parameter: Return
Error Handling
OLE DB for OLAP
Installing SAP BW OLE DB for OLAP
Installing Frontend Components
Using OLE DB for OLAP Providers
XML for Analysis
Open Standards in the SDK
The J2EE Platform and SAP NetWeaver
Common Warehouse Metamodel
Java Metadata Interface
Java Database Connectivity
Meta Object Facility
XML Metadata Interchange
OLE DB for OLAP and XML for Analysis
BI Java Connectors
Configuring the BI Java Connectors
BI JDBC Connector
BI ODBO Connector
BI SAP Query Connector
BI XMLA Connector
Applying Extensibility
Customer Exits
Classic BAdIs
Customer Exits
Ensuring Quality
Testing
Query Monitor
Query Properties
Read Mode
Cache Mode
Accuracy
Not Using Parallel Processing
Processing Queries
Using the Cache Despite Virtual Characteristics and Key Figures
Technical Information
BI Content Analyzer
Implementing Business Content for the BI Content Analyzer
Roles
Content Administrator
Web Templates
Web Template: BI Cont Analyser_Reporting
Queries
Reporting Enhancement
Reporting Enhancement_Graph
Important Settings
Setting Global Settings
Determining Check Execution
Setting Priorities
Setting Exceptions
Including Source-System Dependent Objects
Releasing Packages
Scheduling Check Programs
BI Content Analyzer Checks
Logging and Tracing
Using Log Files for Troubleshooting
Debugging the Model
Accessing the Debugger
Viewing a Log of Portal Server Actions
Using the Events Monitor
Using the Data Inspector
Reference
API Documentation
Checklist for Defining Queries