Reader small image

You're reading from  Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting

Product typeBook
Published inOct 2010
PublisherPackt
ISBN-139781849681186
Edition1st Edition
Right arrow
Author (1)
Yuli Vasiliev
Yuli Vasiliev
author image
Yuli Vasiliev

Yuli Vasiliev is a software developer, freelance author, and consultant currently specializing in open-source development, Oracle technologies, and service-oriented architecture (SOA). He has over 10 years of software development experience as well as several years of technical writing experience. He wrote a series of technical articles for Oracle Technology Network (OTN) and Oracle Magazine. Contact Yuli Vasiliev
Read more about Yuli Vasiliev

Right arrow

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

lock icon
The rest of the page is locked
Previous PageNext Chapter
You have been reading a chapter from
Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting
Published in: Oct 2010Publisher: PacktISBN-13: 9781849681186

Author (1)

author image
Yuli Vasiliev

Yuli Vasiliev is a software developer, freelance author, and consultant currently specializing in open-source development, Oracle technologies, and service-oriented architecture (SOA). He has over 10 years of software development experience as well as several years of technical writing experience. He wrote a series of technical articles for Oracle Technology Network (OTN) and Oracle Magazine. Contact Yuli Vasiliev
Read more about Yuli Vasiliev