Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
Release 1 (11.1.1)
Part Number B32519-01
Title and Copyright Information
Oracle BI Discoverer Keyboard Navigation
Introduction to Administering Discoverer
What is Oracle Business Intelligence Discoverer?
What are the components of Oracle Business Intelligence Discoverer?
What is the role of the Discoverer manager
What tools does the Discoverer manager use?
What data sources can you use with Discoverer?
Basic concepts for Discoverer managers
What is business intelligence?
How does Discoverer work?
Where should I look for more information?
Part I Administering Discoverer with Multidimensional Datasources
Administering Discoverer Systems that Access Multidimensional Data Sources
What are the prerequisites for administering Discoverer systems that access multidimensional data sources?
What is online analytic processing (OLAP)?
What is a multidimensional data source?
What is the Discoverer Catalog?
How do I administer a Discoverer system that accesses multidimensional data sources?
About managing a Discoverer system that accesses multidimensional data sources
About administering Discoverer for multidimensional and relational data sources
Which tools are used to administer Discoverer systems that access multidimensional data sources?
How do I assist users of Discoverer Plus OLAP in getting started?
How do I enable access to the sample workbook?
How do I create a preprocessor program?
Why create a preprocessor program?
Arguments for the D4O_AUTOGO stored procedure
Example of creating a preprocessor program
Part II Administering Discoverer with Relational Datasources
Introduction to Administering Discoverer with a Relational Data Source
What is a relational data source, an OLTP system, and a data warehouse?
What is Oracle Business Intelligence Discoverer Administrator?
What are the fundamental concepts behind a Discoverer system when using a relational data source?
Introducing the End User Layer
Introducing business areas
Introducing folders and items
Introducing workbooks and worksheets
Introducing hierarchies and drills
Introducing summary folders
What is your role as Discoverer manager when using a relational data source?
What are the steps to a successful Discoverer implementation with a relational data source?
What is involved in maintaining a Discoverer system with a relational data source?
What are the prerequisites for using Discoverer Administrator?
What are the system prerequisites?
What are the data access prerequisites?
About Discoverer using database parameters
How to start Discoverer Administrator
What is the Workarea?
About the tabs in the Workarea window
About the context sensitive menus in the Workarea window
About the Administration Tasklist
What are the new features in Discoverer Administrator?
About Discoverer Administrator documentation and online help
Creating and Maintaining End User Layers
What is an End User Layer?
Why is the End User Layer useful?
What are End User Layer owners?
What privileges do you require to create an End User Layer in an Oracle database?
What privileges do you require to create an End User Layer in a non-Oracle database?
What privileges do you require to maintain an End User Layer?
What is the EUL Gateway?
How to create an End User Layer for an existing database user
How to create an End User Layer in a new database user
How to delete an End User Layer
How to view or change the default End User Layer
About copying EULs and EUL objects by exporting and importing
Which export/import method to use
About using the Discoverer Export Wizard and Import Wizard
About using Discoverer command-line interface to export/import EUL objects
About using database export/import commands to export/import complete EUL
How to export the entire EUL using the Discoverer Export Wizard
How to export selected business areas using the Export Wizard
How to export selected EUL objects using the Export Wizard
How to export End User Layer objects using the Discoverer command-line interface
How to import End User Layer objects using the Discoverer command-line interface
How to export an EUL using the standard database export utility
How to import an EUL using the standard database import utility
How to import EUL objects from a file using the Import Wizard
Notes about EUL creation and maintenance
What are identifiers?
What are the space requirements and storage parameters for a typical EUL?
What is a suggested workflow for initial EUL development and ongoing maintenance?
Using the Discoverer workbook dump utility
About creating EULs in Logical and Physical Standby (or read-only) databases
Creating and Maintaining Business Areas
What are business areas?
How to prepare to build a new business area
What is the Load Wizard?
How to create a business area using the Load Wizard
Loading from the online dictionary
Loading from a Gateway
Selecting tables and views
Specifying what Discoverer Administrator generates for the business area
Naming the business area, specifying object name and sorting options
How to open an existing business area when connecting to Discoverer Administrator
How to open an existing business area when connected to Discoverer Administrator
How to copy business areas between EULs
How to edit business area properties
How to delete a business area
How to synchronize a business area with the database
Notes about why a business area (or folders within it) might not be visible to a user
Creating and Maintaining Folders
What are folders?
What are simple folders?
What are complex folders?
What are the benefits of using complex folders instead of database views?
What are custom folders?
What are the differences between custom folders and simple folders?
Examples of custom folders
About dependencies between folders
About sharing folders across business areas
How to create simple folders from the database
How to create complex folders
How to create custom folders
How to edit folder properties
How to edit a custom folder's SQL statement
What is complex folder reach through?
How to define a complex folder to enable reach through to the base folders
What rules and restrictions apply when you use complex folder reach through?
What rules determine the availability of base folder items to end users?
Restrictions on joins in Discoverer Administrator when defining a base folder as reach through enabled?
Restrictions on summary folders in Discoverer Administrator when defining a base folder as reach through enabled?
Restrictions on Discoverer Plus and Desktop when building a worksheet using items from a reach through enabled base folder
Exceptions when Discoverer end users open and save workbooks that contain items from reach through enabled base folders?
What rules apply to complex folder reach through when you import EUL objects?
How to delete folders from a business area
How to assign folders to a business area
How to assign a folder to multiple business areas
How to view orphaned folders in the EUL
How to remove an orphaned folder from the EUL
How to sort folders in a business area
How to sort items in a folder
How to re-order folders in a business area
How to validate folders in a business area
Controlling Access to Information
About Discoverer and security
About Discoverer access permissions
About Discoverer and the Oracle Advanced Security Option (ASO)
About Discoverer task privileges
How to specify a user or role (responsibility) that can access a business area
How to specify the business areas a user or role (responsibility) can access
How to specify the tasks a user or role (responsibility) can perform
How to specify a user or role (responsibility) to perform a specific task
How to set query retrieval limits
How to set scheduled workbook limits
How to share Discoverer workbooks using a database role
About Transparent Application Failover
What is Transparent Application Failover?
What impact does Transparent Application Failover have on Discoverer users?
How to enable Discoverer support for Transparent Application Failover
Notes on Discoverer support for Transparent Application Failover
What are workbooks and scheduled workbooks?
Why schedule workbooks?
What happens when an end user schedules a workbook?
Where to store the results of scheduled workbooks?
What are the prerequisites for scheduling workbooks?
How to confirm that the DBMS_JOB package is installed
How to specify the owner of the tables containing scheduled workbooks results
How to grant the SELECT privilege on the synonym v$parameter to enable you to run scheduled workbooks
How to view and manage scheduled workbooks
Maintaining Items and Item Classes
What are items?
What are item classes?
What are lists of values?
About setting up lists of values
What are alternative sorts?
Examples of different ways to implement alternative sorts
Example 1: Using a custom folder to implement alternative sorts
Example 2: Using a database table to implement alternative sorts
Example 3: Using a calculated item and a DECODE statement to implement alternative sorts
What is drill to detail?
About setting up drill to detail
What are date items?
What are date format masks?
About truncating date items and the EUL_DATE_TRUNC function
About applying conditions to truncated date items
About drilling out to other applications
About generating and updating EUL item names automatically
What are primary and secondary elements?
What does the Auto-Generate Name property do?
How to set the value of the Auto-Generate name property of a secondary element
How to set the default value of the Auto-Generate name property to Yes
What happens when you create a business area using the Load Wizard?
How to set the Auto-Generate name property to Yes for all secondary elements in an existing business area
Notes about the Auto-Generate Name property
How to edit item properties
How to create a LOV item class
How to create an alternative sort item class
How to create a drill to detail item class
How to create a list of values using a custom folder
How to edit an item class
How to add items to an item class
How to add items to an item class using drag and drop
How to add items to an item class using the Edit Item Class dialog
How to add items to an item class using the Item Properties dialog
How to remove items from an item class
How to remove items from an item class using a popup menu
How to remove items from an item class using the Edit Item Class dialog
How to remove items from an item class using the Item Properties dialog
How to view the items that use an item class
How to view the list of values for an item
How to view the list of values for an item class
How to delete items and item classes
About improving performance when end users select parameter values in worksheets
How to assign an indexed item to an item
Notes about items based on columns with user-defined datatypes
Part III Introduction to Administering Discoverer
Creating and Maintaining Joins
What are joins?
What are single item joins?
What are multi-item joins?
About joining more than two folders
What are non-equi-joins?
What are one-to-many joins, one-to-one joins, and many-to-many joins?
About joining two folders using more than one join
What effect do joins have on query results and query performance?
Examples of how joins can affect query results from complex folders
What are outer joins?
How to create joins
How to view or edit joins
How to delete a join
What are fan traps, and how does Discoverer handle them?
Example of a fan trap
What to do if you set up a fan trap inside a complex folder
What to do if you have a data type mismatch in a join
Example of how to create a join between two items that have mismatched data types
Step 1: Create a new item that converts the Day of Week item from a varchar to a date data type
Step 2: Create a join using the new item
Creating and Maintaining Calculated Items
What are calculated items?
What are derived items?
What are aggregate calculated items?
What restrictions apply to aggregate calculated items?
What are the differences in behavior between analytic functions and aggregate calculated items?
What are aggregate derived items?
Example of an aggregate derived item
How to create calculated items
How to edit calculated item properties
How to edit calculated items
How to delete calculated items
How to create a calculated item that enables end users to drill out from one worksheet to display another worksheet in Discoverer Viewer
Why do you need PL/SQL functions?
What are custom PL/SQL functions?
About registering custom PL/SQL functions
How to register custom PL/SQL functions automatically
How to register custom PL/SQL functions manually
Creating and Maintaining Conditions
What are conditions?
About condition categories
How do conditions work in Discoverer?
What are the different types of condition?
How to create simple conditions
How to create advanced conditions
How to edit conditions
How to edit condition properties
How to delete conditions
Example 1: Using a condition to find data for the year 2002
Example 2: Using a condition to find sales in the last seven days
Example 3: Using a condition to find shipments in Quarter 3
About outer joins and the DisableAutoOuterJoinsOnFilters registry setting
Example 1: No condition applied
Example 2: Condition applied to query and DisableAutoOuterJoinsOnFilters set to 1 (switched off)
Example 3: Condition applied to query and DisableAutoOuterJoinsOnFilters set to 0 (switched on)
How to create row level security using a mandatory condition
How to enable summary folders if a source folder includes a mandatory condition
Creating and Maintaining Hierarchies
What are hierarchies?
What are item hierarchies?
What are date hierarchies?
What are date hierarchy templates?
About date hierarchies and performance
Example of how a date hierarchy can affect performance in Discoverer Plus
Example of how performance can be retained
How to create item hierarchies
How to create date hierarchies and templates
How to edit item hierarchies
How to edit date hierarchy templates
How to apply a date hierarchy template to a date item
How to set the default date hierarchy template
How to delete item hierarchies or date hierarchy templates
How to modify default date hierarchies that use date format 'RR' following upgrade to Oracle Business Intelligence Discoverer Administrator
About creating a hierarchy using the CONNECT BY clause in a custom folder
How to create a hierarchy with a custom folder and the CONNECT BY clause, using the emp table from the scott schema
Managing Summary Folders
About folders and summary folders in Discoverer
What are summary folders?
What are Discoverer summary tables?
What are materialized views?
What is Automated Summary Management (ASM)
How does ASM work?
What are the prerequisites for creating summary folders with ASM?
What are the different ways to run ASM and when do you use them?
What is the ASM policy?
Why must you refresh summary data?
What happens when a summary folder is refreshed?
How to run ASM using the Summary Wizard
How to run ASM after bulk load using the Load Wizard
How to run ASM using the command-line interface
How to run ASM using a batch file and the operating system scheduler
How to configure the database for summary folders
How to confirm that DBMS_JOB is installed for summary management
How to use SQL*Plus to grant the privileges required to create summary folders
How to determine and reset tablespace quotas
How to check object/schema name
Creating Summary Folders Manually
What is manual summary folder creation?
What are the prerequisites for creating summary folders manually in Discoverer?
What are summary combinations?
What to consider when defining summary combinations?
Guidelines for setting up summary combinations
When will an expression use a summary folder?
How to create summary folders based on items in the EUL
How to create summary folders based on users' queries
How to create summary folders based on external summary tables
How to manually refresh a summary folder
How to edit the properties of summary folders
How to edit summary folders
How to edit database storage properties of summary combinations for a summary folder
How to delete summary folders
How to view the status of the summary tables/materialized views for a summary folder
Additional Information about Summary Folders
What is the context and future for Discoverer's use of summary tables/materialized views?
What is query rewrite?
What are the conditions for query rewrite by Discoverer?
About viewing the SQL and execution plan for query rewrite in Discoverer
About configuring how Discoverer displays SQL in the SQL Inspector dialog
Examples of execution plan (in Discoverer) using/not using a materialized view
Example of the SQL (in Discoverer) where Discoverer rewrites the query
Example illustrating the advantages of rewriting a query to use a summary table
What characteristics differ between summary folders in Oracle Standard Edition databases and Oracle Enterprise Edition databases?
What is different about summary folders that are based on external summary tables?
What is different between mapping external summary tables and views to EUL items, with Oracle Enterprise Edition databases?
Why can you register only one materialized view against a single external summary table in Oracle Enterprise Edition databases?
About refresh options for Oracle Enterprise Edition databases
About refreshing summary folders following import between Oracle databases
Using Discoverer with Oracle Applications
What are Oracle Applications?
What are Oracle Applications responsibilities?
What features does Discoverer support for Oracle Applications users?
What are the prerequisites for using Discoverer with Oracle Applications?
What is different about running Discoverer in Oracle Applications mode?
Differences with the Discoverer Connect dialog in Oracle Applications mode
Differences with Discoverer security in Oracle Applications mode
Differences with Discoverer summary folders in Oracle Applications mode
Differences with Discoverer and secure views/language settings in Oracle Applications mode
How to configure the Connect dialog for Oracle Applications users
How to create an Oracle Applications EUL
Which user should maintain an Oracle Applications EUL?
How to enable an Oracle Applications user to maintain an Oracle Applications EUL
How to specify the Oracle Applications users/responsibilities who can access a business area
How to specify the business areas that an Oracle Applications user/responsibility can access
How to specify the tasks an Oracle Applications user or responsibility can perform
How to specify the Oracle Applications users/responsibilities who can perform a specific task
How to display your Oracle Applications database user name and responsibility in a workbook
Using Discoverer with Components of Oracle Fusion Middleware
Using Discoverer with Oracle Fusion Middleware Control
Using Discoverer with Oracle Reports
Using Discoverer with Oracle Web Cache
Using Discoverer with Oracle Warehouse Builder
Using Discoverer with OracleAS Single Sign-On Server
Using Discoverer with Oracle Portal
EUL Status Workbooks
What are EUL status workbooks?
About the Discoverer EUL V5 business area
How to install the standard EUL status workbooks
How to install Oracle Applications EUL status workbooks
How to run Oracle Applications EUL status workbooks
How to uninstall the Discoverer EUL V5 business area
About the EUL Data Definition workbook
About the EUL Query Statistics workbook
About the EUL Access workbook
About the EUL Workbook Management workbook
Notes on EUL status workbooks and the table DBA_JOBS_RUNNING
Predicting Query Performance
About predicting query performance
How does query prediction work in Discoverer Plus?
Why might query prediction not be available?
About improving the speed and accuracy of query prediction
How to make the necessary database views available for query prediction
How to verify and change the timed_statistics parameter for query prediction
How to analyze data tables
How to verify and change the optimizer_mode parameter for query prediction
How to reduce long query prediction times
How to use query prediction with secure views
How to delete old query prediction statistics
Discoverer Registry Settings
What are Discoverer registry settings?
About Discoverer Plus and Discoverer Viewer registry settings
About Discoverer Administrator and Discoverer Desktop registry settings
Which registry settings improve Discoverer Desktop performance?
What are the Discoverer Administrator and Discoverer Desktop registry settings?
How to edit Discoverer Administrator and Discoverer Desktop registry settings
Discoverer Command-line Interface
Which Discoverer command-line interfaces are available?
What is the Oracle Business Intelligence Discoverer command-line interface?
What are the differences between the Discoverer command-line interface and the Discoverer EUL command line for Java
What is a Discoverer command-line interface command?
What is a Discoverer command-line interface command modifier?
About using the Discoverer command-line interface
What privileges are required to run the Discoverer command-line interface?
Notes on using commands
What command syntax conventions does this guide use?
What is the syntax for commands?
Examples of commands
What is a command file?
How to create a command file
How to run a command file
Examples of command files
Quick guide to Discoverer Administrator commands
Discoverer Administrator command reference
/export (EUL objects)
/import (Business Area)
/import (EUL objects)
Discoverer Administrator command modifier reference
Discoverer Desktop command reference
Discoverer Desktop command modifier reference
Discoverer Support for Non-Oracle Databases and Oracle Rdb
What are Heterogeneous Services?
About using generic connectivity to connect to non-Oracle databases and Oracle Rdb
What is the difference between using generic connectivity and ODBC drivers to connect to non-Oracle databases?
What are the advantages of using generic connectivity?
About setting up generic connectivity for Discoverer
How to migrate an EUL from a non-Oracle database (accessed using native ODBC drivers) to an Oracle database (to support generic connectivity)
About ORA-3113 Errors when Using Heterogeneous Data Services with Discoverer Administrator
About using the Transparent Gateway to connect to non-Oracle databases and Oracle Rdb
Upgrading the EUL from Earlier Versions of Discoverer
About Discoverer versions and EUL versions
About upgrading from Discoverer Version 10.1.2 to Version 188.8.131.52.0
Upgrading from earlier versions to Discoverer 10.1.2
Which upgrade path to take for Discoverer Version 10.1.2
What are the prerequisites for upgrading from earlier versions to Discoverer Version 10.1.2?
An overview of the upgrade process for Discoverer Version 10.1.2
Upgrading from Discoverer Release 3.1 (or earlier) to Discoverer Version 10.1.2
Upgrading from Discoverer Release 4.1 to Discoverer Version 10.1.2
About upgrading from Discoverer Release 4.1 to Discoverer Version 10.1.2
Upgrade step 1: Back up the Release 4.1 EUL
Upgrade step 2: Upgrade the Release 4.1 EUL
Upgrade step 3: Refresh summary folders
Upgrade step 4: Migrate users to Discoverer Version 10.1.2
Upgrade step 5: Remove the Release 4.1 EULs
Upgrade step 6: Remove Discoverer Release 4.1 products from client machines
Upgrading from Discoverer Version 9.0.x to Discoverer Version 10.1.2
About upgrading from Discoverer Version 9.0.x to Discoverer Version 10.1.2
Upgrade step 1: Back up the Version 5.0 EUL
Upgrade step 2: Upgrade the Version 5.0 EUL
Upgrade step 3: Refresh summary folders
Upgrade step 4: Migrate users to Discoverer Version 10.1.2
Upgrade step 5: Remove Discoverer Version 9.0.x products from client machines
Notes about upgrading to Discoverer Version 10.1.2
Notes about upgrading Oracle Applications EULs for Discoverer Version 10.1.2
Notes about upgrading EULs that contain analytic functions for Discoverer Version 10.1.2
Notes about upgrading the Video Stores tutorial for Discoverer Version 10.1.2
Notes about upgrading scheduled workbooks for Discoverer Version 10.1.2
Notes about upgrading workbooks saved in .dis files for Discoverer Version 10.1.2
Notes about upgrading Discoverer systems that use the EUL Gateway for Discoverer Version 10.1.2
Notes about upgrading summary folders that contain SET operators for Discoverer Version 10.1.2
Notes about upgrading identifiers that contain invalid characters for Discoverer Version 10.1.2
About scheduled workbooks and compatibility between Discoverer 10.1.2 and pre-Oracle9
Part IV Reference Information
List of reference dialogs
Alphabetical Sort dialog
Business Area Properties dialog
Changing Identifier Warning dialog
Choose Folder dialog (for an item, condition or join)
Choose Join dialog
Choose user or table/view dialog
Condition Properties dialog
Confirm Business Area Delete dialog
Confirm Delete dialog
Confirm Folder Delete dialog
Create EUL Wizard dialog
Create EUL Wizard: Step 2 dialog
Create EUL Wizard: Step 2 dialog (Oracle Applications EUL)
Custom Folder dialog
Custom Folder Properties dialog
Database Information dialog
Database Storage Properties dialog: List of tabs
Database Storage Properties dialog: Materialized Views tab
Database Storage Properties dialog: Mappings tab
Database Storage Properties dialog: Properties tab
Database Storage Properties dialog: Tablespaces tab
Delete EUL dialog
Edit Calculation dialog
Edit Hierarchy dialog: Items tab
Edit Hierarchy dialog: Items tab (select date items that will use this date hierarchy)
Edit Hierarchy dialog: Items tab (select items to include in this hierarchy)
Edit Hierarchy dialog: Name tab
Edit Item Class dialog: Alternative Sort tab
Edit Item Class dialog: General tab
Edit Item Class dialog: List of values tab
Edit Item Class dialog: Options tab
Edit Item Class dialog: Select Items tab
Edit Join dialog: Items tab
Edit Join dialog: Options tab
Edit Summary dialog: Choose Items tab
Edit Summary dialog: Combinations tab
Edit Summary dialog: General tab
For summary folders based on summary tables or materialized views
For summary folders based on external summary tables
Edit Summary dialog: Refresh tab
For summary folders (based on Discoverer summary tables or materialized views) refreshed by Discoverer
For summary folders (based on external summary tables) refreshed by another application
EUL Manager dialog
EUL Upgrade dialog
EUL Upgrade Error dialog
Export Wizard Step 1 dialog
Export Wizard: Step 2 dialog (to export selected business areas)
Export Wizard: Step 2 dialog (to export selected objects)
Export Wizard: Step 2/3 dialog
Folder Properties dialog
Folder Properties dialog: General tab
Folder Properties dialog: Dependents tab
Folder Properties dialog: Components tab
Folder Properties dialog: Reach-Through tab
Hierarchy Properties dialog
Hierarchy Wizard: Step 1 dialog
Import PL/SQL Functions dialog
Import Wizard: Step 1 dialog
Import Wizard: Step 2 dialog
Import Wizard: Step 3 dialog,
Install/Uninstall Sample Data Wizard: Step 1 dialog
Install Sample Data Wizard: Step 1 dialog
Uninstall Sample Data Wizard: Step 1 dialog
Install/Uninstall Sample Data Wizard: Step 2 dialog
Install Sample Data Wizard: Step 2 dialog
Uninstall Sample Data Wizard: Step 2 dialog
Install Sample Data Wizard: Step 3 dialog
Item Class Properties dialog: General tab
Item Class Wizard: Step 1 dialog
Item Hierarchy Node Properties dialog
Item Properties dialog
Item Properties dialog: General tab
Item Properties dialog: Dependents tab
Join Properties dialog
Join Properties dialog: General tab
Join Properties dialog: Dependents tab
Load Wizard: Step 1 dialog
Load Wizard: Step 2 dialog
Load Wizard: Step 3 dialog
Load Wizard: Step 4 dialog
Load Wizard: Step 5 dialog
Manage Folders dialog: By Business Area tab
Manage Folders dialog: By Folder tab
Manage Folders dialog: Orphaned Folders tab
Manage Scheduled Workbooks dialog
Matching Values dialog
New Condition dialog (Advanced)
New Condition dialog (select an item or folder for)
New/Edit Condition dialog
New Date Format dialog
New Item dialog
New Item dialog (select a folder for)
New Join dialog (select a folder for)
Online Dictionary Options dialog
Open Business Area dialog
Options dialog: Connection tab
Options dialog: Default EUL tab
Options dialog: Query Governor tab
PL/SQL Functions dialog: Arguments tab
PL/SQL Functions dialog: Functions tab
Privileges dialog: Privileges tab
Privileges dialog: Query Governor tab
Privileges dialog: Scheduled Workbooks tab
Privileges dialog: User/Role tab
Refresh Business Area dialog
Refresh Summaries dialog
Refresh Wizard dialog
Refresh Wizard Step 1
Refresh Wizard Step 2
Repository Users dialog
Schedule Workbook dialog: General tab
Scheduled Workbook dialog: Parameter values
Schedule Workbook dialog: Schedule tab
Security dialog: Business Area - > User tab
Security dialog: Users - > Business Area tab
Select User/Role dialog
Summary Properties dialog
Summary Wizard (ASM): List of dialogs
Summary Wizard (ASM): Change default settings: List of dialog tabs
Summary Wizard (ASM): Change default settings dialog: Folders tab
Summary Wizard (ASM): Change default settings dialog: Analyze tab
Summary Wizard (ASM): Change default settings dialog: Deletion tab
Summary Wizard (ASM): Change default settings dialog: Query Usage tab
Summary Wizard (ASM): Change default settings dialog: Query User tab
Summary Wizard (ASM): Not Analyzed dialog
Summary Wizard (ASM): Recommended Summaries dialog
Summary Wizard (ASM): Step 2 Analyze Folders dialog
Summary Wizard (ASM): Step 3 Allocate Space dialog
Summary Wizard: Step 1 dialog
Summary Wizard: Step 2 dialog
Summary Wizard: Step 3 dialog (using query statistics)
Summary Wizard: Step 3 dialog (using external tables)
Workarea: Data tab
Workarea: Hierarchies tab
Workarea: Item Classes tab
Workarea: Summaries tab
Using SQL Files and Trace Files
List of SQL files supplied with Discoverer
Working with Oracle Support to resolve Discoverer issues
How to create trace files to diagnose Discoverer problems
How to set the DCLOG_CONFIG_FILE Windows environment variable and create an EUL trace file
Installing the Discoverer Sample Data EUL, Data, and Workbook
What must exist in the database before users can start using Discoverer Administrator using the sample data?
What happens when you install the Discoverer sample data EUL, data, and workbook?
What privileges do you require to install the sample data?
What conditions apply when you connect to Discoverer Administrator for the first time?
Why must you create an EUL?
What steps do I follow to install the Discoverer sample data EUL, data, and workbook?
How to create a private EUL for the sample data
How to install the Discoverer sample data
How to grant access privileges to the VIDEO5 database user for the sample data EUL
How to install the tutorial business area in another End User Layer
How to uninstall the tutorial business area, tables and data
How to reinstall the sample data
Discoverer Administrative Account Information
Database privileges granted by Oracle Business Intelligence Discoverer scripts to the PUBLIC user
Database privileges granted by Oracle Business Intelligence Discoverer scripts to the Discoverer manager
Discoverer EUL Trigger Information
What are Oracle Business Intelligence Discoverer EUL triggers?
List of Oracle Business Intelligence Discoverer EUL triggers
How to register a PL/SQL function that can be executed by a Discoverer EUL trigger
Example for using a PL/SQL trigger to extract SQL from a worksheet when it is saved
Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.
Scripting on this page enhances content navigation, but does not change the content in any way.