Course : TRN 202 : Oracle BI EE Basic Administration
Overview : This course provides an introduction into administering Oracle BI EE 10g using the Oracle BI Administrator tool and the Oracle BI Presentation Server Administration site.
It takes delegates through the process of building an end-to-end semantic model, applying security to the model and then administering the Presentation Server Web Catalog.
Duration : 2 Days
Course Delivery : Instructor-led with labs, on-site at customer location
Who Should Attend : Developers, consultants, managers, technical leads, DBAs
Prerequisites : None
Detailed Course Agenda :
Day 1
1. Introduction to Oracle BI EE
2. Oracle BI EE 10g Basic Administration
- Architecture
- Star Schema Modeling
- Model first, 3NF Data Modeling
- Incorporating additional data sources
- Creating basic calculations
- Creating advanced calculations
- Creating time-series calculations
- Fragmentation
- Creating dimensions
- Creating level-based measures
- Renaming using the wizard
- Creating presentation models
- Advanced Modeling Issues (Circular joins, bridge tables, ragged hierarchies etc)
- Modeling flat structures (files, single tables)
Day 2
3. Modeling Multi-dimensional sources
- Multi-dimensional (OLAP) overview
- Importing OLAP data into BI Administrator
- Horizontal Federation of OLAP and relational data
4. Oracle BI Server Security
- Security overview and options
- Setting up filters using security manager
- LDAP security integration
- Presentation Model filters
To book this course for your organization, to customize this course or for more information, contact training@rittmanmead.com for more details.
Speak to us now to find out how we can help your BI project deliver.
T: +44 (0) 8446 697 995
T: (888) 631 1410 (USA)
