Oracle Discoverer 4.1 Administration Edition

This 1-day course will teach students the purpose and capabilities of the Discoverer 4.1 Administration Edition tool.

This course teaches students how to use the Discoverer Administration Edition tool. This tool allows users to create an End User Layer, which serves as a metalayer between the data source and Discoverer. Students will also learn how to create and manage business areas, which will hide the complexity of the data source and provide a user-friendly view of the data for end users.

This course will present a thorough knowledge of the Discoverer Administration Edition tool. Thereafter each user can learn to apply this knowledge to the company's internal data model. Data administrators are in the best position to explain the company's data model.

Target audience

This course has been developed for data administrators using Discoverer on the Desktop. Administrators are required to attend the "Oracle Discoverer 4.1 Desktop User Edition" first. These first 2 days are crucial to understanding the Administration tool, and together make up the 3-day "Oracle Discoverer Administration" course

Course content

Creating and managing business areas Discoverer components • Installing the EUL • Starting Discoverer 4.1 Administration Edition • Using the Create EUL wizard • Deleting an end user layer • Creating a business area using the Load wizard • The work area • Managing business areas • Opening a business area • Closing business areas • Adding business areas • Deleting business areas • Business area properties • Online help

Working with folders and joins Working with folders • Adding folders with the Load wizard • Managing folders • Deleting folders • Creating custom folders • Adding an empty complex folder • Creating complex folders • Working with joins • Creating joins • Editing joins • Deleting joins • Join properties

Working with items and item classes Working with items • Creating calculated item classes • Editing items • Deleting items • Item properties • Registering PL/SQL functions • Item classes • Creating item classes with the Item Class wizard • The item classes tab • The effect of the item class • Editing item classes • Deleting item classes • Item class properties

Working with conditions and hierarchies Working with conditions • Creating conditions • Editing conditions • Deleting conditions • Condition properties • Working with hierarchies • Creating item hierarchies with the hierarchy wizard • Creating data hierarchies with the hierarchy wizard • The hierarchies tab • The effect of the date hierarchy • Editing hierarchies • Deleting hierarchies • Hierarchy properties

Security, privileges and summaries Business area security • Summaries and materialized views • Creating and maintaining summaries • Creating summaries with the summary wizard • Creating summaries using query performance statistics • Registering an external summary table • The summaries tab • Editing and refreshing summaries • Deleting summaries • Summary properties • What is automated summary management? • Accessing the underlying materialized view

Business area maintenance Exporting business areas • Importing business areas • Manage scheduled workbooks • Refreshing a business area • Setting the default EUL • Command line options

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today