Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

New Features for Oracle Business Intelligence Developers

• New Features for Oracle BI 11g Release 1 (11.1.1.6)
• New Features for Oracle BI EE 11g Release 1 (11.1.1.5)
• New Features for Oracle BI EE 11g Release 1 (11.1.1.3)
• System Requirements and Certification

1 Embedding Business Intelligence Objects in ADF Applications

• 1.1 Overview of Embedding Business Intelligence Objects in Applications
• 1.2 Business Intelligence Objects That You Can Add to ADF Pages
• 1.3 Embedded Business Intelligence Objects Use Cases
• 1.4 Preparing the ADF Project to Accept Business Intelligence Objects
  • 1.4.1 How to Prepare the ADF Project
    • 1.4.1.1 Checking for Installed JDeveloper Extensions
    • 1.4.1.2 Installing the Required JDeveloper Extensions
    • 1.4.1.3 About Oracle BI EE Personalizations in ADF Applications
    • 1.4.1.4 Adding the MDS Libraries and Enabling MDS Customizations
    • 1.4.1.5 Adding the ADF Technology Scopes
• 1.5 Creating an Oracle BI EE Presentation Services Connection
  • 1.5.1 How to Configure SSL and Create an Oracle BI EE Presentation Services Connection
    • 1.5.1.1 Configuring SSL
    • 1.5.1.2 Exporting and Importing the Client Certificate
    • 1.5.1.3 Creating a connection
• 1.6 Adding Oracle Business Intelligence Objects to ADF Pages
  • 1.6.1 How to Add Business Intelligence Objects to an ADF Page
• 1.7 Passing Business Intelligence Content with the Oracle BI EE Contextual Event Action
  • 1.7.1 What Is the Definition of the QDR?
  • 1.7.2 What Is the Signature of the QDR?
• 1.8 Adding or Modifying a Presentation Services Connection After Deployment
  • 1.8.1 How to Add or Modify a Presentation Services Connection
    • 1.8.1.1 Adding or Modifying a Presentation Services Connection
• 1.9 Credentials for Connecting to the Oracle BI Presentation Catalog
  • 1.9.1 How to Create and Use Impersonate User
    • 1.9.1.1 Create the BIImpersonateUser
    • 1.9.1.2 Grant Permissions to BIImpersonateUser
    • 1.9.1.3 Restart Servers

2 Improving The Performance of ADF Applications That Contain Oracle BI EE Objects

• 2.1 Setting an Oracle BI Server Timeout
  • 2.1.1 How to Set the Oracle BI Server Timeout
  • 2.1.2 Examples of Timeout Settings
• 2.2 Adding a Session Timeout
  • 2.2.1 How to Add a Session Timeout
• 2.3 Using Static Resources
  • 2.3.1 How to Set Static Resources Preferences
  • 2.3.2 Testing The Static Resources Location

3 Adding BI Composer to ADF Applications

• 3.1 Overview of Using BI Composer with ADF Application
• 3.2 Adding BI Composer to an ADF Application
  • 3.2.1 Checking for Installed JDeveloper Extensions
  • 3.2.2 Installing the Required JDeveloper Extensions
  • 3.2.3 How to Add the BI Composer Library Reference
  • 3.2.4 How to Extend the Domain
  • 3.2.5 How to Add the Task Flow Parameters and Events
    • 3.2.5.1 BI Composer Wizard Editor Task Flow
    • 3.2.5.2 BI Composer Wizard Edit Events
    • 3.2.5.3 BI Composer Wizard Viewer Task Flow Parameters

4 Using the Oracle BI EE Logical SQL View Object

• 4.1 Introduction to the Oracle BI EE Logical SQL View Object
• 4.2 Oracle Business Intelligence Logical SQL View Object Use Cases
  • 4.2.1 Displaying Data from Logical SQL in an ADF-Rich User Interface Component
  • 4.2.2 Displaying Data from Logical SQL and Passing in a Runtime Parameter
  • 4.2.3 Displaying Data from the Online Transaction Processing Schema and Logical SQL Together in an ADF-Rich Component
  • 4.2.4 Creating a Master-Detail Relationship Between an Oracle Business Intelligence View Object and an Online Transaction Processing View Object
• 4.3 Creating an Oracle Business Intelligence Logical SQL View Object
  • 4.3.1 How to Create an Oracle Business Intelligence Logical SQL View Object
    • 4.3.1.1 Checking for Installed JDeveloper Extensions
    • 4.3.1.2 Installing the Required Business Intelligence JDeveloper Extensions
    • 4.3.1.3 Creating a BI JDBC Connection
    • 4.3.1.4 Initializing the ADF Project
    • 4.3.1.5 Creating the Business Intelligence View Object
    • 4.3.1.6 Modifying the Oracle Business Intelligence Logical SQL View Object's Behavior
• 4.4 Creating a BI JDBC Data Source
  • 4.4.1 How to Create a BI JDBC Data Source in Oracle WebLogic
  • 4.4.2 Configuring the BI JDBC Data Source for Impersonation

5 Integrating Oracle Business Intelligence Presentation Services With an Oracle WebCenter Portal Application

• 5.1 Overview of the Oracle BI Presentation Services and WebCenter Portal Application Integration
• 5.2 Creating a WebCenter Portal Application that Integrates with Oracle BI Presentation Services
• 5.3 Can I Add BI Composer to a WebCenter Portal Application or to WebCenter Portal: Spaces?
• 5.4 Adding BI Composer to a WebCenter Portal Application or to WebCenter Portal: Spaces
  • 5.4.1 Checking for Installed JDeveloper Extensions
  • 5.4.2 Installing the Required JDeveloper Extensions
  • 5.4.3 How to extend the WebCenter Portal domain
  • 5.4.4 How to Add the BI Composer Library Reference
  • 5.4.5 How to Add Task Flow Permission Security
  • 5.4.6 How to Specify the BI Composer WebCenter Portal Viewer and Editor Container Task Flow Parameters

Glossary

Index