Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Conventions

What's New in This Guide for Release 11.1.1.7

1 Introduction to Oracle Business Activity Monitoring

• 1.1 About Oracle BAM
• 1.2 Real Time Data Streaming
  • 1.2.1 Oracle BAM Adapter
  • 1.2.2 Direct JMS Connectivity
  • 1.2.3 Oracle Data Integrator
  • 1.2.4 Oracle BAM Web Services
• 1.3 External Data Sources
• 1.4 Oracle BAM Server
  • 1.4.1 Oracle BAM Active Data Cache
  • 1.4.2 Oracle BAM Event Engine
  • 1.4.3 Oracle BAM Report Cache
• 1.5 Oracle BAM Web Applications
  • 1.5.1 Oracle BAM Start Page
  • 1.5.2 Oracle BAM Active Viewer
  • 1.5.3 Oracle BAM Active Studio
  • 1.5.4 Oracle BAM Architect
  • 1.5.5 Oracle BAM Administrator
  • 1.5.6 Oracle BAM Report Server
• 1.6 Oracle BAM Data Control
• 1.7 Oracle BAM Administration
• 1.8 ICommand
• 1.9 Related Documentation
• 1.10 Samples and Tutorials

2 Getting Started With Oracle BAM Web Applications

• 2.1 Microsoft Internet Explorer Settings
  • 2.1.1 Disable Popup Blockers
  • 2.1.2 Open Separate Browser Windows For New URLs
  • 2.1.3 Configure Print Settings
  • 2.1.4 Disable Browser Caching
  • 2.1.5 Hide Address Bar in Oracle BAM Web Applications
• 2.2 Starting Oracle BAM Web Applications
• 2.3 Personalizing Oracle BAM Web Applications
  • 2.3.1 Configuring Print Setup (Required)
  • 2.3.2 Configure Time Zone Preferences
  • 2.3.3 Specifying Report Loading Indicator Settings
  • 2.3.4 Enabling Oracle BAM Active Studio View Editor Animation
  • 2.3.5 Selecting a Report for the Oracle BAM Active Studio Home Tab
• 2.4 Getting Started With Oracle BAM Active Viewer
  • 2.4.1 Select Report
  • 2.4.2 Print Preview
  • 2.4.3 Personalize
  • 2.4.4 Reprompt
  • 2.4.5 Save Offline
  • 2.4.6 Email
• 2.5 Getting Started With Oracle BAM Active Studio
  • 2.5.1 Tabs
  • 2.5.2 Toolbars
  • 2.5.3 Reports
  • 2.5.4 Alerts
  • 2.5.5 Folders
  • 2.5.6 Actions
  • 2.5.7 View Tasks/Options
  • 2.5.8 Guide Text
  • 2.5.9 View Editor
• 2.6 Getting Started With Oracle BAM Architect
• 2.7 Getting Started With Oracle BAM Administrator
• 2.8 Getting Started With Oracle BAM Samples

3 Creating and Managing Reports

• 3.1 Introduction to Report Creation and Delivery
• 3.2 Creating Tiled Reports
• 3.3 Creating Columnar Reports
  • 3.3.1 Grouping Items in Columnar Reports
  • 3.3.2 Adding Summary Functions in Columnar Reports
  • 3.3.3 Quick Formatting in Columnar Reports
• 3.4 Saving Reports
• 3.5 Renaming Reports
• 3.6 Editing Reports
  • 3.6.1 Editing a Report
  • 3.6.2 Adding Report Titles
  • 3.6.3 Formatting Report Titles
  • 3.6.4 Setting Backgrounds for Reports
  • 3.6.5 Resizing Views
  • 3.6.6 Inserting Views
  • 3.6.7 Deleting Views
  • 3.6.8 Changing View Types
  • 3.6.9 Changing the Data Objects Used
  • 3.6.10 Setting Active Data Retrieval Interval
  • 3.6.11 Setting a Report-Level Poll Mode Refresh Interval
  • 3.6.12 Configuring Report Breadcrumbs
  • 3.6.13 Configuring Browser Padding
• 3.7 Deleting Reports
• 3.8 E-mailing Reports
• 3.9 Printing Reports
• 3.10 Copying Report URLs
• 3.11 Saving Reports Offline
• 3.12 Viewing Reports
• 3.13 Responding to Report Prompts
• 3.14 Pausing and Playing Active Data
• 3.15 Adding Oracle BAM Reports to Web Pages

4 Creating and Using Views

• 4.1 Creating and Using List Views
  • 4.1.1 Introduction to List Views
  • 4.1.2 Creating List Views
  • 4.1.3 Configuring List View Formatting Properties
  • 4.1.4 Sorting Data in List Views
  • 4.1.5 Adding Summaries to a Collapsed List
  • 4.1.6 Configuring the Action List
    • 4.1.6.1 Selecting Rows of Data in the Action List
    • 4.1.6.2 Editing Data in the Action List
    • 4.1.6.3 Adding Action Buttons
  • 4.1.7 Using the Paging Controls
• 4.2 Creating and Using Chart Views
  • 4.2.1 Introduction to Chart Views
  • 4.2.2 Creating Chart Views
  • 4.2.3 Configuring Chart View General Formatting Properties
  • 4.2.4 Grouping Data
  • 4.2.5 Configuring Time Groups
  • 4.2.6 Configuring Chart Targets
  • 4.2.7 Creating Charts With Multiple Data Objects
    • 4.2.7.1 Adding Data Objects to Chart Views
    • 4.2.7.2 Editing Charts Containing Multiple Data Objects
    • 4.2.7.3 Removing Data Objects From Charts
  • 4.2.8 Creating Statistical Process Control Charts
    • 4.2.8.1 Creating an SPC Chart Data Object
    • 4.2.8.2 Selecting Fields for SPC Charts
  • 4.2.9 Using the Pie Chart
• 4.3 Creating and Using the Columnar View
  • 4.3.1 Introduction to the Columnar View
  • 4.3.2 Adding a Columnar View to a Report
  • 4.3.3 Adding Summaries to a Columnar View
  • 4.3.4 Configuring Columnar View Formatting Properties
  • 4.3.5 Using the Columnar View
• 4.4 Creating and Using Key Process Indicator Views
  • 4.4.1 Introduction to KPI Views
  • 4.4.2 Creating KPI Views
  • 4.4.3 Configuring KPI View Formatting Properties
  • 4.4.4 Selecting a Gauge Style
• 4.5 Creating and Using Crosstab Views
  • 4.5.1 Introduction to Crosstab Views
  • 4.5.2 Creating Crosstab Views
  • 4.5.3 Configuring Crosstab View Formatting Properties
  • 4.5.4 Configuring Summaries in Crosstab and Summary Crosstab Views
  • 4.5.5 Configuring Conditional Formatting in Matrix Views
  • 4.5.6 Using the Crosstab View
    • 4.5.6.1 Filtering the Crosstab View
    • 4.5.6.2 Changing the Aggregate Function
    • 4.5.6.3 Changing Row and Column Order
    • 4.5.6.4 Pivoting
    • 4.5.6.5 Rolling Up and Drilling Down
  • 4.5.7 Using the Summary Crosstab View
    • 4.5.7.1 Filtering the Summary Crosstab View
    • 4.5.7.2 Changing the Aggregate Function
    • 4.5.7.3 Rolling Up and Drilling Down
    • 4.5.7.4 Sorting the Summary Crosstab View
  • 4.5.8 Using the Matrix View
• 4.6 Creating and Using the Excel View
  • 4.6.1 Introduction to the Excel View
  • 4.6.2 Creating an Excel View
  • 4.6.3 Configuring Excel View Formatting Properties
  • 4.6.4 Using the Excel View
    • 4.6.4.1 Saving the Excel Spreadsheet Outside of Oracle BAM
    • 4.6.4.2 Viewing Named Ranges
    • 4.6.4.3 Tips for Excel Views
• 4.7 Creating and Using the Action Form View
  • 4.7.1 Introduction to the Action Form View
  • 4.7.2 Creating Action Form Templates
  • 4.7.3 Creating Action Form Views
• 4.8 Creating and Using the External Content View
  • 4.8.1 Introduction to the External Content View
  • 4.8.2 Creating External Content Views
• 4.9 Creating and Using Utility Views
  • 4.9.1 Introduction to the Utility Views
  • 4.9.2 Creating the Surface Prompts View
  • 4.9.3 Creating the Container View
  • 4.9.4 Creating the Row Group and Column Group Views
  • 4.9.5 Creating the Tab Group View
  • 4.9.6 Creating the Dashboard View
    • 4.9.6.1 Configuring the Dashboard Toolbar

5 Manipulating Data in Views

• 5.1 Filtering Data
  • 5.1.1 Using Active Now
    • 5.1.1.1 Using is within a time interval
    • 5.1.1.2 Using is within the current time period
    • 5.1.1.3 Using is within a time period
    • 5.1.1.4 Using Active Now and Time Groups in the Same Chart
    • 5.1.1.5 Understanding Active Now Behavior in a Multiple Entry Filter Expression
• 5.2 Displaying Top N Data
• 5.3 Using Drilling
  • 5.3.1 Drilling Down
  • 5.3.2 Drilling Up
  • 5.3.3 Drilling Through
  • 5.3.4 Drilling Across
  • 5.3.5 Adding Drilling Hierarchies to Views
  • 5.3.6 Enabling Drilling Through to Details
  • 5.3.7 Configuring Drill-Across Targets
  • 5.3.8 Drilling Across to a URL
• 5.4 Adding Calculated Fields
  • 5.4.1 Using HTML in Calculations
  • 5.4.2 Using Decimal Type Numbers in Calculations
  • 5.4.3 Formatting Date Subtractions in Calculated Fields
• 5.5 Adding Surface Prompts
• 5.6 Applying Summary Functions to Groups

6 Formatting Views

• 6.1 Introduction to Formatting Views
• 6.2 Configuring General Formatting Properties
• 6.3 Configuring Axis Properties
• 6.4 Configuring View Borders, Shading, and Background Color
• 6.5 Configuring Text Alignment
  • 6.5.1 Suppressing Duplicate Fields
• 6.6 Displaying Data Labels
• 6.7 Configuring Font Formats
• 6.8 Configuring Themes
  • 6.8.1 Adding and Changing Themes
• 6.9 Configuring Value Formats
• 6.10 Configuring the Display of Active Data
• 6.11 Setting a View-Level Poll Mode Refresh Interval
• 6.12 Configuring Patterns

7 Editing Columnar Reports

• 7.1 About Columnar Reports
• 7.2 Using Formatting Toolbars
• 7.3 Inserting Images
• 7.4 Inserting Text

8 Using Prompts and Parameters

• 8.1 About Prompts and Parameters
  • 8.1.1 Applying Parameters
  • 8.1.2 Using System Date/Time Parameters
• 8.2 Creating Parameters
• 8.3 Creating Custom Parameters
• 8.4 Creating Prompts
  • 8.4.1 Creating a Datetime Type Parameter
  • 8.4.2 Creating a Field Type Parameter
• 8.5 Working with Prompts and Parameters
  • 8.5.1 Arranging Prompt Order
  • 8.5.2 Previewing Prompts
  • 8.5.3 Editing Prompts and Parameters
  • 8.5.4 Deleting Prompts and Parameters
  • 8.5.5 Cascading Prompts
• 8.6 Using Parameters in Report URLs
• 8.7 Driving Prompts and Parameters from Other Views
  • 8.7.1 Configuring Driving
  • 8.7.2 A Driving Example

9 Using Action Buttons

• 9.1 About Action Buttons
• 9.2 Creating Action Buttons
  • 9.2.1 Creating Action Buttons
  • 9.2.2 Configuring Insert Action Types
  • 9.2.3 Configuring Constant Value Update Action Types
  • 9.2.4 Configuring Edit Column Update Action Types
  • 9.2.5 Configuring Delete Action Types
  • 9.2.6 Configuring Open a URL Action Types
  • 9.2.7 Configuring View a Report Action Types
  • 9.2.8 Configuring Reset a Form Action Types
  • 9.2.9 Configuring Refresh a View Action Types
  • 9.2.10 Configuring Show a Confirmation Message Action Types

10 Organizing and Sharing Reports

• 10.1 Organizing Your Reports
• 10.2 Creating New Folders
• 10.3 Setting Folder Permissions
• 10.4 Working with Folders
• 10.5 Copying Reports and Folders
• 10.6 Moving Reports and Folders
• 10.7 Sharing Reports with Other Users
• 10.8 Deleting Shared Reports

11 Archiving and Purging Data

• 11.1 Archiving Data
• 11.2 Purging Data

A Calculation Operators and Expressions

• A.1 Calculation Operators
• A.2 Avg
• A.3 Ceiling
• A.4 Concat
• A.5 Count
• A.6 CountDistinct
• A.7 DateAdd
• A.8 DayName
• A.9 DayOfMonth
• A.10 DayOfWeek
• A.11 DayOfYear
• A.12 Floor
• A.13 Hour
• A.14 If
• A.15 IfNull
• A.16 Length
• A.17 Lower
• A.18 Max
• A.19 Min
• A.20 Minute
• A.21 Month
• A.22 MonthName
• A.23 Now
• A.24 PercentOfTotal
• A.25 Power
• A.26 Quarter
• A.27 Repeat
• A.28 Replace
• A.29 Round
• A.30 Second
• A.31 Substring
• A.32 Sum
• A.33 Switch
• A.34 TrimEnd
• A.35 TrimStart
• A.36 Upper
• A.37 Week
• A.38 Year

B Filter Comparison Expressions

• B.1 Filter Comparison Expressions
• B.2 Exceptions for Timestamp Filter Expressions

C Date and Time in Oracle BAM

• C.1 General Transformation and Formatting Of Date and Time
• C.2 Personalized Time Zone Settings
• C.3 Date (Datetime and Timestamp) Configuration in Reports
• C.4 Date and Time in Alerts
• C.5 Date and Time in Enterprise Message Sources

D Troubleshooting

• D.1 Upgrade Issues
  • D.1.1 Open 10.1.3.x Oracle JDeveloper Project with Oracle BAM sensor actions in Oracle JDeveloper 11g
• D.2 Startup and Login Issues
  • D.2.1 Database is Running and Reachable
  • D.2.2 404 Error
  • D.2.3 Authentication Failed Exception
  • D.2.4 Buttons Grayed Out on the Start Page
• D.3 Oracle BAM Web Application Issues
  • D.3.1 Loss of Active Data
  • D.3.2 Active Data is Intermittent
  • D.3.3 Reports Get Stuck
  • D.3.4 Printing Issues
  • D.3.5 Unable to Create or View Report With No Permissions on System Folder
  • D.3.6 Cannot Configure More Than 50 Prompt Values in a Report
  • D.3.7 Not All Values Are Displayed in the Filter Value Browse List
  • D.3.8 Action Form Error
  • D.3.9 Report Says "Reconnecting" Indefinitely
  • D.3.10 Data Object Name Is Different in Oracle BAM Architect and Oracle Enterprise Manager Fusion Middleware Control
  • D.3.11 Rows Truncated in List Views
  • D.3.12 Exception Message While Creating or Viewing Charts and KPIs
  • D.3.13 Cannot Reuse a User Name
  • D.3.14 Timing Is Off Between Active Now and Continuous Time Series
  • D.3.15 Exception Thrown Drilling Across Between Reports
• D.4 Oracle BAM Server Issues
  • D.4.1 Enterprise Message Source Not Receiving Messages
• D.5 Oracle BAM Adapter Issues
  • D.5.1 SOA Server Invalid User Name Exception
  • D.5.2 SOA Server Authentication Error With Correct Credential Configuration
  • D.5.3 Illegal Argument Exception on Oracle WebLogic Server Console Upon Restart or Editing Deployment of Oracle BAM Adapter
• D.6 Oracle BAM Sensor Action Issues
  • D.6.1 Loggers for Troubleshooting Oracle BAM Sensors Actions
• D.7 Oracle BAM ICommand Issues
  • D.7.1 JDBC Connection Pool Error
  • D.7.2 ICommand Fails to Connect With Oracle BAM Server
  • D.7.3 Unavailable External Data Source Error
• D.8 Oracle BAM Issues With Oracle Enterprise Manager Fusion Middleware Control Console
  • D.8.1 Oracle BAM Security Roles and Policies Are Not Displayed
• D.9 Oracle BAM Issues With Oracle WebLogic Server Administrative Console
  • D.9.1 Unable to Locate the Activate Changes Button
• D.10 Oracle BAM Issues With Oracle Data Integrator
  • D.10.1 Unable to Connect With Oracle Data Integrator
• D.11 Database Issues
  • D.11.1 Unable to Extend ORABAM Tablespace
  • D.11.2 Data Corruption Symptoms
• D.12 Using the Logs

Index