Contents

Title and Copyright Information

Preface

New Features for Oracle BI Metadata Repository Builders

1 Introduction to Building Your Metadata Repository

2 Before You Begin

3 Setting Up and Using the Multiuser Development Environment

4 Using a Source Control Management System for Repository Development

5 Importing Metadata and Working with Data Sources

6 Working with ADF Data Sources

7 Setting Up Database Objects and Connection Pools

8 Working with Physical Tables, Cubes, and Joins

9 Working with Logical Tables, Joins, and Columns

10 Working with Logical Dimensions

11 Managing Logical Table Sources (Mappings)

12 Creating and Maintaining the Presentation Layer

13 Creating and Persisting Aggregates for Oracle BI Server Queries

14 Applying Data Access Security to Repository Objects

15 Completing Oracle BI Repository Setup

16 Setting Up Data Sources on Linux and UNIX

17 Managing Oracle BI Repository Files

18 Using Expression Builder and Other Utilities

19 Using Variables in the Oracle BI Repository

A Managing the Repository Lifecycle in a Multiuser Development Environment

B MUD Case Study: Eden Corporation

C Logical SQL Reference

D Merge Rules

E Deleting Unwanted Objects from the Repository

F Data Types Supported by Oracle BI Enterprise Edition

G Exchanging Metadata with Databases to Enhance Query Performance

H XML Schema Files for ADF Mapping Customizations

I Administration Tool Keyboard Shortcuts

J Administration Tool User Interface Components

Glossary

Index