Contents

Title and Copyright Information

Preface

• Documentation Accessibility
• Audience
• Conventions
• Related Documents

1 What's New in This Release

• 1.1 New Features in Oracle BI Applications Documented in This Guide
• 1.2 System Requirements and Certification

2 Oracle BI Applications Security

• 2.1 Introduction
  • 2.1.1 High Level Steps for Setting Up Security in Oracle BI Applications
  • 2.1.2 What Tools Configure Security in Oracle Business Intelligence Applications?
  • 2.1.3 What Security Levels Does Oracle BI Applications Use?
  • 2.1.4 What Security Providers Does Oracle BI Applications Use?
  • 2.1.5 What Is a Security Policy and Where Is it Maintained?
  • 2.1.6 Controlling User Access Using Roles
    • 2.1.6.1 Authorizing User Access Using Roles
    • 2.1.6.2 About Roles in Oracle BI Applications
  • 2.1.7 About Object-Level Security
  • 2.1.8 What Is Required to Run the ETL Process?
  • 2.1.9 Where Is Content Authenticated?
  • 2.1.10 Security Overview of Oracle BI Applications Configuration Manager and Functional Setup Manager
  • 2.1.11 About Permissions in DAC, Configuration Manager and Functional Setup Manager
    • 2.1.11.1 About Permissions in DAC
    • 2.1.11.2 About Permissions in Configuration Manager
    • 2.1.11.3 About Permissions in Functional Setup Manager
  • 2.1.12 Additional Sources of Information About Oracle BI Applications Security
• 2.2 About Security Configuration Tools in Oracle BI Applications
  • 2.2.1 Using Oracle Identity Management to Manage Users and Enterprise Roles
  • 2.2.2 Using Oracle Authorization Policy Manager to Configure Roles and Privileges
  • 2.2.3 Using Administration Tool to Configure Duty Role Permissions in the Oracle BI Repository
  • 2.2.4 Using the Oracle BI EE Administration Page to Configure Duty Role Privileges in the Oracle BI EE Presentation Server
• 2.3 Setting Up Security in Oracle BI Applications
  • 2.3.1 Creating Users and Assigning Them to Job Roles
  • 2.3.2 Assigning Enterprise Roles (or Job Roles) to Duty Roles
  • 2.3.3 Creating Duty Roles
  • 2.3.4 Granting Users Access to Oracle BI Applications Dashboards
  • 2.3.5 Understanding Oracle BI Applications Job Role Hierarchies
    • 2.3.5.1 Assigning Job Roles to Other Roles
    • 2.3.5.2 Oracle BI Applications Pre-Built Role Hierarchy
  • 2.3.6 Assigning Duty Role Permissions to Oracle BI Repository Subject Areas and Tables
  • 2.3.7 Assigning a Data Security Filter to a Duty Role
  • 2.3.8 Assigning Duty Role Privileges to Oracle BI Presentation Catalog Objects
• 2.4 Configuring SSL for Oracle BI Applications
  • 2.4.1 Configuring SSL for the Oracle BI EE Platform
  • 2.4.2 Configuring SSL for Oracle BI Applications
• 2.5 Mapping Roles to Secure Objects in the Oracle BI Repository and Oracle BI Presentation Catalog
• 2.6 Implementing GL Segment Security in Oracle BI Applications for Fusion Adaptor
  • 2.6.1 Introduction
  • 2.6.2 Configuring GL Segment Security
    • 2.6.2.1 Tree Segment Security Implementation
    • 2.6.2.2 Non-Tree Segment Security Implementation
• 2.7 Advanced Security Topics - About Data-Level Security
  • 2.7.1 Securing Dimensions
  • 2.7.2 Implementing Data-Level Security in the Oracle BI Repository
  • 2.7.3 About Pre-Configured Initialization Blocks Used for Data-Level Security in Oracle BI Applications
  • 2.7.4 About Data-Level Security Design in Oracle BI Applications

3 About Multi-Language Support

• 3.1 Introduction to Multi-Language Support
• 3.2 About Pseudo-Translations
• 3.3 About BI Applications Domains
• 3.4 About Dimension Translation Tables

4 Oracle Business Analytics Warehouse Naming Conventions

• 4.1 Naming Conventions for Oracle Business Analytics Warehouse Tables
• 4.2 Table Types for Oracle Business Analytics Warehouse
  • 4.2.1 Aggregate Tables in Oracle Business Analytics Warehouse
  • 4.2.2 Dimension Class Tables in Oracle Business Analytics Warehouse
  • 4.2.3 Dimension Tables in Oracle Business Analytics Warehouse
  • 4.2.4 Dimension Tables With Business Role-Based Flags
  • 4.2.5 Fact Tables in Oracle Business Analytics Warehouse
  • 4.2.6 Helper Tables in Oracle Business Analytics Warehouse
  • 4.2.7 Hierarchy Tables in Oracle Business Analytics Warehouse
  • 4.2.8 Mini-Dimension Tables in Oracle Business Analytics Warehouse
  • 4.2.9 Staging Tables in Oracle Business Analytics Warehouse
  • 4.2.10 Translation Tables in Oracle Business Analytics Warehouse
• 4.3 Internal Tables in Oracle Business Analytics Warehouse
• 4.4 Standard Column Prefixes in Oracle Business Analytics Warehouse
• 4.5 Standard Column Suffixes in Oracle Business Analytics Warehouse
• 4.6 System Columns in Oracle Business Analytics Warehouse Tables
• 4.7 Multi-Currency Support for System Columns
• 4.8 Oracle Business Analytics Warehouse Primary Data Values
• 4.9 About Multi-Language Support in the Oracle Business Analytics Warehouse
• 4.10 Oracle Business Analytics Warehouse Currency Preferences

5 Oracle BI Applications Patching

• 5.1 Introduction
• 5.2 What Is Included in Oracle BI Applications Patches?
• 5.3 Where Updates Are Made by Oracle BI Applications Patches?
• 5.4 Applying Oracle BI Applications Patches
  • 5.4.1 Applying an Oracle BI Applications Patch
    • 5.4.1.1 How to Apply Changes to JAZN Settings
  • 5.4.2 Applying an Oracle BI Applications Configuration Manager (ACM) Patch
• 5.5 Diagnosing Whether Oracle BI Applications Patches Are Applied Correctly
• 5.6 Rolling Back Failed Oracle BI Applications Patches
• 5.7 What Happens if Conflicts Are Detected When Applying an Oracle BI Applications Patch?
  • 5.7.1 Resolving Conflicts for Oracle BI Presentation Catalog Updates
  • 5.7.2 Resolving Conflicts for Oracle Business Intelligence Repository (RPD) Updates
• 5.8 Sample Patch Properties File

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