Table of Contents
- Title and Copyright Information
- Preface
-
Part I Get Started with Data
Modeling
- 1 About Oracle Analytics Server Data Modeling Tools
- 2 Introduction to Building Your Metadata Repository
-
3
Before You Begin
- Open the Administration Tool
- Set Administration Tool Options
- Edit, Delete, and Reorder Objects in the Repository
- About Name Requirements for Repository Objects
- Change Icons for Repository Objects
- Sort Objects in the Administration Tool
- About the Oracle BI Server Command-Line Utilities
- About Options in NQSConfig.INI
- Download Repository Command
- Use Online and Offline Repository Modes
- Check the Consistency of a Repository or a Business Model
-
Part II Build Your Metadata Repository
-
4
Set Up and Use the Multiuser Development Environment
- About the Multiuser Development Environment
- Set Up Projects
- Set Up the Multiuser Development Directory
- Make Changes in a Multiuser Development Environment
- Publish Changes to Multiuser Development Repositories
- Branch in Multiuser Development
- View and Delete History for Multiuser Development
- Set Multiuser Development Options
- 5 Use a Source Control Management System for Repository Development
-
6
Import Metadata and Working with Data Sources
- About Importing Metadata and Working with Data Sources
- Create an Oracle BI Repository
-
Perform Data Source Preconfiguration Tasks
- Set Up ODBC Data Source Names (DSNs)
-
Set 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
- Configure Oracle BI Server When Using a Firewall
- DataDirect Drivers and Oracle Database
- About Setting Up Oracle OLAP Data Sources
- Java Data Sources
- About Setting Up Oracle TimesTen In-Memory Database Data Sources
- About Setting Up Essbase Data Sources
- About Setting up Cloudera Impala Data Sources
-
About Setting Up Apache Hive Data Sources
- Obtain Windows ODBC Driver for Client Installation
-
Limitations on the Use of Apache Hive
- Hive Limitation on Dates
- Hive Doesn't Support Count (Distinct M) Together with Group By M
- Hive Doesn't 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 Doesn't Support Create Table
- Hive May Fail on Long Queries With Multiple AND and OR Clauses
- Queries with Subquery Expressions May Fail
- Hive Doesn't Support Distinct M and M in Same Select List
- About Setting Up Hyperion Financial Management Data Sources
- Set Up Oracle RPAS Data Sources
- Set Up Teradata Data Sources
- Enable NUMERIC Data Type Support for Oracle Database and TimesTen
- Configure Essbase to Use a Shared Logon
- Configure SSO for Essbase, Hyperion Financial Management, or Hyperion Planning Data Sources
- Import Metadata from Relational Data Sources
- Import Metadata from Multidimensional Data Sources
- About Importing Metadata from XML Data Sources
-
About Using a Standby Database
- Configure a Standby Database
- Create the Database Object for the Standby Database Configuration
- Create Connection Pools for the Standby Database Configuration
- Update Write-Back Scripts in a Standby Database Configuration
- Set Up Usage Tracking in a Standby Database Configuration
- Set Up Event Polling in a Standby Database Configuration
- Set Up Oracle BI Scheduler in a Standby Database Configuration
-
7
Work with ADF Data Sources
- What Are ADF Business Components?
- About Importing ADF Business Components
- About Specifying a SQL Bypass Database
-
Set Up ADF Data Sources
- Create a WebLogic Domain for ADF Business Components
- Deploy OBIEEBroker as a Shared Library in Oracle WebLogic Server
- Deploy the Application EAR File to Oracle WebLogic Server from JDeveloper
- Set Up a JDBC Data Source in the WebLogic Server
- Set the Logging Level for the Deployed Application in Oracle WebLogic Server
- Import Metadata from ADF Data Sources
- Configure SSL in Oracle WebLogic Server
- Enable the Ability to Pass Custom Parameters to the ADF Application
-
Propagate 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
- Use UI Hints from an Oracle ADF Data Source When Creating Analyses
- Use XML Code in Initialization Blocks to Query UI Hints
-
8
Set Up Database Objects and Connection Pools
- Set Up Database Objects
- About Connection Pools
- Create or Change Connection Pools
- Set Up Persist Connection Pools
- List Connection Pool Command
- Update Connection Pool Command
- Use the BIServerT2PProvisioner.jar Utility to Change Connection Pool Passwords
-
9
Work with Physical Tables, Cubes, and Joins
- About Working with the Physical Layer
- Work with the Physical Diagram
- Create Physical Layer Folders
- Work with Physical Tables
- Work with Multidimensional Sources in the Physical Layer
- Work with Essbase Data Sources
- Work with Hyperion Financial Management and Hyperion Planning Data Sources
- Work with Oracle OLAP Data Sources
- Work with Physical Foreign Keys and Joins
- Deploy Opaque Views
- Use Hints in SQL Statements
- Display and Update Row Counts for Physical Tables and Columns
-
10
Work with Logical Tables, Joins, and Columns
- About Working with the Business Model and Mapping Layer
- Create the Business Model and Mapping Layer
- About Working with the Business Model Diagram
- Create and Manage Logical Tables
- Define Logical Joins
-
Create and Manage Logical Columns
- Create Logical Columns
- Base the Sort for a Logical Column on a Different Column
- Enable Double Column Support by Assigning a Descriptor ID Column
- Create Derived Columns
- Set Default Levels of Aggregation for Measure Columns
- Associate an Attribute with a Logical Level in Dimension Tables
- Move or Copy Logical Columns
- Enable Write Back On Columns
- Set Up Display Folders in the Business Model and Mapping Layer
- Model Bridge Tables
- Model Binary Large Object (BLOB) Data and Character Large Object (CLOB) Data
-
11
Work with Logical Dimensions
- About Working with Logical Dimensions
-
Create and Manage Dimensions with Level-Based Hierarchies
- About Level-Based Hierarchies
-
Manually Create Dimensions, Levels, and Keys with Level-Based Hierarchies
- Create Dimensions in Level-Based Hierarchies
- Create Logical Levels in a Dimension
- Associate a Logical Column and Its Table with a Dimension Level
- Identify the Primary Key for a Dimension Level
- Select and Sort Chronological Keys in a Time Dimension
- Add a Dimension Level to the Preferred Drill Path
- Add Sequence Numbers to a Time Dimension's Logical Level
- Rules for Automatically Created Dimensions with Level-Based Hierarchies
- Automatically Create Dimensions with Level-Based Hierarchies
- Populate Logical Level Counts Automatically
- Create and Manage Dimensions with Parent-Child Hierarchies
- Model Time Series Data
-
12
Manage Logical Table Sources (Mappings)
- About Logical Table Sources
- Create Logical Table Sources
- Set Priority Group Numbers for Logical Table Sources
- Define Physical to Logical Table Source Mappings and Creating Calculated Items
- Define Content of Logical Table Sources
- About Working with Parent-Child Settings in the Logical Table Source
- Set Up Aggregate Navigation by Creating Sources for Aggregated Fact Data
- Set Up Fragmentation Content for Aggregate Navigation
-
13
Create and Maintain the Presentation Layer
- About the Presentation Layer
- Create and Customize the Presentation Layer
- Work with Subject Areas
- Work with Presentation Tables and Columns
- Work with Presentation Hierarchies and Levels
- Set Permissions for Presentation Layer Objects
- Create Aliases (Synonyms) for Presentation Layer Objects
- Control Presentation Object Visibility
-
14
Create and Persist Aggregates for Oracle BI Server Queries
- About Aggregate Persistence
- Aggregate Persistence Improvements
- About Aggregate Persistence Errors
- Identify Query Candidates for Aggregation
- Use Oracle BI Summary Advisor to Identify Query Candidates for Aggregation
- Use the Aggregate Persistence Wizard to Generate the Aggregate Specification
- Use Model Check Manager to Check for Modeling Problems
- Write the Create Aggregates Specification Manually
- Run the Aggregate Specification Script
- Lifecycle Use Cases for Aggregate Persistence
- Use Double Buffering to Refresh Highly Available Aggregates
- Create Aggregates on TimesTen Sources
- 15 Apply Data Access Security to Repository Objects
- 16 Complete Oracle BI Repository Setup
-
17
Set Up Data Sources on Linux
- About Setting Up Data Sources on Linux
- Settings for Data Source Connections Using Native Gateways
- About Updating Row Counts in Native Databases
- Troubleshoot OCI Connections
-
Use DataDirect Connect ODBC Drivers on Linux
- Configure Oracle Analytics Server to Use DataDirect
- Configure the DataDirect Connect ODBC Driver for DB2 Database
- Configure the DataDirect Connect ODBC Driver for MySQL Database
- Configure the DataDirect Connect ODBC Driver for Sybase ASE Database
- Configure the DataDirect Connect ODBC Driver for Informix Database
- Configure the DataDirect Connect ODBC Driver for Cloudera Impala Database
- Configure the DataDirect Connect ODBC Driver for Apache Hive Database
- Configure Database Connections Using Native ODBC Drivers
- Set Up Oracle TimesTen In-Memory Database on Linux
- Configure Essbase Data Sources on Linux
- 18 Manage Oracle BI Repository Files
-
19
Use Expression Builder and Other Utilities
- Use Expression Builder
-
Use Administration Tool Utilities
- Use the Replace Column or Table Wizard
- Use the Event Tables Utility
- Use the Externalize Strings Utility
- Use the Rename Wizard
- Use the Update Physical Layer Wizard
- Generate Documentation of Repository Mappings
- Generate a Metadata Dictionary
- Provide Access to Metadata Dictionary Information
- Remove Unused Physical Objects
- Persist Aggregates
- Use the Convert Presentation Folders Utility
- Generate a List of Logical Column Types
- Compare Logical Column Types
- Fix Upgrade IDs
- Set Permissions In Bulk
- Use the Calculation Wizard
- Associate S_NQ_ACCT Record with the Query Log
-
20
Use Variables in the Oracle BI Repository
- Work with Repository Variables
- Work with Session Variables
- Work with Initialization Blocks
- Work with Multi-Source Session Variables
- List Repository Variables Command
- Update Repository Variables Command
- 21 Manage the Repository Lifecycle in a Multiuser Development Environment
-
22
MUD Case Study: Eden Corporation
- About the Eden Corporation Fictional Case Study
-
Phase I - Initiate Multiuser Development (MUD)
- Start Initiative S
- Set 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 Test
- Phase I Migrate to Production
- Phase I Summary
- Phase II - Branch, Fix, and Patch
- Phase III - Independent Semantic Model Development
- 23 Merge Rules
- 24 Delete Unwanted Objects from the Repository
- 25 Data Types Supported by Oracle Analytics Server
- 26 Exchange Metadata with Databases to Enhance Query Performance
- 27 XML Schema Files for ADF Mapping Customizations
- 28 Administration Tool Keyboard Shortcuts
-
4
Set Up and Use the Multiuser Development Environment
- Part III Reference