Oracle 9iAS Discoverer is a key component of the Oracle 9i Application server (Oracle 9iAS) in integrated business intelligence solution. Discoverer is the ad hoc tool for queries, reporting, analysis and publishing over the web. During this presentation, I will demonstrate how to setup and implement Oracle 9iAS Discoverer environment. This presentation will utilize an already established Oracle 9i database instance and an Oracle 9iAS instance. We will walk through how to create, modify and execute ad hoc queries as a Discoverer Analyst or Report Builder. We will then access these queries as if we were the casual user viewing and navigating our predefined reports and graphs. And last, but not least, we will export a crosstab report to MS Excel.