9iAS and Discoverer 4i Plus training will be broken down into three segments: 1) Setup and Connectivity for Discoverer 4i Plus, 2) Warehouse and Dimensional Strategy, and 3) Building and Executing a Query. This presentation will use an already established Oracle 9i database instance and an Oracle 9iAS instance.
Setup and Connectivity for Discoverer 4i Plus
This part of the presentation will be almost exclusively hands-on demonstration starting with setting up the user disco4. Then we will run through JInitiator installation, starting OracleDiscover4i service, modifying tnsnames.ora file, registering the collector, preferences, and the session.
Warehouse and Dimensional Design
We will review the terminology and schemas used in data warehousing. Then we will discuss best practices and an assessment of whether your company is ready for a business intelligence solution.
Building and Executing a Query
During this phase of the demonstration we will create a new workbook via the Workbook Wizard from the data warehouse tables, and select certain options for formatting and gridlines. We will then filter our results along with pivoting and changing the worksheet layout. During this discussion, we will address some common problems, including when and how to customize the crosstab reports for your environment.
