Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Conventions

1 Introduction to Oracle Business Activity Monitoring

• About Oracle BAM
• Real Time Data Streaming
  • Oracle BAM Adapter
  • Direct JMS Connectivity
  • Oracle Data Integrator
  • Oracle BAM Web Services
• External Data Sources
• Oracle BAM Server
  • Oracle BAM Active Data Cache
  • Oracle BAM Event Engine
  • Oracle BAM Report Cache
• Oracle BAM Web Applications
  • Oracle BAM Start Page
  • Oracle BAM Active Viewer
  • Oracle BAM Active Studio
  • Oracle BAM Architect
  • Oracle BAM Administrator
  • Oracle BAM Report Server
• Oracle BAM Administration
• ICommand
• Related Documentation
• Samples and Tutorials

2 Getting Started With Oracle BAM Web Applications

• Microsoft Internet Explorer Settings
  • Disable Popup Blockers
  • Open Separate Browser Windows For New URLs
  • Configure Print Settings
  • Disable Browser Caching
  • Hide Address Bar in Oracle BAM Web Applications
• Starting Oracle BAM Web Applications
• Personalizing Oracle BAM Web Applications
  • Configuring Print Setup (Required)
  • Configure Time Zone Preferences
  • Specifying Report Loading Indicator Settings
  • Enabling Oracle BAM Active Studio View Editor Animation
  • Selecting a Report for the Oracle BAM Active Studio Home Tab
• Getting Started With Oracle BAM Active Viewer
  • Select Report
  • Print Preview
  • Personalize
  • Reprompt
  • Save Offline
  • Email
• Getting Started With Oracle BAM Active Studio
  • Tabs
  • Toolbars
  • Reports
  • Alerts
  • Folders
  • Actions
  • View Tasks/Options
  • Guide Text
  • View Editor
• Getting Started With Oracle BAM Architect
• Getting Started With Oracle BAM Administrator

3 Creating and Managing Reports

• Introduction to Report Creation and Delivery
• Creating Tiled Reports
• Creating Columnar Reports
  • Grouping Items in Columnar Reports
  • Adding Summary Functions in Columnar Reports
  • Quick Formatting in Columnar Reports
• Saving Reports
• Renaming Reports
• Editing Reports
  • Editing a Report
  • Adding Report Titles
  • Formatting Report Titles
  • Setting Backgrounds for Reports
  • Resizing Views
  • Inserting Views
  • Deleting Views
  • Changing View Types
  • Changing the Data Objects Used
  • Setting Active Data Retrieval Interval
  • Configuring Report Breadcrumbs
  • Configuring Browser Padding
• Deleting Reports
• E-mailing Reports
• Printing Reports
• Copying Report URLs
• Saving Reports Offline
• Viewing Reports
• Responding to Report Prompts
• Pausing and Playing Active Data

4 Creating and Using Views

• Creating and Using List Views
  • Introduction to List Views
  • Creating List Views
  • Configuring List View Formatting Properties
  • Sorting Data in List Views
  • Adding Summaries to a Collapsed List
  • Configuring the Action List
    • Selecting Rows of Data in the Action List
    • Editing Data in the Action List
    • Adding Action Buttons
  • Using the Paging Controls
• Creating and Using Chart Views
  • Introduction to Chart Views
  • Creating Chart Views
  • Configuring Chart View General Formatting Properties
  • Grouping Data
  • Configuring Time Groups
  • Configuring Chart Targets
  • Creating Charts With Multiple Data Objects
    • Adding Data Objects to Chart Views
    • Editing Charts Containing Multiple Data Objects
    • Removing Data Objects From Charts
  • Creating Statistical Process Control Charts
    • Creating an SPC Chart Data Object
    • Selecting Fields for SPC Charts
  • Using the Pie Chart
• Creating and Using the Columnar View
  • Introduction to the Columnar View
  • Adding a Columnar View to a Report
  • Adding Summaries to a Columnar View
  • Configuring Columnar View Formatting Properties
  • Using the Columnar View
• Creating and Using Key Process Indicator Views
  • Introduction to KPI Views
  • Creating KPI Views
  • Configuring KPI View Formatting Properties
  • Selecting a Gauge Style
• Creating and Using Crosstab Views
  • Introduction to Crosstab Views
  • Creating Crosstab Views
  • Configuring Crosstab View Formatting Properties
  • Configuring Summaries in Crosstab and Summary Crosstab Views
  • Configuring Conditional Formatting in Matrix Views
  • Using the Crosstab View
    • Filtering the Crosstab View
    • Changing the Aggregate Function
    • Changing Row and Column Order
    • Pivoting
    • Rolling Up and Drilling Down
  • Using the Summary Crosstab View
    • Filtering the Summary Crosstab View
    • Changing the Aggregate Function
    • Rolling Up and Drilling Down
    • Sorting the Summary Crosstab View
  • Using the Matrix View
• Creating and Using the Excel View
  • Introduction to the Excel View
  • Creating an Excel View
  • Configuring Excel View Formatting Properties
  • Using the Excel View
    • Saving the Excel Spreadsheet Outside of Oracle BAM
    • Viewing Named Ranges
    • Performance Tips
• Creating and Using the Action Form View
  • Introduction to the Action Form View
  • Creating Action Form Templates
  • Creating Action Form Views
• Creating and Using the External Content View
  • Introduction to the External Content View
  • Creating External Content Views
• Creating and Using Utility Views
  • Introduction to the Utility Views
  • Creating the Surface Prompts View
  • Creating the Container View
  • Creating the Row Group and Column Group Views
  • Creating the Tab Group View
  • Creating the Dashboard View
    • Configuring the Dashboard Toolbar

5 Manipulating Data in Views

• Filtering Data
  • Using Active Now
    • Using is within a time interval
    • Using is within the current time period
    • Using is within a time period
    • Using Active Now and Time Groups in the Same Chart
• Displaying Top N Data
• Using Drilling
  • Drilling Down
  • Drilling Up
  • Drilling Through
  • Drilling Across
  • Adding Drilling Hierarchies to Views
  • Enabling Drilling Through to Details
  • Configuring Drill-Across Targets
  • Drilling Across to a URL
• Adding Calculated Fields
  • Using HTML in Calculations
• Adding Surface Prompts
• Applying Summary Functions to Groups

6 Formatting Views

• Introduction to Formatting Views
• Configuring General Formatting Properties
• Configuring Axis Properties
• Configuring View Borders, Shading, and Background Color
• Configuring Text Alignment
• Displaying Data Labels
• Configuring Font Formats
• Configuring Themes
  • Adding and Changing Themes
• Configuring Value Formats
• Configuring the Display of Active Data
• Configuring Patterns

7 Editing Columnar Reports

• About Columnar Reports
• Using Formatting Toolbars
• Inserting Images
• Inserting Text

8 Using Prompts and Parameters

• About Prompts and Parameters
• Creating Parameters
• Creating Custom Parameters
• Creating Prompts
  • Creating a Datetime Type Parameter
  • Creating a Field Type Parameter
• Working with Prompts and Parameters
  • Arranging Prompt Order
  • Previewing Prompts
  • Editing Prompts and Parameters
  • Deleting Prompts and Parameters
  • Cascading Prompts
• Using Parameters in Report URLs
• Driving Prompts and Parameters from Other Views
  • Configuring Driving
  • A Driving Example

9 Using Action Buttons

• About Action Buttons
• Creating Action Buttons
  • Creating Action Buttons
  • Configuring Insert Action Types
  • Configuring Constant Value Update Action Types
  • Configuring Edit Column Update Action Types
  • Configuring Delete Action Types
  • Configuring Open a URL Action Types
  • Configuring View a Report Action Types
  • Configuring Reset a Form Action Types
  • Configuring Refresh a View Action Types
  • Configuring Show a Confirmation Message Action Types

10 Organizing and Sharing Reports

• Organizing Your Reports
• Creating New Folders
• Setting Folder Permissions
• Working with Folders
• Copying Reports and Folders
• Moving Reports and Folders
• Sharing Reports with Other Users
• Deleting Shared Reports

A Calculation Operators and Expressions

• Calculation Operators
• Avg
• Ceiling
• Concat
• Count
• CountDistinct
• DateAdd
• DayName
• DayOfMonth
• DayOfWeek
• DayOfYear
• Floor
• Hour
• If
• IfNull
• Length
• Lower
• Max
• Min
• Minute
• Month
• MonthName
• Now
• PercentOfTotal
• Power
• Quarter
• Repeat
• Replace
• Round
• Second
• Substring
• Sum
• Switch
• TrimEnd
• TrimStart
• Upper
• Week
• Year

B Filter Comparison Expressions

• Filter Comparison Expressions
• Exceptions for timestamp filter expressions

Index