Oracle - Oracle BI Discoverer Administrator 11g: Develop an EUL

PROKODA Gmbh
In Dresden und Düsseldorf

1.890 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Beschreibung

Oracle - Oracle BI Discoverer Administrator 11g: Develop an EUL: Teilnehmerkreis: Data Warehouse-Analytiker Entwickler Kursziele: Control user access to EUL, and business areas Create item classes, analytical and aggregate items, and drills Create summaries to improve query Manage multiple EULs Design, create, maintain, and customize the EUL.
Gerichtet an: Teilnehmerkreis: Data Warehouse-Analytiker Entwickler Kursziele: Control user access to EUL, and business areas Create item classes, analytical and aggregate items, and drills Create summaries to improve query Manage multiple EULs Design, create, maintain, and customize the EUL

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Dresden
Ostra-Allee 11, 1067, Sachsen, Deutschland
Plan ansehen
auf Anfrage
Düsseldorf
Kanzlerstraße 4, 40472, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen
auf Anfrage
Düsseldorf
Monschauer Str. 7, 40549, Nordrhein-Westfalen, NRW, Deutschland

Häufig gestellte Fragen

· Voraussetzungen

Erforderliche Vorkenntnisse: Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data Oracle BI Discoverer Plus 11 g : Analyze Relational and OLAP Data Oracle Database 11 g : SQL Fundamentals I Release 2 Oracle Database 11 g : SQL Fundamentals II Release 2 Empfohlene Vorkenntnisse: Oracle Database 11g: Data Warehousing Fundamentals Ed 1 Oracle Database 11 g :...

Themenkreis

KURSZIEL
Oracle - Oracle BI Discoverer Administrator 11g: Develop an EUL: Teilnehmerkreis:
  • Data Warehouse-Analytiker
  • Entwickler
Kursziele:
Control user access to EUL, and business areas
  • Create item classes, analytical and aggregate items, and drills
  • Create summaries to improve query
  • Manage multiple EULs
  • Design, create, maintain, and customize the EUL


ZIELGRUPPE
Teilnehmerkreis:
  • Data Warehouse-Analytiker
  • Entwickler
Kursziele:
Control user access to EUL, and business areas
  • Create item classes, analytical and aggregate items, and drills
  • Create summaries to improve query
  • Manage multiple EULs
  • Design, create, maintain, and customize the EUL


KURSINHALT
Oracle BI Discoverer Administrator is a component used by Discoverer managers (business or data administrators) to create, maintain, and administer data in the End User Layer (EUL), 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 to:
  • Create and customize the End User Layer
  • Create business areas and folders
  • Define analytical facilities for end users
  • Control the user access to the End User Layer
  • Use materialized views and automated summary management
  • Implement and administer Discoverer
  • Design, create, and maintain the EUL
  • Design effective business areas
  • Control user access to the EUL and business areas
  • Customize the EUL
  • Optimize query performance using summaries
Learn To:
  • Control user access to the EUL
  • Create item calsses, analytical and aggregate items, drills, and summaries
  • Design, create, maintain, and customize multiple EULs
This course is appropriate for Oracle Discoverer 10g audience too.
Sachgebiete:
Introduction to Oracle BI Discoverer Administrator: Develop an EUL
  • Oracle's BI Solution
  • Oracle's BI Solution Components
  • Oracle BI Discoverer Components
  • Discoverer Administrator
  • Role of the Discoverer Administrator
  • Key Terminology
  • Building a Business Area
  • Data Model
Creating the End User Layer and Business Areas
  • Discoverer Connections
  • Creating the EUL
  • Creating Folders and Business Areas
  • Importing and Exporting the EUL
  • EUL Security and Privileges
Creating Lists of Values (LOVs), Alternative Sorts, and Conditions
  • Creating Item Classes
  • Creating LOVs
  • Creating Alternative Sorts
  • Creating Conditions
  • About Optional Conditions
  • About Mandatory Conditions
  • Creating Advanced Conditions
Customizing Properties, Creating Calculated Items, and Registering PL/SQL Functions
  • Formatting Folders and Items
  • Customizing Folder Properties
  • About Indexed Item Properties
  • Creating a Simple Calculation
  • Creating a Complex Calculation
  • About PL/SQL Functions
Creating Complex and Custom Folders
  • Creating Joins
  • Creating Multi-item Joins
  • About Join Options
  • Creating Complex Folders
  • Assigning Items to Complex Folders
  • Complex Folder Reach-through
  • Creating a Custom Folder
  • Creating Custom LOVs
Creating Analytical and Aggregate Items
  • About Analytical Items
  • Using Analytical Functions
  • Administration Calculations
  • Types of Calculations
  • Derived Items
  • Aggregate Calculations
  • Derived Aggregate Calculations
  • Nested and User-defined Aggregates
Creating Drills
  • About Drill Structures
  • Creating Drills
  • Filtering Drills
  • Designing an Item Hierarchy
  • Creating Drill to Detail
  • About Date Hierarchies
  • Creating and Maintaining Date Hierarchies
  • Nonstandard Calendars
Creating and Managing Summary Folders
  • About Materialized Views
  • Summary Management
  • Creating Summary Folders Using EUL Items
  • About Database Storage
  • Creating Summary Folders Using Query Statistics
  • About External Summary Tables
  • Creating Summary Folders Using External Summary Tables
  • Summary Combination Strategies
Automated Summary Management (ASM)
  • About ASM
  • ASM Process
  • Executing ASM
  • Running ASM After Bulk Load
  • ASM Advanced Settings
Managing Batch Scheduling
  • Scheduling Workbooks
  • Managing Workbooks
  • About the Batch Reports Process
  • Creating a Batch Repository
  • Managing Scheduled Workbooks
Maintaining the EUL
  • Effects of Database Changes on Queries
  • Refreshing the Database and Business Areas
  • Managing Folders
  • About Orphaned Folders
  • Deleting Business Areas
  • Migrating from Development to Production
  • Support for Multiple Schemas
  • Workbooks for EUL Analysis
Administering Multiple EULs and Automating Tasks
  • Creating an EUL for a New User
  • Deleting an EUL
  • Installing the Sample Data
  • About Multiple EULs
  • Discoverer Administrator Command-line Interface
  • Using a Command File
  • Discoverer EUL Command-line for Java
Case Study

VORRAUSSETZUNG
Erforderliche Vorkenntnisse:
  • Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data
  • Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data
  • Oracle Database 11g: SQL Fundamentals I Release 2
  • Oracle Database 11g: SQL Fundamentals II Release 2
Empfohlene Vorkenntnisse:
  • Oracle Database 11g: Data Warehousing Fundamentals Ed 1
  • Oracle Database 11g: Data Warehousing Fundamentals

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen