Chapter 7. Developing the BI Server Repository

Finally, we get to the heart of the OBIEE system, the metadata repository that resides within the RPD file. The RPD contains all information regarding the physical tables that are held in our database or data warehouse, whether this is from a single source or a heterogeneous set of sources. It stores their relationships, additional business logic, and the structure of how columns are presented via the frontend to the dashboard creators. As well as physical database tables, the RPD can also utilize other data sources, such as Essbase, Oracle OLAP, and Excel sheets.

The RPD also holds variable definitions, various security and cache settings, and drill/dimensional hierarchies that affect the end functionality ...

Get Oracle Business Intelligence Enterprise Edition 12c - second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.