1
Introducing the Discoverer Administrator tutorial

Introducing the Discoverer Administrator tutorial

This tutorial uses a hypothetical chain of video rental stores as a business example, to show how to develop a business area using sales and inventory data. Your Discoverer Administrator software includes the video store demonstration database (VIDEO5) that this tutorial uses. This must be installed and populated with data before you begin the tutorial lessons.

For details about how you install the tutorial data, see Appendix A, "Installing the Discoverer tutorial EUL, data, and workbook".

This tutorial consists of a set of lessons that show you how to use the main features of Discoverer Administrator. Each lesson begins with an introduction and a list of exercises. Before you start each lesson, you may want to survey the list of exercises to get a sense of how much time you need to schedule for completing the lesson.

This tutorial consists of the following lessons:

• "Lesson 1: Creating a private End User Layer for a new tutorial database user"

• "Lesson 2: Connecting to Discoverer Administrator, using the Load Wizard and the Workarea"

• "Lesson 3: Granting access privileges"

• "Lesson 4: Modifying the business area"

• "Lesson 5: Working with custom folders"

• "Lesson 6: Creating joins"

• "Lesson 7: Customizing items"

• "Lesson 8: Designing a complex folder"

• "Lesson 9: Working with hierarchies"

• "Lesson 10: Creating summary folders to optimize performance"

To follow this tutorial you must be able to connect to Discoverer Administrator initially as a user with a DBA role (for more information, see your database administrator). The reason for doing this is because the tutorial requires that you create a new database user to run the tutorial. Normal use of Discoverer Administrator does not require DBA privileges.

Remember that the video store sample database is designed so that you already have read access to the tutorial tables. When you create your own business areas, you will need SELECT access to the database tables that you need to access. You will also need to know the names of the database users who own the data tables.

Remember that this tutorial is your introduction to Discoverer Administrator's basic features and procedures. When you are working with Discoverer Administrator outside the tutorial, you may find that you need more detailed explanations. You should find the Oracle Discoverer Administrator Administration Guide Help system to be a reliable, useful source of information.