In this course students will gain an understanding of the Oracle BI EE architecture, with focus on the OBI repository. After learning about dimensional modelling, participants will understand the effort required to build and maintain a repository and its metadata layers (Physical, Business Model, Presentation). They will learn how to create hierarchies, manage security, caching and variables using best practices.