Skip Headers
Oracle® Fusion Middleware Reference Guide for Oracle Business Intelligence Applications
11
g
Release 1 (11.1.1)
Part Number E16816-06
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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 1 of This Guide
Updates to Revision 2 of 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 Oracle 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
Standard Column Prefixes in Oracle Business Analytics Warehouse
3.4
Standard Column Suffixes in Oracle Business Analytics Warehouse
3.5
System Columns in Oracle Business Analytics Warehouse Tables
3.6
Multi-Currency Support for System Columns
3.7
Oracle Business Analytics Warehouse Primary Data Values
3.8
About Multi-Language Support in the Oracle Business Analytics Warehouse
3.9
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
7
Customizing ETL Mappings for Oracle BI Applications
7.1
Overview of ETL Customization for Oracle BI Applications
7.2
Before You Begin ETL Customization for Oracle BI Applications
7.2.1
Understanding View Objects for Oracle Fusion Applications Sources
7.2.2
Upgrade Considerations
7.2.2.1
How Upgrade Impacts Mappings
7.2.3
Using Custom Folders in the Oracle Business Analytics Warehouse
7.2.4
Creating Custom Informatica Workflows
7.2.5
Additional Points to Consider When Customizing Oracle BI Applications
7.3
Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
7.3.1
About Extending Oracle Business Analytics Warehouse
7.3.2
High-Level Steps to Extend Oracle Business Analytics Warehouse
7.3.3
Example of Extending Oracle Business Analytics Warehouse
7.3.3.1
Example of Extracting Data from an Oracle Fusion Applications Source
7.3.3.2
Example of Loading Data into an Existing Target Table
7.3.3.3
Tips for Modifying the SQL Override in a Source Qualifier
7.4
Category 2 Customizations: Adding Additional Tables
7.4.1
About Creating New Dimension or Fact Tables
7.4.1.1
Required Columns
7.4.1.2
About the Oracle Business Analytics Warehouse DATASOURCE_NUM_ID Column
7.4.2
Adding a New Dimension in the Oracle Business Analytics Warehouse
7.4.3
Adding a New Fact Table in Oracle Business Analytics Warehouse
7.4.4
Adding a New Dimension Table for a New Fact Table in the Oracle Business Analytics Warehouse
7.5
Other Types of Customizations Requiring Special Handling
7.5.1
Adding Dimensions to Existing Facts
7.5.2
Adding Date Dimensions to Existing Facts
7.5.3
Adding Currencies to an Existing Table
7.6
Configuring Extracts
7.6.1
Extracting New Data Using an Existing Source Table
7.6.2
Extracting Data from a New Source Table
7.6.3
Configuring a Source Adapter Mapplet
7.7
Marking Records as "Deleted" in Oracle Business Analytics Warehouse
7.7.1
About Primary Extract and Delete Mappings
7.7.2
Working with Primary Extract and Delete Mappings
7.7.2.1
Retaining Source-Archived Records in Oracle Business Analytics Warehouse
7.7.2.2
Enabling Delete and Primary Extract Sessions
7.8
Configuring Slowly Changing Dimensions
7.8.1
About Identifying Historically Significant Attributes
7.8.1.1
About the Extract View
7.8.2
About Type 1 and Type 2 Slowly Changing Dimensions
7.8.2.1
Type 1 Slowly Changing Dimension
7.8.2.2
Type 2 Slowly Changing Dimension
7.8.2.3
Effective Dates
7.8.3
Modifying Type 2 Slowly Changing Dimensions
7.8.3.1
Enabling a Type 2 SCD Dimension
7.8.3.2
Extending the Logic That Triggers a Type 2 Change
7.9
About Resolving Dimension Keys
7.9.1
Resolving the Dimension Key Using Lookup
7.10
About Domain Values
7.10.1
About the Domain Value Conversion Process
7.10.1.1
Preparing to Define the Rules
7.10.2
About the Importance of Domain Values
7.10.2.1
Hire Count
7.10.2.2
Re-hires Ratio
7.10.2.3
New Hire Count
7.10.2.4
Newly Separated Veterans - New Hires
7.10.2.5
Other Protected Veterans - New Hires
7.10.2.6
Special Disabled Veteran Head count - New Hires
7.10.2.7
Vietnam Era Veteran Head count - New Hires
8
Oracle BI Applications Performance Tuning
8.1
Updating Row Counts on Oracle BI Server to Improve Performance
Index
Scripting on this page enhances content navigation, but does not change the content in any way.