Summary

While the preceding chapters discussed Business Intelligence through the prism of visual Oracle Business Intelligence tools such as Discoverer, this chapter stepped aside and looked at how to use SQL, a native tool of Oracle Database, to get answers to business questions based on the database data. In particular, you looked at the advanced SQL features designed to summarize data, such as ROLLUP and CUBE extensions of the GROUP BY clause in SELECT statements.

Turning back to the Business Intelligence components from the Oracle Business Intelligence suite discussed in the preceding chapters, this chapter shed some light on how the metadata used by Discoverer is organized in the underlying Oracle database. In particular, you looked at the database structures behind EULs, which are needed in order to work with Discoverer.

The next chapter will come back to the discussion of the Oracle Business Intelligence suite, providing a detailed look at its components. Aside from Discoverer Plus...