Contents

Title and Copyright Information

Preface

• Documentation Accessibility
• Audience
• Conventions
• Related Documents

What's New in This Release

• New Features in Oracle BI Applications Documented in This Guide
• Updates to Revision 3 of This Guide
• Updates to Revision 4 of This Guide
• System Requirements and Certification

1 Oracle BI Applications Security

• 1.1 Introduction
  • 1.1.1 High Level Steps for Setting Up Security in Oracle BI Applications
  • 1.1.2 What Tools Configure Security in Oracle Business Intelligence Applications?
  • 1.1.3 What Security Levels Does Oracle BI Applications Use?
  • 1.1.4 What Security Providers Does Oracle BI Applications Use?
  • 1.1.5 What Is a Security Policy and Where Is it Maintained?
  • 1.1.6 Controlling User Access Using Roles
    • 1.1.6.1 Authorizing User Access Using Roles
    • 1.1.6.2 About Roles in Oracle BI Applications
  • 1.1.7 About Object-Level Security
  • 1.1.8 What Privileges Are Required to Run the ETL Process?
  • 1.1.9 Where Is Content Authenticated?
  • 1.1.10 Security Overview of Oracle BI Applications Configuration Manager and Functional Setup Manager
  • 1.1.11 About Permissions in DAC, Configuration Manager and Functional Setup Manager
    • 1.1.11.1 About Permissions in DAC
    • 1.1.11.2 About Permissions in Configuration Manager
    • 1.1.11.3 About Permissions in Functional Setup Manager
  • 1.1.12 Additional Sources of Information About Oracle BI Applications Security
• 1.2 About Security Configuration Tools in Oracle BI Applications
  • 1.2.1 Using Oracle Identity Management to Manage Users and Enterprise Roles
  • 1.2.2 Using Oracle Authorization Policy Manager to Configure Roles and Privileges
  • 1.2.3 Using Administration Tool to Configure Duty Role Permissions in the Oracle BI Repository
  • 1.2.4 Using the Oracle BI EE Administration Page to Configure Duty Role Privileges in the Oracle BI EE Presentation Server
• 1.3 Setting Up Security in Oracle BI Applications
  • 1.3.1 Creating Users and Assigning Them to Job Roles
  • 1.3.2 Assigning Enterprise Roles (or Job Roles) to Duty Roles
  • 1.3.3 Creating Duty Roles
  • 1.3.4 Granting Users Access to Oracle BI Applications Dashboards
  • 1.3.5 Understanding Oracle BI Applications Job Role Hierarchies
    • 1.3.5.1 Assigning Job Roles to Other Roles
    • 1.3.5.2 Oracle BI Applications Pre-Built Role Hierarchy
  • 1.3.6 Assigning Duty Role Permissions to Oracle BI Repository Subject Areas and Tables
  • 1.3.7 Assigning a Data Security Filter to a Duty Role
  • 1.3.8 Assigning Duty Role Privileges to Oracle BI Presentation Catalog Objects
• 1.4 Configuring SSL for Oracle BI Applications
  • 1.4.1 Configuring SSL for the Oracle BI EE Platform
  • 1.4.2 Configuring SSL for Oracle BI Applications
• 1.5 Mapping Roles to Secure Objects in the Oracle BI Repository and Oracle BI Presentation Catalog
• 1.6 Implementing GL Segment Security in Oracle BI Applications for Fusion Adaptor
  • 1.6.1 Introduction
  • 1.6.2 Configuring GL Segment Security
    • 1.6.2.1 Tree Segment Security Implementation
    • 1.6.2.2 Non-Tree Segment Security Implementation
• 1.7 Advanced Security Topics - About Data-Level Security
  • 1.7.1 Securing Dimensions
  • 1.7.2 Implementing Data-Level Security in the Oracle BI Repository
  • 1.7.3 About Pre-Configured Initialization Blocks Used for Data-Level Security in Oracle BI Applications
  • 1.7.4 About Data-Level Security Design in Oracle BI Applications

2 About Multi-Language Support

• 2.1 Introduction to Multi-Language Support
• 2.2 About Pseudo-Translations
• 2.3 About BI Applications Domains
• 2.4 About Dimension Translation Tables

3 Oracle Business Analytics Warehouse Naming Conventions

• 3.1 Naming Conventions for Oracle Business Analytics Warehouse Tables
• 3.2 Table Types for Oracle Business Analytics Warehouse
  • 3.2.1 Aggregate Tables in Oracle Business Analytics Warehouse
  • 3.2.2 Dimension Class Tables in Oracle Business Analytics Warehouse
  • 3.2.3 Dimension Tables in Oracle Business Analytics Warehouse
  • 3.2.4 Dimension Tables With Business Role-Based Flags
  • 3.2.5 Fact Tables in Oracle Business Analytics Warehouse
  • 3.2.6 Helper Tables in Oracle Business Analytics Warehouse
  • 3.2.7 Hierarchy Tables in Oracle Business Analytics Warehouse
  • 3.2.8 Mini-Dimension Tables in Oracle Business Analytics Warehouse
  • 3.2.9 Staging Tables in Oracle Business Analytics Warehouse
  • 3.2.10 Translation Tables in Oracle Business Analytics Warehouse
• 3.3 Internal Tables in Oracle Business Analytics Warehouse
• 3.4 Standard Column Prefixes in Oracle Business Analytics Warehouse
• 3.5 Standard Column Suffixes in Oracle Business Analytics Warehouse
• 3.6 System Columns in Oracle Business Analytics Warehouse Tables
• 3.7 Multi-Currency Support for System Columns
• 3.8 Oracle Business Analytics Warehouse Primary Data Values
• 3.9 About Multi-Language Support in the Oracle Business Analytics Warehouse
• 3.10 Oracle Business Analytics Warehouse Currency Preferences

4 Oracle BI Applications Patching

• 4.1 Introduction to Oracle BI Applications Patching
• 4.2 What Is Included in Oracle BI Applications Patches?
• 4.3 Where Updates Are Made by Oracle BI Applications Patches
• 4.4 Applying Oracle BI Applications Patches
  • 4.4.1 Applying an Oracle BI Applications Patch
    • 4.4.1.1 How to Apply Changes to JAZN Settings
  • 4.4.2 Applying an Oracle BI Applications Configuration Manager Patch
• 4.5 Diagnosing Whether Oracle BI Applications Patches Are Applied Correctly
• 4.6 Rolling Back Failed Oracle BI Applications Patches
• 4.7 What Happens if Conflicts Are Detected When Applying an Oracle BI Applications Patch?
  • 4.7.1 Resolving Conflicts for Oracle BI Presentation Catalog Updates
  • 4.7.2 Resolving Conflicts for Oracle BI Repository (RPD) Updates
• 4.8 Sample Patch Properties File

5 Moving Oracle BI Applications Components

• 5.1 About Moving Oracle BI Applications
• 5.2 Moving Oracle BI Applications Using the Full-Movement Scenario
  • 5.2.1 Preconditions for Moving an Oracle BI Applications Environment
  • 5.2.2 Moving the Informatica Repository
    • 5.2.2.1 Backing Up and Restoring the Informatica Repository
    • 5.2.2.2 Copying the Informatica Repository
  • 5.2.3 Moving Oracle BI Applications Configuration Manager Components
• 5.3 Moving Oracle BI Applications Using the Incremental-Movement Scenario
  • 5.3.1 Deploying Oracle BI Applications Into an Existing Pre-Production Environment
  • 5.3.2 Moving Oracle BI Applications Into an Existing Production Environment
    • 5.3.2.1 Setting Up the Oracle BI Applications Binary Components in Production
    • 5.3.2.2 Moving Oracle BI Applications Metadata Components Into Production

6 Configuring the Oracle BI Repository

• 6.1 How to Set Up Date-Specific Metrics
• 6.2 How to Set Up Additional Time Series Metrics for Oracle Business Analytics Warehouse
• 6.3 How to Set Up Additional Dimension Tables for Oracle Business Analytics Warehouse
• 6.4 How to Set Up Product Category Hierarchies
• 6.5 About the Period Ago Keys for Oracle Business Analytics Warehouse
• 6.6 About Oracle BI Time Repository Variables
• 6.7 About Configuring Usage Tracking for Oracle Business Analytics Warehouse
• 6.8 About the Incremental Deployment of the Oracle BI Applications Repository

Index