This Oracle BI 12c: Build Repositories training teaches you how to build and verify the three layers of an Oracle Business Intelligence (BI) repository, step-by-step. Expert Oracle University instructors will begin by teaching you how to use the Oracle BI Administration Tool to construct a simple repository.
By taking this course, you'll walk away with the ability to extend the initial repository and model more complex business requirements, including: logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. You will have developed the experience to use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, you'll be exposed to more advanced topics, like implicit fact columns, bridge tables, usage tracking, patch merge, and managing service instances.
Building the Physical Layer of a Repository
Building the Business Model and Mapping Layer of a Repository
Building the Presentation Layer of a Repository
Testing and Validating a Repository
Managing Logical Table Sources
Adding Calculations to a Fact
Working with Logical Dimensions
Enabling Usage Tracking
Using Model Checker and Aggregates
Using Partitions and Fragments
Using Repository Variables
Modeling Time Series Data
Modeling Many-to-Many Relationships
Setting an Implicit Fact Column
Importing Metadata from Multidimensional Data Sources
Managing Metadata and Working with Service Instances
Using Administration Tool Utilities
Performing a Patch Merge
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.