Enterprise Reporting, Query, and Analysis
Getting Involved
Working with the Development Environment
Go and Create
Defining New Queries
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
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
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
Accessibility in Web Applications
Developing Business Logic
Installing Business Content
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
Functions on the BW 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
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
Web Service for Accessing Query Data
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
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
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
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