Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation and Other Resources
• Conventions

New Features for Oracle BI Metadata Repository Builders

• New Features for Oracle BI EE 12c (12.2.1.1.0)
• New Features for Oracle BI EE 12c Release (12.2.1.0)

1 Introduction to Building Your Metadata Repository

• About Oracle BI Server Architecture
• About Layers in the Oracle BI Repository
• Analyzing Your Business Model Requirements
• Identifying the Content of the Business Model
  • Identifying Logical Fact Tables
  • Identifying Logical Dimension Tables
  • Identifying Dimensions
    • About Dimensions with Multiple Hierarchies
  • Identifying Lookup Tables
• Identifying the Data Source Content for the Physical Layer
  • About Types of Physical Schemas in Relational Data Sources
  • About Cubes in Multidimensional Data Sources
  • Identifying the Data Source Table Structure
• Guidelines for Designing a Repository
  • Design Strategies for Structuring the Repository
  • Design Tips for the Physical Layer
  • Design Tips for the Business Model and Mapping Layer
    • Modeling Outer Joins
  • Design Tips for the Presentation Layer
• Topics of Interest in Other Guides
• System Requirements and Certification

2 Before You Begin

• About the Oracle BI Administration Tool
  • Opening the Administration Tool
  • Setting Administration Tool Options
    • Oracle BI Administration Tool General Options
    • Oracle BI Administration Tool Repository Options
  • Editing, Deleting, and Reordering Objects in the Repository
  • About Naming Requirements for Repository Objects
  • Changing Icons for Repository Objects
  • Sorting Objects in the Administration Tool
• About the Oracle BI Server Command-Line Utilities
• About Options in NQSConfig.INI
• About the SampleApp.rpd Demonstration Repository
• Download Repository Command
  • What You Need to Know Before Using the Command
• Using Online and Offline Repository Modes
  • Editing Repositories in Offline Mode
    • Opening Repositories in Offline Mode
    • Publish Offline Changes
  • Editing Repositories in Online Mode
    • Opening Repositories in Online Mode
    • Publishing Online Changes
    • Guidelines for Using Online Mode
  • Checking Out Objects
  • Checking In Changes
  • About Read-Only Mode
• Checking the Consistency of a Repository or a Business Model
  • About the Consistency Check Manager
  • Running the Consistency Check Manager
  • Using the validaterpd Utility to Check Repository Consistency
  • Common Consistency Check Messages

3 Setting Up and Using the Multiuser Development Environment

• About the Multiuser Development Environment
  • About the Multiuser Development Process
• Setting Up Projects
  • About Projects
  • Creating Projects
  • About Converting Older Projects During Repository Upgrade
• Setting Up the Multiuser Development Directory
  • Identifying the Multiuser Development Directory
  • Copying the Master Repository to the Multiuser Development Directory
  • Setting Up a Pointer to the Multiuser Development Directory
• Making Changes in a Multiuser Development Environment
  • About Changing and Testing Metadata
  • Making Changes to a Repository Using Projects
    • About Repository Project Checkout
    • Checking Out Projects
    • Using the extractprojects Utility
    • Refreshing the Local Project Extract
  • Making Changes to an Entire Repository
  • About Multiuser Development Options
• Publishing Changes to Multiuser Development Repositories
  • About the Multiuser Development Merge Process
    • How Are Multiuser Merges Different from Standard Repository Merges?
  • Publishing to the Network
  • Enforcing Consistent Repositories When Publishing Changes
• Branching in Multiuser Development
  • About Branching
  • Using the Multi-Team, Multi-Release Model in Oracle Business Intelligence
  • Synchronizing RPD Branches
• Viewing and Deleting History for Multiuser Development
  • Viewing Multiuser Development History
  • Deleting Multiuser Development History
• Setting Multiuser Development Options

4 Using a Source Control Management System for Repository Development

• About Using a Source Control Management System with the Administration Tool
  • About MDS XML
• Setting Up Your System for Repository Development Under Source Control Management
  • Creating an SCM Configuration File
  • Creating an MDS XML Repository and Checking In Files to the SCM System
    • Saving an Existing Repository File in MDS XML Format
    • Creating a New Repository in MDS XML Format
    • Linking to Source Control Files to Convert Your Repository (Small Repositories Only)
• Using Source Control Management in Day to Day Repository Development
  • Updating, Saving, and Checking In Changes for Repositories Under Source Control
  • Handling Errors
  • Testing Repositories Under Source Control
  • Viewing the Source Control Log
• Using Source Control Management with MUD
  • Putting the MUD Master Repository and MUD Log File Under Source Control
  • Checking In New Versions of the MUD Master and MUD Log File to Source Control
    • Manually Checking In the Updated MUD Master Repository and Log File
    • Using a Script to Check In the Updated MUD Master Repository and Log File

5 Importing Metadata and Working with Data Sources

• About Importing Metadata and Working with Data Sources
• Creating an Oracle BI Repository
• Performing Data Source Preconfiguration Tasks
  • Setting Up ODBC Data Source Names (DSNs)
  • Setting Up Oracle Database Data Sources
    • Oracle 12c Database In-Memory Data Sources
    • Oracle 12c on Exadata Data Sources
    • Advanced Oracle Database Features Supported by Oracle BI Server
    • Oracle Database Fast Application Notification and Fast Connection Failover
    • Additional Oracle Database Configuration for Client Installations
    • Configuring Oracle BI Server When Using a Firewall
    • DataDirect Drivers and Oracle Database
    • Oracle Database Connection Errors in Windows 7 64-bit Environments
  • About Setting Up Oracle OLAP Data Sources
  • Java Data Sources
    • Loading Java Data Sources
  • About Setting Up Oracle TimesTen In-Memory Database Data Sources
    • Configuring TimesTen Data Sources
    • Improving Use of System Memory Resources with TimesTen Data Sources
    • Configuring OBIS to Access the TimesTen DLL on Windows
  • About Setting Up Essbase Data Sources
  • About Setting up Cloudera Impala Data Sources
    • Obtaining Windows ODBC Driver for Client Installation
    • Importing Cloudera Impala Metadata Using the Windows ODBC Driver
  • About Setting Up Apache Hive Data Sources
    • Obtaining Windows ODBC Driver for Client Installation
    • Limitations on the Use of Apache Hive with Oracle Business Intelligence
      • Hive Limitation on Dates
      • Hive Does Not Support Count (Distinct M) Together with Group By M
      • Hive Does Not Support Differing Case Types
      • Exception Thrown for Locate Function with an Out-of-Bounds Start Position Value
      • Hive May Crash on Queries Using Substring
      • Hive Does Not Support Create Table
      • Hive May Fail on Long Queries With Multiple AND and OR Clauses
      • Queries with Subquery Expressions May Fail
      • Hive Does Not Support Distinct M and M in Same Select List
  • About Setting Up Hyperion Financial Management Data Sources
    • Performing Additional Hyperion Configuration for Client Installations
  • Setting Up SAP/BW Data Sources
  • Setting Up Oracle RPAS Data Sources
  • Setting Up Teradata Data Sources
    • Avoiding Spool Space Errors for Queries Against Teradata Data Sources
  • Enabling NUMERIC Data Type Support for Oracle Database and TimesTen
  • Configuring Essbase to Use a Shared Logon
  • Configuring SSO for Essbase, Hyperion Financial Management, or Hyperion Planning Data Sources
• Importing Metadata from Relational Data Sources
• Importing Metadata from Multidimensional Data Sources
  • Multidimensional Data Source Connection Options
  • About Importing Metadata from Oracle RPAS Data Sources
• About Importing Metadata from XML Data Sources
  • About Using XML as a Data Source
  • Importing Metadata from XML Data Sources Using the XML Gateway
    • Examples of XML Documents Generated by the Oracle BI Server XML Gateway
    • About Using HTML Tables as a Data Source
  • Importing Metadata from XML Data Sources Using XML ODBC
    • Example of an XML ODBC Data Source
  • Examples of XML Documents
• About Using a Standby Database with Oracle Business Intelligence
  • Configuring a Standby Database with Oracle Business Intelligence
  • Creating the Database Object for the Standby Database Configuration
  • Creating Connection Pools for the Standby Database Configuration
  • Updating Write-Back Scripts in a Standby Database Configuration
  • Setting Up Usage Tracking in a Standby Database Configuration
  • Setting Up Event Polling in a Standby Database Configuration
  • Setting Up Oracle BI Scheduler in a Standby Database Configuration

6 Working with ADF Data Sources

• What Are ADF Business Components?
  • About Operational Reporting with ADF Business Components
• About Importing ADF Business Components Into Oracle Business Intelligence
• About Specifying a SQL Bypass Database
• Setting Up ADF Data Sources
  • Creating a WebLogic Domain for ADF Business Components Used with Oracle Business Intelligence
  • Deploying OBIEEBroker as a Shared Library in Oracle WebLogic Server
  • Deploying the Application EAR File to Oracle WebLogic Server from JDeveloper
  • Setting Up a JDBC Data Source in the WebLogic Server
  • Setting the Logging Level for the Deployed Application in Oracle WebLogic Server
• Importing Metadata from ADF Data Sources
  • Performing an Initial Import from ADF Data Sources
  • Using Incremental Import to Propagate Flex Object Changes
  • Automatically Mapping Flex Object Changes to the Logical Model
    • Customizing the Mapping Behavior
    • Manually Mapping Flex Object Changes to the Logical Model
  • Automatically Mapping Flex Object Changes Using the biserverextender Utility
• Configuring SSL in Oracle WebLogic Server
  • Configuring One-Way SSL in Oracle WebLogic Server
  • Configuring Two-Way SSL in Oracle WebLogic Server
• Enabling the Ability to Pass Custom Parameters to the ADF Application
• Propagating Labels and Tooltips from ADF Data Sources
  • What are Labels and Tooltips?
  • About the Session Variable Naming Scheme for UI Hints
  • About Determining the Physical Column for a Presentation Column
  • About Initializing Session Variables Automatically for Propagating UI Hints
  • Using UI Hints From an Oracle ADF Data Source When Creating Analyses
  • Using XML Code in Initialization Blocks to Query UI Hints

7 Setting Up Database Objects and Connection Pools

• Setting Up Database Objects
  • About Database Types in the Physical Layer
  • Creating a Database Object Manually in the Physical Layer
  • When to Allow Direct Database Requests by Default
  • SQL Features Supported by a Data Source
  • Viewing Database Properties
  • Reviewing Supported Database Features
• About Connection Pools
  • About Connection Pools for Initialization Blocks
• Creating or Changing Connection Pools
  • Setting Connection Pool Properties in the General Tab
    • Common Connection Pool Properties in the General Tab
    • Multidimensional Connection Pool Properties in the General Tab
  • Setting Connection Pool Properties in the Connection Scripts Tab
  • Setting Connection Pool Properties in the XML Tab
  • Setting Connection Pool Properties in the Write Back Tab
  • Connection Pool Properties in the Miscellaneous Tab
    • Specifying Application Properties for JDBC (Direct Driver) or JDBC (JNDI) Data Sources
  • EXECUTE PHYSICAL DATABASE
• Setting Up Persist Connection Pools
  • Removing the Persist Connection Pool Property
  • About Setting the Buffer Size and Transaction Boundary
• List Connection Pool Command
• Update Connection Pool Command
• Using the BIServerT2PProvisioner.jar Utility to Change Connection Pool Passwords

8 Working with Physical Tables, Cubes, and Joins

• About Working with the Physical Layer
• Working with the Physical Diagram
• Creating Physical Layer Folders
  • Creating Physical Layer Catalogs and Schemas
    • Creating Catalogs
    • Creating Schemas
  • Using a Variable to Specify the Name of a Catalog or Schema
  • Setting Up Display Folders in the Physical Layer
• Working with Physical Tables
  • About Tables in the Physical Layer
  • About Physical Alias Tables
  • Creating and Managing Physical Tables and Physical Cube Tables
    • Creating or Editing Physical Tables
    • Creating Alias Tables
    • Setting Physical Table Properties for XML Data Sources
  • Creating and Managing Columns and Keys for Relational and Cube Tables
    • Creating and Editing a Column in a Physical Table
    • Specifying a Primary Key for a Physical Table
    • Deleting Physical Columns for All Data Sources
    • Viewing Physical Column Properties
  • Viewing Data in Physical Tables or Columns
• Working with Multidimensional Sources in the Physical Layer
  • About Physical Cube Tables
  • About Measures in Multidimensional Data Sources
    • About Externally Aggregated Measures
  • About Working with Physical Dimensions and Physical Hierarchies
    • Working with Physical Dimension Objects
    • Working with Physical Hierarchy Objects
      • Adding or Removing Cube Columns in a Hierarchy
  • Working with Cube Variables for SAP/BW Data Sources
  • Viewing Members in Physical Cube Tables
• Working with Essbase Data Sources
  • About Using Essbase Data Sources with Oracle BI
    • About Incremental Import
  • Working with Essbase Alias Tables
    • Determining the Value to Use for Display
    • Explicitly Defining Columns for Each Alias
  • Modeling User-Defined Attributes
  • Associating Member Attributes to Dimensions and Levels
  • Modeling Alternate Hierarchies
  • Modeling Measure Hierarchies
  • Improving Performance by Using Unqualified Member Names
• Working with Hyperion Financial Management and Hyperion Planning Data Sources
  • Importing Metadata From Hyperion Financial Management Data Sources
  • Importing Metadata From Hyperion Planning Data Sources
  • About Query Support for Hyperion Financial Management and Hyperion Planning Data Sources
• Working with Oracle OLAP Data Sources
  • About Importing Metadata from Oracle OLAP Data Sources
  • Working with Oracle OLAP Analytic Workspace (AW) Objects
  • Working with Oracle OLAP Dimensions, Hierarchies, and Levels
  • Working with Oracle OLAP Cubes and Columns
• Working with Physical Foreign Keys and Joins
  • About Physical Joins
    • About Primary Key and Foreign Key Relationships
    • About Complex Joins
    • About Multi‐Database Joins
    • About Fragmented Data
  • Defining Physical Joins with the Physical Diagram
  • Defining Physical Joins with the Joins Manager
• Deploying Opaque Views
  • About Deploying Opaque Views
  • Deploying Opaque View Objects
    • Using the Create View SELECT Statement
  • Undeploying a Deployed View
  • When to Delete Opaque Views or Deployed Views
  • When to Redeploy Opaque Views
• Using Hints in SQL Statements
  • How to Use Oracle Hints
    • About the Index Hint
    • About the Leading Hint
  • About Performance Considerations for Hints
  • Creating Hints
• Displaying and Updating Row Counts for Physical Tables and Columns
  • Displaying Row Counts in the Physical Layer

9 Working with Logical Tables, Joins, and Columns

• About Working with the Business Model and Mapping Layer
• Creating the Business Model and Mapping Layer
  • Creating Business Models
  • Automatically Creating Business Model Objects
  • Automatically Creating Business Model Objects for Multidimensional Data Sources
  • Duplicating a Business Model and Subject Area
• About Working with the Business Model Diagram
• Creating and Managing Logical Tables
  • Creating Logical Tables
    • Enabling Data Driven Fragment Selection in Logical Table Sources
  • Specifying a Primary Key in a Logical Table
  • Reviewing Foreign Keys for a Logical Table
• Defining Logical Joins
  • Defining Logical Joins with the Business Model Diagram
  • Defining Logical Joins with the Joins Manager
    • Creating Logical Joins with the Joins Manager
    • Creating Logical Foreign Key Joins with the Joins Manager
  • Specifying a Driving Table
  • Factors That Determine Join Trimming
  • Identifying Physical Tables That Map to Logical Objects
• Creating and Managing Logical Columns
  • Creating Logical Columns
  • Basing the Sort for a Logical Column on a Different Column
  • Enabling Double Column Support by Assigning a Descriptor ID Column
  • Creating Derived Columns
    • Configuring Logical Columns for Multicurrency Support
  • Setting Default Levels of Aggregation for Measure Columns
    • Setting Up Dimension-Specific Aggregate Rules for Logical Columns
    • Specifying Dimension-Specific Aggregation Rules for Multiple Logical Columns
    • Defining Aggregation Rules for Multidimensional Data Sources
  • Associating an Attribute with a Logical Level in Dimension Tables
  • Moving or Copying Logical Columns
• Enabling Write Back On Columns
• Setting Up Display Folders in the Business Model and Mapping Layer
• Modeling Bridge Tables
  • Creating Joins in the Physical Layer for Bridge and Associated Dimension Tables
  • Modeling the Associated Dimension Tables in a Single Dimension
  • Modeling the Associated Dimension Tables in Separate Dimensions
• Modeling Binary Large Object (BLOB) Data and Character Large Object (CLOB) Data

10 Working with Logical Dimensions

• About Working with Logical Dimensions
• Creating and Managing Dimensions with Level-Based Hierarchies
  • About Level-Based Hierarchies
    • About Using Dimension Hierarchy Levels in Level-Based Hierarchies
  • Manually Creating Dimensions, Levels, and Keys with Level-Based Hierarchies
    • Creating Dimensions in Level-Based Hierarchies
    • Creating Logical Levels in a Dimension
    • Associating a Logical Column and Its Table with a Dimension Level
      • Level-Based Measure Calculations
      • Grand Total Dimensional Hierarchy
    • Identifying the Primary Key for a Dimension Level
    • Selecting and Sorting Chronological Keys in a Time Dimension
    • Adding a Dimension Level to the Preferred Drill Path
    • Adding Sequence Numbers to a Time Dimension's Logical Level
  • Rules for Automatically Created Dimensions with Level-Based Hierarchies
  • Automatically Creating Dimensions with Level-Based Hierarchies
  • Populating Logical Level Counts Automatically
• Creating and Managing Dimensions with Parent-Child Hierarchies
  • About Parent-Child Hierarchies
    • About Levels and Distances in Parent-Child Hierarchies
    • About Parent-Child Relationship Tables
  • Creating Dimensions with Parent-Child Hierarchies
  • Defining Parent-Child Relationship Tables
  • Modeling Aggregates for Parent-Child Hierarchies
    • Storing Facts for Parent-Child Hierarchies
    • Aggregating Parent-Child Hierarchies
  • Adding the Parent-Child Relationship Table to the Model
  • Maintaining Parent-Child Hierarchies Based on Relational Tables
• Modeling Time Series Data
  • About Time Series Functions
    • About the AGO Function
    • About the TODATE Function
    • About the PERIODROLLING Function
  • Creating Logical Time Dimensions
    • Selecting the Time Option in the Logical Dimension Dialog
    • Setting Chronological Keys for Each Level
  • Creating AGO, TODATE, and PERIODROLLING Measures

11 Managing Logical Table Sources (Mappings)

• About Logical Table Sources
  • How Fact Logical Table Sources Are Selected to Answer a Query
  • How Dimension Logical Table Sources Are Selected to Answer a Query
    • Changing the Default Selection Criteria for Dimension Logical Table Sources
  • Consistency Among Data in Multiple Sources
• Creating Logical Table Sources
• Setting Priority Group Numbers for Logical Table Sources
• Defining Physical to Logical Table Source Mappings and Creating Calculated Items
  • Unmapping a Logical Column from Its Source
• Defining Content of Logical Table Sources
  • Verifying Joins from Dimension Tables to Fact Tables
  • About WHERE Clause Filters
• About Working with Parent-Child Settings in the Logical Table Source
• Setting Up Aggregate Navigation by Creating Sources for Aggregated Fact Data
• Setting Up Fragmentation Content for Aggregate Navigation
  • Specifying Fragmentation Content for Single Column, Value-Based Predicates
  • Specifying Fragmentation Content for Single Column, Range-Based Predicates
    • Specifying Multicolumn Content Descriptions
    • Specifying Parallel Content Descriptions
      • Examples of Parallel Content Descriptions
    • Specifying Unbalanced Parallel Content Descriptions
  • Specifying Fragmentation Content for Aggregate Table Fragments
    • Specifying the Aggregate Table Content
    • Defining a Physical Layer Table with a Select Statement to Complete the Domain
    • Specifying the SQL Virtual Table Content
    • Creating Physical Joins for the Virtual Table

12 Creating and Maintaining the Presentation Layer

• About the Presentation Layer
• Creating and Customizing the Presentation Layer
  • About Creating Subject Areas
    • Automatically Creating Subject Areas Based on Logical Stars and Snowflakes
  • About Removing Columns
  • Renaming Presentation Columns to User-Friendly Names
  • Exporting Logical Keys in the Subject Area
  • Setting an Implicit Fact Column in the Subject Area
  • Maintaining the Presentation Layer
• Working with Subject Areas
• Working with Presentation Tables and Columns
  • Creating and Managing Presentation Tables
  • Reordering Presentation Layer Tables
  • About Presentation Columns
    • Changing the Presentation Column Name
    • Reordering Presentation Columns
  • Nesting Folders in Answers and BI Composer
• Working with Presentation Hierarchies and Levels
  • Creating and Managing Presentation Hierarchies
    • Modeling Dimensions with Multiple Hierarchies in the Presentation Layer
    • Editing Presentation Hierarchy Objects
  • Creating and Managing Presentation Levels
• Setting Permissions for Presentation Layer Objects
  • Generating a Permission Report for Presentation Layer Objects
  • Sorting Columns in the Permissions Dialog
• Creating Aliases (Synonyms) for Presentation Layer Objects
• Controlling Presentation Object Visibility

13 Creating and Persisting Aggregates for Oracle BI Server Queries

• About Aggregate Persistence in Oracle Business Intelligence
• Aggregate Persistence Improvements
  • Surrogate Keys
  • Auto Correction (Hardening) of Level Keys
  • Unbalanced (Ragged) and Skip-Level Hierarchies
  • Chronological Keys
  • Count Distinct Measures
• About Aggregate Persistence Errors
• Identifying Query Candidates for Aggregation
• Using Oracle BI Summary Advisor to Identify Query Candidates for Aggregation
  • About Oracle BI Summary Advisor
    • Gathering Summary Advisor Statistics
    • Generating and Using Summary Advisor Recommendations
    • About Measure Subset Recommendations
  • Setting Up the Statistics Database
    • Columns in the S_NQ_SUMMARY_ADVISOR Table
  • Turning On Usage Tracking
  • Turning On Summary Advisor Logging
  • Generating an Aggregate Specification Script
    • Summary Advisor Stop Criteria Run Constraints
  • Using the nqaggradvisor Utility to Run the Oracle BI Summary Advisor
• Using the Aggregate Persistence Wizard to Generate the Aggregate Specification
• Using Model Check Manager to Check for Modeling Problems
  • About Model Check Manager
  • Running Model Check Manager
  • Resolving Model Errors
  • Checking Models Using the validaterpd Utility
• Writing the Create Aggregates Specification Manually
  • What Constraints Are Imposed During the Create Process?
  • Writing the Create Aggregates Specification
    • Delete Statement for Aggregate Specification
    • Create Statement for Aggregate Specification
    • Multiple Aggregates in Aggregate Specification
    • Where Clause for Aggregate Specification
  • Adding Surrogate Keys to Dimension Aggregate Tables
    • About the Create/Prepare Aggregates Syntax
    • About Surrogate Key Output from Create/Prepare Aggregates
• Running the Aggregate Specification Script
• Life Cycle Use Cases for Aggregate Persistence
• Using Double Buffering to Refresh Highly Available Aggregates
• Creating Aggregates on TimesTen Sources
  • Enabling PL/SQL for TimesTen
  • Enabling Performance Enhancement Features for TimesTen

14 Applying Data Access Security to Repository Objects

• About Data Access Security
  • Where to Find Information About Security Tasks
• Row-Level Security
  • Setting Up Row-Level Security
  • Data Filters
  • Setting Up Data Filters in the Repository
    • Specifying a Functional Group for an Application Role
  • Setting Up Row-Level Security in the Database
• Object Permissions
  • Setting Up Object Permissions
    • About Permission Inheritance for Users and Application Roles
• Overview of User and Application Role Commands
• Rename Application Role Command
• Delete Application Role Command
• Rename Users Command
• Delete Users Command
• Setting Query Limits
  • Accessing the Query Limits Functionality in the Administration Tool
  • Limiting Queries By the Number of Rows Received
  • Limiting Queries By Maximum Run Time and Restricting to Particular Time Periods
  • Allowing or Disallowing Direct Database Requests
  • Allowing or Disallowing the Populate Privilege
• About Applying Data Access Security in Offline Mode
  • Setting Up Placeholder Application Roles for Offline Repository Development

15 Completing Oracle BI Repository Setup

• Configuring the Repository for Oracle Scorecard and Strategy Management
  • Configuring the Repository for Comments and Status Overrides
• Saving the Repository and Checking Consistency
• Using nqcmd to Test and Refine the Repository
• Upload Repository Command
• Making the Repository Available for Queries
• Creating Data Source Connections to the Oracle BI Server for Client Applications
• Publishing to the User Community

16 Setting Up Data Sources on Linux and UNIX

• About Setting Up Data Sources on Linux and UNIX
• Settings for Data Source Connections Using Native Gateways
  • Sample obis.properties Entries for Oracle Database and DB2 (32-Bit)
  • Configuring Data Source Connections Using Native Gateways
• About Updating Row Counts in Native Databases
• Troubleshooting OCI Connections
• Using DataDirect Connect ODBC Drivers on Linux and UNIX
  • Configuring Oracle Business Intelligence to Use DataDirect
    • Additional DataDirect Configuration for Oracle Essbase
  • Configuring the DataDirect Connect ODBC Driver for Microsoft SQL Server Database
  • Configuring the DataDirect Connect ODBC Driver for MySQL Database
  • Configuring the DataDirect Connect ODBC Driver for Sybase ASE Database
  • Configuring the DataDirect Connect ODBC Driver for Informix Database
  • Configuring the DataDirect Connect ODBC Driver for Cloudera Impala Database
    • Configuring Impala 1.3.x to Include a LIMIT Clause
    • Modifying the Impala DefaultOrderByLimit Alternate Methods
• Configuring the DataDirect Connect ODBC Driver for Apache Hive Database
• Configuring Database Connections Using Native ODBC Drivers
  • Defining Dimension Tables as Not Normalized in Oracle RPAS ODBC Data Sources on AIX UNIX
• Setting Up Oracle TimesTen In-Memory Database on Linux and UNIX
• Configuring Oracle RPAS ODBC Data Sources on AIX UNIX
• Configuring Essbase Data Sources on Linux and UNIX
• Configuring DB2 Connect on IBM z/OS and s/390 Platforms

17 Managing Oracle BI Repository Files

• Comparing Repositories
  • Comparing Repositories Using the Compare Dialog
  • Comparing Repositories Using comparerpd
  • Turning Off Compare Mode
• Equalizing Objects
  • About Equalizing Objects
  • Using the Equalize Objects Dialog
  • Using the equalizerpds Utility
    • About Values for TypeName
• Merging Repositories
  • Performing Full Repository Merges
    • About Full Repository Merges
    • Performing Full Repository Merges With a Common Parent
    • Performing Full Repository Merges Without a Common Parent
  • Performing Patch Merges
    • About Patch Merges
    • Generating a Repository Patch
    • Applying a Repository Patch
      • Using patchrpd to Apply a Patch
• Querying and Managing Repository Metadata
  • Querying Related Objects
  • Querying the Repository
    • Constructing a Filter for Query Results
    • Query Filter Examples
  • Configuring the Repository for Large Complex Queries
• Changing the Oracle BI Repository Password
  • Changing the Oracle BI Repository Password Using the Administration Tool
  • Changing the Oracle BI Repository Password Using the obieerpdpwdchg Utility
• OBIS Metadata Compatibility

18 Using Expression Builder and Other Utilities

• Using Expression Builder
  • About the Expression Builder Dialogs
  • About the Expression Builder Toolbar
  • About the Categories in the Category Pane
  • Setting Up an Expression
    • Navigating Within Expression Builder
    • Building an Expression
    • About the INDEXCOL Conversion Function
• Using Administration Tool Utilities
  • Using the Replace Column or Table Wizard
  • Using the Oracle Business Intelligence Event Tables Utility
  • Using the Externalize Strings Utility
  • Using the Rename Wizard
  • Using the Update Physical Layer Wizard
  • Generating Documentation of Repository Mappings
  • Generating a Metadata Dictionary
  • Providing Access to Metadata Dictionary Information
  • Removing Unused Physical Objects
  • Persisting Aggregates
  • Using the Convert Presentation Folders Utility
  • Generating a List of Logical Column Types
    • Using the biservergentypexml Utility to Generate a List of Logical Column Types
    • Sample Output for a Logical Column Types Document
  • Comparing Logical Column Types
  • Fixing Upgrade IDs
  • Setting Permissions In Bulk
• Using the Calculation Wizard
• Associating S_NQ_ACCT Record with the BI Query Log

19 Using Variables in the Oracle BI Repository

• Working with Repository Variables
  • About Repository Variables
    • About Static Repository Variables
    • About Dynamic Repository Variables
  • Creating Repository Variables
    • Using Repository Variables in Expression Builder
• Working with Session Variables
  • About Session Variables
    • About System Session Variables
    • About Nonsystem Session Variables
  • Creating Session Variables
• Working with Initialization Blocks
  • About Using Initialization Blocks with Variables
    • Initializing Dynamic Repository Variables
    • Initializing Session Variables
    • About Row-Wise Initialization
      • Initializing a Variable with a List of Values
  • Creating Initialization Blocks
    • Assigning a Name and Schedule to Initialization Blocks
    • Selecting and Testing the Data Source and Connection Pool
      • Initialization Strings Used in Variables to Override Selection Steps
      • Examples of Initialization Strings
      • Testing Initialization Blocks
  • Variable Order in Initialization Blocks
    • Associating Variables with Initialization Blocks
  • Establishing Execution Precedence
  • When Execution of Session Variable Initialization Blocks Cannot Be Deferred
  • Enabling and Disabling Initialization Blocks
• Working with Multi-Source Session Variables
  • Example to Illustrate the Creation and Usage of Multi-Source Session Variables
• List Repository Variables Command
• Update Repository Variables Command

A Managing the Repository Lifecycle in a Multiuser Development Environment

• Planning Your Multiuser Development Deployment
  • About Business Organization and Governance Process Best Practices
  • About Technical Team Roles and Responsibilities
• Multiuser Development Architecture
  • About Multiuser Development Concepts
  • About Multiuser Development Styles
  • Multiuser Development Sandbox Architecture
  • Multiuser Development and Lifecycle Management Architecture
• Understanding the Multiuser Development Environment
  • About Multiuser Development Environment Task Flow
  • About Multiuser Development Projects
  • How to Create Branches
    • How to Create a Main Branch
    • How to Create a Side Branch
    • How to Create a Delegated Administration Branch
  • Which Merge Utility Should I Use?
• MUD Tips and Best Practices
  • Best Practices for Branching
  • Best Practices for Setting Up Projects
  • Best Practices for Three-Way Merges
  • Best Practices for MUD Merges
  • Best Practices for Two-Way Merges
  • Best Practices for Production Migration
  • Best Practices for Application Roles and Users
• Troubleshooting Multiuser Development

B MUD Case Study: Eden Corporation

• About the Eden Corporation Fictional Case Study
• Phase I - Initiating Multiuser Development (MUD)
  • Starting Initiative S
  • Setting Up MUD Projects
  • First Developer Checks Out
  • Second Developer Checks Out
  • First Developer Publishes Changes to the Master MUD Repository
  • Second Developer Publishes Changes to the Master MUD Repository
  • MUD Administrator Test Migration Activities
  • Phase I Testing
  • Phase I Migration to Production
  • Phase I Summary
• Phase II - Branching, Fixing, and Patching
  • Setting Up the Second Branch
  • Developers Check Out Projects
  • Patch Fix for the Main Branch
  • Finishing and Merging Phase II Branch
  • Phase II Summary
• Phase III - Independent Semantic Model Development
  • Security Considerations for Multiple Independent Semantic Models
  • HR Semantic Model Developer Builds Content
  • Phase III Summary

C Merge Rules

• About the Merge Process
• Merge Rules and Behavior for Full Merges
  • Special Merge Algorithms for Logical Table Sources and Other Objects
    • Merging Objects that Use the Vector Merge Algorithm
    • Merging Logical Table Sources
    • Merging Security Filters
    • Inferring the Use Logical Column Property for Presentation Columns
    • Merging Aliases
• Merge Rules and Behavior for Multiuser Development Merges
• Merge Rules and Behavior for Patch Merges
  • Using Patchrpd to Automate the Patch Process

D Deleting Unwanted Objects from the Repository

• About the Object Pruning Utility
• Using the Object Pruning Utility
  • Creating the Input File
  • Running the prunerpd Utility
• Deletion Rules for the Object Pruning Utility

E Data Types Supported by Oracle BI Enterprise Edition

• Data Type Categories Supported by Oracle BI EE
  • Textual Data
  • Numeric Data
  • Date and Time Data
  • Binary Data
• Using the NQSGetSQLDataTypes Procedure to Access Data Type Information
• Oracle BI EE Data Type Limitations
  • Floating Point Limitations
• Other Oracle BI Server Limitations
• Oracle Database to Oracle BI EE Data Type Mapping

F Exchanging Metadata with Databases to Enhance Query Performance

• About Exchanging Metadata with Databases
• Generating the Import File
  • Running the Generator
  • About the Metadata Input File
  • About the Output Files
  • Troubleshooting Errors from the Generator
  • Metadata Conversion Rules and Error Messages
    • Conversion Rules for Oracle Databases
    • Conversion Rules for IBM DB2 Databases
• Using Materialized Views in the Oracle Database with Oracle Business Intelligence
  • About Using the SQL Access Advisor with Materialized Views
  • Deploying Metadata for Oracle Database
    • Executing the SQL File for Oracle Database
    • Defining Constraints for the Existence of Joins
    • Creating the Query Workload
    • Creating Materialized Views
• Using IBM DB2 Cube Views with Oracle Business Intelligence
  • About Using IBM DB2 Cube Views with Oracle BI
  • Deploying Cube Metadata
    • Executing the Alias-SQL File for IBM Cube Views
    • Importing the XML File
      • Guidelines for Importing the XML File Using the IBM OLAP Center
      • Guidelines for Changing Cube Metadata After Importing the XML File
    • Guidelines for Creating Materialized Query Tables (MQTs)

G XML Schema Files for ADF Mapping Customizations

• app_segment_rule.xsd XML Schema File
• app_segment_rules_*.xml Example
• mapping_rules.xsd XML Schema File
• mapping_rules_*.xml Example

H Administration Tool Keyboard Shortcuts

• Menu Keyboard Shortcuts
• Dialog Keyboard Shortcuts
• Physical Diagram and Business Model Diagram Keyboard Shortcuts