Oracle BI Repository (RPD) Metadata Development & Administration Training

Course #: OBI11-1401

This 2-Day course teaches participants the best practices for modeling data sources through the Oracle BI metadata repository (RPD). Focused on the logical architecture backbone of Oracle BI, the activities in this course will engage each participant to understand the working architecture of the Oracle BI suite, but primarily the Oracle BI server, its metadata layer, and its system components. By the end of this course, participants will have an understanding of the Oracle BI architecture and how to build and deploy an RPD from scratch using the Oracle BI Administration Tool and Enterprise Manager.

This course follows the consistent training material framework from our BI/EPM University. Written by experts in Oracle BI and EPM products and developed to provide hands-on learning in a low-pressure, quick uptake environment, this course is consistent with the quality customers expect in a training partner.

Lessons Learned in this Course

Specifically, this course will teach participants how to work within the Oracle BI Administration Tool in order to build the enterprise common information metadata models that provide the central reference for all subject area (“Universe”) content accessible on dashboards and reports in the web-based portal. Participants will learn how to:

  • Start and Stop the OBIEE System
  • Build Metadata Models from Scratch
  • Understand Logic Table Sources
  • Understand Federation
  • Develop and Administer end-to-end OBIEE Metadata and Reporting Development

Day 1

  • Import Metadata
  • Connection Pools and DB Features
  • Business Model Design
  • Presentation Layer Design
  • Hierarchical Columns
  • Deploying the RPD
  • Securing Metadata Objects
  • Derived Metrics
  • Custom Calculated Metrics
  • Session Variables

Day 2

  • Horizontal and Vertical Federation
  • Repository Variables
  • Logical Table Sources and Ordering
  • Filter By and CASE statements
  • Calculation Wizard
  • Hierarchies (Parent-Child and Ragged/Skip)
  • Backup Strategies
  • Migration Strategies
  • Configuring the NQSConfig.INI file
  • Multi-User Development Environment (MUDE)
  • Row Level Security

To learn more about Datavail’s Oracle BI training and educational offerings, fill out the form to the right or call 1-877-634-9222 to speak with one of our business intelligence (BI) and data analytics experts today.