O'Reilly logo

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting by Yuli Vasiliev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required