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

Drilling from a graph


It's interesting to note that Discoverer enables you to drill from the graph associated with a worksheet. Continuing with the example in the preceding section, the graph associated with the worksheet you can see in the previous figure should look like this:

Looking to the right in the above graph, you may notice the Orddate: Year link, which you can click if you want to drill up to year figures. But how can you drill down to, say, month figures? The answer is you can double-click any graph bar to drill one step down. Thus, in this particular example, if you double-click a graph bar, you'll launch a drill-down from quarter data to monthly data. So the result worksheet would look like the following one:

The graph will also be automatically redrawn. This should look now like the following screenshot:

Each bar in the above graph represents figures associated with a particular month. In this particular example, this can be either January or March figures. To find out...

lock icon
The rest of the page is locked
Previous PageNext Page
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