OBIEE – Repositories OBIEE repository contains all metadata of the BI Server and is managed through the administration tool. It is used to store information about the application environment such as − Data Modeling Aggregate Navigation Caching Security Connectivity Information SQL Information The BI Server can access multiple repositories. OBIEE Repository can be accessed using […]

OBIEE – Presentation Layer Presentation layer is used to provide customized views of Business model in BMM layer to users. Subject areas are used in Presentation layer provided by Oracle BI Presentation Services. There are various ways you can create subject areas in Presentation layer. Most common and simple method is by dragging Business Model […]

OBIEE – Dimensional Modeling Dimensional modeling provides set of methods and concepts that are used in DW design. According to DW consultant, Ralph Kimball, dimensional modeling is a design technique for databases intended to support end-user queries in a data warehouse. It is oriented around understandability and performance. According to him, although transaction-oriented ER is […]