Chapter 15. Reporting Databases
"It's all about the database" - Anonymous.
No book on Oracle BI would be complete without introducing the concepts of a reporting database.
Just to be clear, Oracle Business Intelligence Enterprise Edition (OBIEE) is neither a database nor a storage system for data. OBIEE grabs data from a source (which is normally a database), and sends it to your screen (or e-mail, PDF, and so on) in a presentable format.
As discussed in previous chapters, the source data can be held in a variety of formats including, but not limited to, spreadsheets, tables, and XML. However, for most large implementations, a database is the only suitable source. If there are millions or even billions of data items, then a database is crucial. Moreover, a well-structured and well-maintained database is essential for the very survival of an OBIEE project. Size matters when it comes to design: the bigger the database, the better the design needs to be; otherwise it...