OBIEE Repositories Analyses Dashboards

OBIEE for Essbase – Repositories, Analyses and Dashboards

In this 5-day course students will learn how to federate business-critical data from various sources,including Essbase, by defining the three layers of an Oracle BI repository and presenting the results in meaningful formats to the decision makers. Based on a case study with step-by-step instructions, students will use the Oracle BI Administration Tool to reverse-engineer physical schemas, define logical business models and provide an end-user friendly presentation layer. They will become familiar with building physical and logical joins, defining simple and calculation measures, modeling logical dimension hierarchies and multiple logical table sources as well as setting up aggregate tables, partitions, and time series. To validate these tasks, students will create several analyses and review the query logs to gain a deeper understanding of the Oracle BI Server. After learning how to set up the BI Server, students will focus on analyzing the data and build more and more complex dashboards. The course also covers topics for Repository Management like Security, Caching, User Tracking, Localization and Multi-User Development.

Exercises are based on Essbase as one of the data sources, in addition to relational data sources. This course is for OBIEE version 11g.

Topics:

Introduction to the OBIEE Architecture, the BI Server and the Repository