Discoverer Ppt
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Discoverer Ppt as PDF for free.
More details
- Words: 1,368
- Pages: 25
A SEI-CMM
LEV E C o m pLa
ny
Oracle Discoverer
10/17/08
Satyam Computer Services Limited
1
5
A SEI-CMM
Introduction
LEV E C o m pLa
ny
About Discoverer: Discoverer is the end user adhoc query, reporting and analysis tool, which Provides quick development environment to develop Data Warehousing & Business intelligence reports
10/17/08
Satyam Computer Services Limited
2
5
A SEI-CMM
Discoverer Components
LEV E C o m pLa
ny
Discoverer Components: • Oracle Discoverer Administrator • Oracle Discoverer Plus / Discoverer 4i Plus • Oracle Discoverer 4i Viewer.
10/17/08
Satyam Computer Services Limited
3
5
A SEI-CMM
Features and Benefits
LEV E C o m pLa
ny
• Automated Summary Management - improving query performance in Discoverer Plus is now easier with this new feature. • Oracle Applications support - for users using Oracle Applications security. This enables you to connect to Oracle Applications EULs as well as standard Discoverer EULs. 10/17/08
Satyam Computer Services Limited
4
5
A SEI-CMM
Features and Benefits
LEV E C o m pLa
ny
Continued…. •Identifiers - all objects in a Business Area are now uniquely defined within each EUL by an Identifier. Import now uses Identifiers to match up identical EUL elements. •Change schema owner - you can now manually edit the schema Owner attribute (for a Folder) or leave it blank. 10/17/08
Satyam Computer Services Limited
5
5
A SEI-CMM
Features and Benefits
LEV E C o m pLa
ny
Continued…. •Support for Oracle 8i Materialized Views •Analytic Functions - perform complex mathematical analysis with this extended range of statistical functions.
10/17/08
Satyam Computer Services Limited
6
5
A SEI-CMM
EUL
LEV E C o m pLa
ny
• End User Layer is a Metadata repository for
Business areas, folders and items on which Discoverer workbooks or reports based on. • The EUL is a set of database tables that contain information (or 'metadata') about the other tables and views in the database. Note: A database can be Oracle, Oracle Applications or any RDBMS. 10/17/08
Satyam Computer Services Limited
7
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
• A Business Area is a set of folders containing
related information with a common business purpose. • Using Discoverer Administration Edition, you can tailor the grouping of data to provide users with the proper access to the precise data they need for ad hoc query, decision support, and presentation of results. 10/17/08
Satyam Computer Services Limited
8
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
• Business Areas:
•Meet the specific data needs of the users •Usually contain data from several different tables or views •Have tables or views and their associated columns mapped to “folders” and “items” respectively •Can contain many simple folders and complex folders 10/17/08
Satyam Computer Services Limited
9
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
Continued…
•May contain folders from one or more physical databases •Include conditions, joins, calculations, formatting, hierarchy structures, and other custom features 10/17/08
Satyam Computer Services Limited
10
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
Continued…
• May be accessible to one or many user IDs or roles; also, a user ID or role may be granted access to many business areas • Let users access data, without having to understand the database structure 10/17/08
Satyam Computer Services Limited
11
5
A SEI-CMM
Exporting and Importing Business Areas
LEV E C o m pLa
ny
•Discoverer Administration Edition enables you to export/import a business area to a file. •This can be useful when copying business areas between EULs or when archiving data.
10/17/08
Satyam Computer Services Limited
12
5
A SEI-CMM
Folders & Items
LEV E C o m pLa
ny
• Folders
The tables and views loaded into a Business Area. Folder Types - Simple, Complex and Custom • Items The Columns within a Table or View
10/17/08
Satyam Computer Services Limited
13
5
A SEI-CMM
Item Classes
LEV E C o m pLa
ny
• Groups of items that share similar properties • Used to enable the following: • List of Values • Alternative Sorts • Drill to Detail links
10/17/08
Satyam Computer Services Limited
14
5
A SEI-CMM
Joins
LEV E C o m pLa
ny
• A Join relates two folders using common items. • The Joins affect the combinations of items that can be selected during the following operations: 1. Creating a worksheet in Discoverer Plus. 2. Creating a Complex Folder in Discoverer Administration Edition. 10/17/08
Satyam Computer Services Limited
15
5
A SEI-CMM
Conditions
LEV E C o m pLa
ny
• Conditions filter worksheet data, enabling Discoverer end users to analyze only the data they are interested. • Conditions are applied to the folders or items
10/17/08
Satyam Computer Services Limited
16
5
A SEI-CMM
Calculations and Hierarchies
LEV E C o m pLa
ny
• A calculated item is an item that uses a formula to derive data for the item • Hierarchies are default drill paths between item that you define in Discoverer Administrator • There are two types of Hierarchy in Discoverer Administration Edition: 1. Item Hierarchies 2. Date Hierarchies 10/17/08
Satyam Computer Services Limited
17
5
A SEI-CMM
Summaries and Summary Folders
LEV E C o m pLa
ny
• A summary improves query performance in Discoverer Plus or Discoverer Viewer by using pre-aggregated data created through Discoverer Administration Edition. • A Summary Folder is how Discoverer represents the underlying structure of a summary table or MV. Each Summary Folder has one or more Items (i.e.columns from a summary table or MV). 10/17/08
Satyam Computer Services Limited
18
5
A SEI-CMM
Summary Folders
LEV E C o m pLa
ny
•Difference Between Summary Table and MV? •Discoverer - running against a pre-Oracle 8.1.6 database – Summary Table •Discoverer - running against an Oracle 8.1.6+ database – Materialized View •You can view Summary Folders from the Summaries tab in Discoverer Administration Edition 10/17/08
Satyam Computer Services Limited
19
5
A SEI-CMM
ASM
LEV E C o m pLa
ny
•Automated Summary Management – It delivers fast performing queries while greatly reducing the amount of time spent on administration. •ASM analyzes your tables, uses query statistics (when available) and default values (the summary policy) to determine how summaries are created for you. •ASM is able to automatically create and maintain the best set of summaries based on this combination. 10/17/08
Satyam Computer Services Limited
20
5
A SEI-CMM
Scheduling Workbooks
LEV E C o m pLa
ny
•Workbook scheduling is useful in the following situations: •The user has created a report that could take a long time to run - they can submit the report to run overnight and view the result in the morning. •The user wants to create a report that needs to be updated at regular intervals. 10/17/08
Satyam Computer Services Limited
21
5
A SEI-CMM
Security and Privileges
LEV E C o m pLa
ny
• One of your most important tasks, as a Discoverer Administrator, is defining the access permissions and task privileges allowed for each user or role. • Access permissions determine who can see and use the data in business areas. • Task privileges determine the tasks each user or role is allowed to perform.
10/17/08
Satyam Computer Services Limited
22
5
Using Discoverer with Oracle Applications
A SEI-CMM
LEV E C o m pLa
• The following Oracle Applications features are supported by Discoverer: • Access to Oracle Applications databases using Applications user names, passwords and responsibilities • Oracle Applications Multiple Organizations Note: These features are only available when Discoverer is running in Applications mode against an Oracle Applications Satyam mode EUL against23 an 10/17/08 Computer Services Limited Oracle Applications database.
ny
5
A SEI-CMM
Using Discoverer with Oracle Applications
LEV E C o m pLa
ny
5
• URL to access Discoverer Plus • http://oradba.satyam.com:8000/discwb4/html/engli htm
• URL for Discoverer Viewer • http://oradba.satyam.com:8000/discoverer4i/viewe
10/17/08
Satyam Computer Services Limited
24
A SEI-CMM
Thank You
LEV E C o m pLa
ny
Contact Details Name
: Vimala Srinivasan, Sai Sreenivas
Extension : 6622, 6662
All the best !!! 10/17/08
Satyam Computer Services Limited
25
5
LEV E C o m pLa
ny
Oracle Discoverer
10/17/08
Satyam Computer Services Limited
1
5
A SEI-CMM
Introduction
LEV E C o m pLa
ny
About Discoverer: Discoverer is the end user adhoc query, reporting and analysis tool, which Provides quick development environment to develop Data Warehousing & Business intelligence reports
10/17/08
Satyam Computer Services Limited
2
5
A SEI-CMM
Discoverer Components
LEV E C o m pLa
ny
Discoverer Components: • Oracle Discoverer Administrator • Oracle Discoverer Plus / Discoverer 4i Plus • Oracle Discoverer 4i Viewer.
10/17/08
Satyam Computer Services Limited
3
5
A SEI-CMM
Features and Benefits
LEV E C o m pLa
ny
• Automated Summary Management - improving query performance in Discoverer Plus is now easier with this new feature. • Oracle Applications support - for users using Oracle Applications security. This enables you to connect to Oracle Applications EULs as well as standard Discoverer EULs. 10/17/08
Satyam Computer Services Limited
4
5
A SEI-CMM
Features and Benefits
LEV E C o m pLa
ny
Continued…. •Identifiers - all objects in a Business Area are now uniquely defined within each EUL by an Identifier. Import now uses Identifiers to match up identical EUL elements. •Change schema owner - you can now manually edit the schema Owner attribute (for a Folder) or leave it blank. 10/17/08
Satyam Computer Services Limited
5
5
A SEI-CMM
Features and Benefits
LEV E C o m pLa
ny
Continued…. •Support for Oracle 8i Materialized Views •Analytic Functions - perform complex mathematical analysis with this extended range of statistical functions.
10/17/08
Satyam Computer Services Limited
6
5
A SEI-CMM
EUL
LEV E C o m pLa
ny
• End User Layer is a Metadata repository for
Business areas, folders and items on which Discoverer workbooks or reports based on. • The EUL is a set of database tables that contain information (or 'metadata') about the other tables and views in the database. Note: A database can be Oracle, Oracle Applications or any RDBMS. 10/17/08
Satyam Computer Services Limited
7
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
• A Business Area is a set of folders containing
related information with a common business purpose. • Using Discoverer Administration Edition, you can tailor the grouping of data to provide users with the proper access to the precise data they need for ad hoc query, decision support, and presentation of results. 10/17/08
Satyam Computer Services Limited
8
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
• Business Areas:
•Meet the specific data needs of the users •Usually contain data from several different tables or views •Have tables or views and their associated columns mapped to “folders” and “items” respectively •Can contain many simple folders and complex folders 10/17/08
Satyam Computer Services Limited
9
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
Continued…
•May contain folders from one or more physical databases •Include conditions, joins, calculations, formatting, hierarchy structures, and other custom features 10/17/08
Satyam Computer Services Limited
10
5
A SEI-CMM
Business Areas
LEV E C o m pLa
ny
Continued…
• May be accessible to one or many user IDs or roles; also, a user ID or role may be granted access to many business areas • Let users access data, without having to understand the database structure 10/17/08
Satyam Computer Services Limited
11
5
A SEI-CMM
Exporting and Importing Business Areas
LEV E C o m pLa
ny
•Discoverer Administration Edition enables you to export/import a business area to a file. •This can be useful when copying business areas between EULs or when archiving data.
10/17/08
Satyam Computer Services Limited
12
5
A SEI-CMM
Folders & Items
LEV E C o m pLa
ny
• Folders
The tables and views loaded into a Business Area. Folder Types - Simple, Complex and Custom • Items The Columns within a Table or View
10/17/08
Satyam Computer Services Limited
13
5
A SEI-CMM
Item Classes
LEV E C o m pLa
ny
• Groups of items that share similar properties • Used to enable the following: • List of Values • Alternative Sorts • Drill to Detail links
10/17/08
Satyam Computer Services Limited
14
5
A SEI-CMM
Joins
LEV E C o m pLa
ny
• A Join relates two folders using common items. • The Joins affect the combinations of items that can be selected during the following operations: 1. Creating a worksheet in Discoverer Plus. 2. Creating a Complex Folder in Discoverer Administration Edition. 10/17/08
Satyam Computer Services Limited
15
5
A SEI-CMM
Conditions
LEV E C o m pLa
ny
• Conditions filter worksheet data, enabling Discoverer end users to analyze only the data they are interested. • Conditions are applied to the folders or items
10/17/08
Satyam Computer Services Limited
16
5
A SEI-CMM
Calculations and Hierarchies
LEV E C o m pLa
ny
• A calculated item is an item that uses a formula to derive data for the item • Hierarchies are default drill paths between item that you define in Discoverer Administrator • There are two types of Hierarchy in Discoverer Administration Edition: 1. Item Hierarchies 2. Date Hierarchies 10/17/08
Satyam Computer Services Limited
17
5
A SEI-CMM
Summaries and Summary Folders
LEV E C o m pLa
ny
• A summary improves query performance in Discoverer Plus or Discoverer Viewer by using pre-aggregated data created through Discoverer Administration Edition. • A Summary Folder is how Discoverer represents the underlying structure of a summary table or MV. Each Summary Folder has one or more Items (i.e.columns from a summary table or MV). 10/17/08
Satyam Computer Services Limited
18
5
A SEI-CMM
Summary Folders
LEV E C o m pLa
ny
•Difference Between Summary Table and MV? •Discoverer - running against a pre-Oracle 8.1.6 database – Summary Table •Discoverer - running against an Oracle 8.1.6+ database – Materialized View •You can view Summary Folders from the Summaries tab in Discoverer Administration Edition 10/17/08
Satyam Computer Services Limited
19
5
A SEI-CMM
ASM
LEV E C o m pLa
ny
•Automated Summary Management – It delivers fast performing queries while greatly reducing the amount of time spent on administration. •ASM analyzes your tables, uses query statistics (when available) and default values (the summary policy) to determine how summaries are created for you. •ASM is able to automatically create and maintain the best set of summaries based on this combination. 10/17/08
Satyam Computer Services Limited
20
5
A SEI-CMM
Scheduling Workbooks
LEV E C o m pLa
ny
•Workbook scheduling is useful in the following situations: •The user has created a report that could take a long time to run - they can submit the report to run overnight and view the result in the morning. •The user wants to create a report that needs to be updated at regular intervals. 10/17/08
Satyam Computer Services Limited
21
5
A SEI-CMM
Security and Privileges
LEV E C o m pLa
ny
• One of your most important tasks, as a Discoverer Administrator, is defining the access permissions and task privileges allowed for each user or role. • Access permissions determine who can see and use the data in business areas. • Task privileges determine the tasks each user or role is allowed to perform.
10/17/08
Satyam Computer Services Limited
22
5
Using Discoverer with Oracle Applications
A SEI-CMM
LEV E C o m pLa
• The following Oracle Applications features are supported by Discoverer: • Access to Oracle Applications databases using Applications user names, passwords and responsibilities • Oracle Applications Multiple Organizations Note: These features are only available when Discoverer is running in Applications mode against an Oracle Applications Satyam mode EUL against23 an 10/17/08 Computer Services Limited Oracle Applications database.
ny
5
A SEI-CMM
Using Discoverer with Oracle Applications
LEV E C o m pLa
ny
5
• URL to access Discoverer Plus • http://oradba.satyam.com:8000/discwb4/html/engli htm
• URL for Discoverer Viewer • http://oradba.satyam.com:8000/discoverer4i/viewe
10/17/08
Satyam Computer Services Limited
24
A SEI-CMM
Thank You
LEV E C o m pLa
ny
Contact Details Name
: Vimala Srinivasan, Sai Sreenivas
Extension : 6622, 6662
All the best !!! 10/17/08
Satyam Computer Services Limited
25
5
Related Documents
Discoverer Ppt
November 2019 13
Discoverer
June 2020 14
Discoverer
June 2020 17
Discoverer Steps
November 2019 8
Discoverer Implementation
June 2020 14