Find Courses Find Providers Providers - Promote Your Courses About Us

Oracle Discoverer 10g - Shahed Munir

Training Courses

Would you like to see more Databases courses?

Training course summary

Sponsored links

Course is Offered to Companies aswell as private individuals Introducing OracleAS Discoverer 10g Business Intelligence Tools Discoverer Components Connecting to Discoverer Plus Data Warehouse Versus Transactional Systems Using Discoverer with a Data Warehouse Online Help and Key Terminology The Discoverer Administrator The Training Database Creating Ad-hoc Queries Creating a Query: Workflow Using the Workbook Wizard Editing a Query Managing Queries Building and Executing Queries Controlling Query Execution Managing Worksheets Managing Workbooks Setting Query Management Options Customizing Display Properties Result Set Display Options Setting Default Worksheet Display Options Customizing Display Properties for The Current Worksheet Applying Conditions and Using Parameters Selecting and Applying Predefined Conditions Selecting and Applying User-Defined Conditions Creating a New Condition Nesting Conditions Using Parameters Creating Parameterized Conditions Creating Group Sorts and Applying Summary Functions Sorting Output: Overview Sorting and Grouping Data in Tables Sorting Data in Crosstabs Creating Totals and SubTotals Creating and Displaying Percentages Creating Calculated Items Identifying Types of Calculations Creating a Simple Calculation Building a Complex Calculation Using the Analytic Calculations Templates Creating Analysis Calculations Using Calculations in a Condition Passing a Parameter to a Calculation Scheduling and Managing Reports in Batch Mode Scheduling Workbooks Using Discoverer Plus The Scheduling Manager Window Analyzing Data with Drills Identifying the Drill Types Drill Up or Down Drilling to an External Application Analyzing Data Graphically Displaying Data Graphically Creating a New Graph Editing Graphs Customizing Graphs Using Pie Charts Exporting a Worksheet to Other Applications and Printing a Worksheet Exporting a Worksheet into Other Applications Exporting to Excel or HTML Exporting an Worksheet to an Excel Pivot Table Exporting to Oracle Reports in XML Format Printing a Worksheet Using the Print Wizard Introducing Oracle9iAS Discoverer Viewer Connecting to Oracle9iAS Discoverer Viewer Using the Main Features of Discoverer Viewer Setting Query Execution Options Setting Presentation Options Creating a Bookmark to a Worksheet Using Discoverer Viewer Introducing OracleAS Discoverer Viewer Connecting to Oracle9iAS Discoverer Viewer Discoverer Portlets Customizing Discoverer Portlets

Regions:
  • Midlands
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Intermediate

Further Details

Extra Course Available on Request: Introduction to Oracle Discoverer Administrator Discoverer in Oracle Platform Oracle's Business Intelligence Tools Discoverer Architecture Key Terminology The Role of the Data Administrator The Training Business Areas and Data Models Creating the End User Layer and Business Areas Discoverer Connections Creating and Editing Public and Private Connections Creating the Initial EUL Creating an Applications Mode EUL Designing Business Areas and Identifying and Selecting Objects to Load Creating a Business Area and Loading meta data Viewing Folder and Item Properties Exporting and Importing Creating Conditions, List of Values, and Alternative Sorts Item Classes Creating List of Values Creating an Alternative Sort Creating Conditions Customizing Properties, Creating Calculated Items and Registering PL/SQL Functions Customizing Folder Properties Customizing Item Properties Creating Simple and Complex Calculated Items Registering and Importing PL/SQL Functions Creating Complex and Custom Folders Creating Joins Join Options Creating Complex Folders Creating Custom Folders Custom LOV Creating Analytical and Aggregate Items Requirement for Analytical Functions Categories of Analytical Functions Creating Items with Analytical Functions Creating Aggregate Calculations Creating Drills Identifying end user drill facilities Creating an Item hierarchy by using Hierarchy Wizard Setting up a Hyperdrill Plug-in About Default Date Hierarchy Creating a Custom Date Hierarchy Creating a Non-standard Calendar Materialized Views and Summary Management Summary Tables and Folders Discoverer Summaries Materialized Views Uses of Materialized Views Requirements for Creating Summaries Methods for Creating Summary Folders Managing Summary Folders Summary Combination Strategies Automated Summary Management Automated Summary Management Wizard Analyzing Folders Setting Properties Allocating Space and Viewing Performance Managing Batch Scheduling How Batch Reports Works? Batch Repository User Versus Private User Changes that affect Batch Reports Setting up Scheduled Workbook Privileges Managing Scheduled Workbooks in Discoverer Administrator Unscheduling a Workbook Maintaining the End User Layer Effects of Database Changes Refreshing the Business Area Deleting Folders Deleting a Business Area Migrating fro Development to Production Analyzing the End User Layer Administering Multiple End User Layers and Automating Tasks Multiple EULs Creating an EUL for a New User Assigning a Default EUL Automating Tasks through the Command Line Interface Using the Oracle Discoverer EUL Command Line for Java Creating an EUL through the Command Line Interface Configuring Discoverer Overview of Oracle Application Server Architecture OracleAS Discoverer Architecture Customizing the Discoverer Viewer Look and Feel Managing the Discoverer Server Service Using the Application Server Control Configuring Discoverer through Application Server Control Web Cache Integration Portal Integration and Single Sign-On Overview of Single Sign-On Registering the Discoverer Portlet Provider Adding Discoverer Portlets to a Portal Page Customizing Portlets

Guide price

£1500pp - £2500pp inc admin

 

Sponsored links

Interested in this course?

 

 

Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net