OracleBI Discoverer Administrator 10g: Develop an EUL
What you will learn:
OracleBI Discoverer Administrator is a component used by Discoverer managers (business or data administrators) to create, maintain, and administer data in the End User Layer, and to define how users interact with that data. All the administrative tasks for the EUL objects (such as folders, business areas, summaries, and so on) can be performed using Discoverer Administrator.
As the Discoverer Manager, students learn how to create and customize the End User Layer. They also learn to create business areas and folders, and to define analytical facilities for end users. Students also learn how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management.
Learn To:
- Implement and administer Discoverer
- Design, create, and maintain the End User Layer
- Design effective business areas
- Control user access to the End User Layer, and business areas
- Customize the End User Layer
- Optimize query performance by using summaries
Audience:
- Business Intelligence Developer
- Business Analysts
Prerequisites:
Required Prerequisites:
- Familiarity with Microsoft Windows Applications
- Familiarity with Web browsers
- OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data
Course Objectives:
- Design, create, and maintain the End User Layer (EUL)
- Customize the EUL
- Design effective business areas
- Control user access to EUL, and business areas
- Export/ Import EUL, and business areas
- Create item classes
- Create analytical and aggregate items
- Create drills
- Create summaries to improve query performance
- Manage batch scheduling
- Manage multiple EULs
Course Topics:
Introduction to OracleBI Discoverer Administrator: Develop an EUL
Creating the End User Layer and Business Areas
- Public and Private End User Layers
- Security in an EUL
- Creating the Initial EUL
- Discoverer in Applications Mode
- Designing a Business Area
- Customizing a Business Area
- Creating a Business Area
- Exporting and Importing
Creating Lists of Values (LOVs), Alternative Sorts, and Conditions
- Creating an LOV
- Managing LOVs
- Creating an Alternative Sort
- Creating a Simple Condition
- Creating an Advanced Condition
- Creating item classes
Customizing Properties, Creating Calculated Items, and Registering PL/SQL Functions
- Viewing Default Folder and Item Properties
- Formatting Folders and Items
- Customizing Folder and Item Properties
- Calculated Items
- Registering PL/SQL Functions
Creating Complex and Custom Folders
- Creating Joins
- Managing Join Relationships
- Creating a Complex Folder
- Assigning Items to Complex Folders
- Optimizing SQL Generation
- Creating a Custom Folder
- Custom LOVs
Creating Analytical and Aggregate Items
- Using Analytical Functions
- Administration Calculations
- Types of Calculations
- User-Defined Aggregate Calculations
Creating Drills
- Drill Structures and Facilities
- Filtering Drills
- Drill to related items
- Drill to detail
- Designing and creating an Item Hierarchy
- Maintaining Item Hierarchies
- Creating a Date Hierarchy
- Maintaining Date Hierarchies
Creating and Managing Summary Folders
- Creating and Managing Summary Folders
- Requirements for Creating Summary Folders
- Requirements for Using Materialized Views
- Creating Summary
- Estimating Storage Space
- Registering External Summary Tables
- Editing Summary Folders
- Refreshing Summary Folders
- Viewing Summary Folder Properties
Automated Summary Management (ASM)
- ASM Policy
- Executing ASM
- Running ASM After Bulk Load
- Advanced Settings
Managing Batch Scheduling
- Scheduling Workbooks
- Opening and Managing Scheduled Workbooks
- Creating a Batch Repository User
- Setting the Repository User Property
- Managing Scheduled Workbooks
- Editing a Scheduled Workbook
- Viewing Scheduled Workbook Status
Maintaining the End User Layer
- Effects of Database Changes on Queries
- Refreshing the Database
- Refreshing the Business Area
- Managing Folders
- Deleting a Business Area
- Migrating from Development to Production
- Support for Multiple Schemas
Administering Multiple End User Layers and Automating Tasks
- Using the EUL Manager Wizard
- Creating an EUL for a New User
- Deleting an EUL
- Installing the Sample Data
- Uninstalling the Sample Data
- Multiple End User Layers
- Assigning a Default EUL
- Verifying the Default EUL
|
