1/165
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Oracle BI Discoverer Keyboard Navigation
Related Documents
Conventions
1
Introduction to Administering Discoverer
1.1
What is Oracle Business Intelligence Discoverer?
1.2
What are the components of Oracle Business Intelligence Discoverer?
1.3
What is the role of the Discoverer manager
1.4
What tools does the Discoverer manager use?
1.5
What data sources can you use with Discoverer?
1.6
Basic concepts for Discoverer managers
1.6.1
What is business intelligence?
1.6.2
How does Discoverer work?
1.7
Where should I look for more information?
Part I Administering Discoverer with Multidimensional Datasources
2
Administering Discoverer Systems that Access Multidimensional Data Sources
2.1
What are the prerequisites for administering Discoverer systems that access multidimensional data sources?
2.2
What is online analytic processing (OLAP)?
2.3
What is a multidimensional data source?
2.4
What is the Discoverer Catalog?
2.5
How do I administer a Discoverer system that accesses multidimensional data sources?
2.5.1
About managing a Discoverer system that accesses multidimensional data sources
2.5.2
About administering Discoverer for multidimensional and relational data sources
2.5.3
Which tools are used to administer Discoverer systems that access multidimensional data sources?
2.6
How do I assist users of Discoverer Plus OLAP in getting started?
2.6.1
How do I enable access to the sample workbook?
2.6.2
How do I create a preprocessor program?
2.6.2.1
Why create a preprocessor program?
2.6.2.2
Arguments for the D4O_AUTOGO stored procedure
2.6.2.3
Example of creating a preprocessor program
Part II Administering Discoverer with Relational Datasources
3
Introduction to Administering Discoverer with a Relational Data Source
3.1
What is a relational data source, an OLTP system, and a data warehouse?
3.2
What is Oracle Business Intelligence Discoverer Administrator?
3.3
What are the fundamental concepts behind a Discoverer system when using a relational data source?
3.3.1
Introducing the End User Layer
3.3.2
Introducing business areas
3.3.3
Introducing folders and items
3.3.4
Introducing workbooks and worksheets
3.3.5
Introducing hierarchies and drills
3.3.6
Introducing summary folders
3.4
What is your role as Discoverer manager when using a relational data source?
3.5
What are the steps to a successful Discoverer implementation with a relational data source?
3.6
What is involved in maintaining a Discoverer system with a relational data source?
3.7
What are the prerequisites for using Discoverer Administrator?
3.7.1
What are the system prerequisites?
3.7.2
What are the data access prerequisites?
3.8
About Discoverer using database parameters
3.9
How to start Discoverer Administrator
3.10
What is the Workarea?
3.10.1
About the tabs in the Workarea window
3.10.2
About the context sensitive menus in the Workarea window
3.10.3
About the Administration Tasklist
3.11
What are the new features in Discoverer Administrator?
3.12
About Discoverer Administrator documentation and online help
4
Creating and Maintaining End User Layers
4.1
What is an End User Layer?
4.2
Why is the End User Layer useful?
4.3
What are End User Layer owners?
4.4
What privileges do you require to create an End User Layer in an Oracle database?
4.5
What privileges do you require to create an End User Layer in a non-Oracle database?
4.6
What privileges do you require to maintain an End User Layer?
4.7
What is the EUL Gateway?
4.8
How to create an End User Layer for an existing database user
4.9
How to create an End User Layer in a new database user
4.10
How to delete an End User Layer
4.11
How to view or change the default End User Layer
4.12
About copying EULs and EUL objects by exporting and importing
4.13
Which export/import method to use
4.13.1
About using the Discoverer Export Wizard and Import Wizard
4.13.2
About using Discoverer command-line interface to export/import EUL objects
4.13.3
About using database export/import commands to export/import complete EUL
4.14
How to export the entire EUL using the Discoverer Export Wizard
4.15
How to export selected business areas using the Export Wizard
4.16
How to export selected EUL objects using the Export Wizard
4.17
How to export End User Layer objects using the Discoverer command-line interface
4.18
How to import End User Layer objects using the Discoverer command-line interface
4.19
How to export an EUL using the standard database export utility
4.20
How to import an EUL using the standard database import utility
4.21
How to import EUL objects from a file using the Import Wizard
4.22
Notes about EUL creation and maintenance
4.22.1
What are identifiers?
4.22.2
What are the space requirements and storage parameters for a typical EUL?
4.22.3
What is a suggested workflow for initial EUL development and ongoing maintenance?
4.22.4
Using the Discoverer workbook dump utility
4.22.5
About creating EULs in Logical and Physical Standby (or read-only) databases
5
Creating and Maintaining Business Areas
5.1
What are business areas?
5.2
How to prepare to build a new business area
5.3
What is the Load Wizard?
5.4
How to create a business area using the Load Wizard
5.4.1
Loading from the online dictionary
5.4.2
Loading from a Gateway
5.4.3
Selecting tables and views
5.4.4
Specifying what Discoverer Administrator generates for the business area
5.4.5
Naming the business area, specifying object name and sorting options
5.5
How to open an existing business area when connecting to Discoverer Administrator
5.6
How to open an existing business area when connected to Discoverer Administrator
5.7
How to copy business areas between EULs
5.8
How to edit business area properties
5.9
How to delete a business area
5.10
How to synchronize a business area with the database
5.11
Notes about why a business area (or folders within it) might not be visible to a user
6
Creating and Maintaining Folders
6.1
What are folders?
6.2
What are simple folders?
6.3
What are complex folders?
6.3.1
What are the benefits of using complex folders instead of database views?
6.4
What are custom folders?
6.4.1
What are the differences between custom folders and simple folders?
6.4.2
Examples of custom folders
6.5
About dependencies between folders
6.6
About sharing folders across business areas
6.7
How to create simple folders from the database
6.8
How to create complex folders
6.9
How to create custom folders
6.10
How to edit folder properties
6.11
How to edit a custom folder's SQL statement
6.12
What is complex folder reach through?
6.13
How to define a complex folder to enable reach through to the base folders
6.14
What rules and restrictions apply when you use complex folder reach through?
6.14.1
What rules determine the availability of base folder items to end users?
6.14.2
Restrictions on joins in Discoverer Administrator when defining a base folder as reach through enabled?
6.14.3
Restrictions on summary folders in Discoverer Administrator when defining a base folder as reach through enabled?
6.14.4
Restrictions on Discoverer Plus and Desktop when building a worksheet using items from a reach through enabled base folder
6.14.5
Exceptions when Discoverer end users open and save workbooks that contain items from reach through enabled base folders?
6.14.6
What rules apply to complex folder reach through when you import EUL objects?
6.15
How to delete folders from a business area
6.16
How to assign folders to a business area
6.17
How to assign a folder to multiple business areas
6.18
How to view orphaned folders in the EUL
6.19
How to remove an orphaned folder from the EUL
6.20
How to sort folders in a business area
6.21
How to sort items in a folder
6.22
How to re-order folders in a business area
6.23
How to validate folders in a business area
7
Controlling Access to Information
7.1
About Discoverer and security
7.2
About Discoverer access permissions
7.3
About Discoverer and the Oracle Advanced Security Option (ASO)
7.4
About Discoverer task privileges
7.5
How to specify a user or role (responsibility) that can access a business area
7.6
How to specify the business areas a user or role (responsibility) can access
7.7
How to specify the tasks a user or role (responsibility) can perform
7.8
How to specify a user or role (responsibility) to perform a specific task
7.9
How to set query retrieval limits
7.10
How to set scheduled workbook limits
7.11
How to share Discoverer workbooks using a database role
7.12
About Transparent Application Failover
7.12.1
What is Transparent Application Failover?
7.12.2
What impact does Transparent Application Failover have on Discoverer users?
7.12.3
How to enable Discoverer support for Transparent Application Failover
7.12.4
Notes on Discoverer support for Transparent Application Failover
8
Scheduling Workbooks
8.1
What are workbooks and scheduled workbooks?
8.2
Why schedule workbooks?
8.3
What happens when an end user schedules a workbook?
8.4
Where to store the results of scheduled workbooks?
8.5
What are the prerequisites for scheduling workbooks?
8.6
How to confirm that the DBMS_JOB package is installed
8.7
How to specify the owner of the tables containing scheduled workbooks results
8.8
How to grant the SELECT privilege on the synonym v$parameter to enable you to run scheduled workbooks
8.9
How to view and manage scheduled workbooks
9
Maintaining Items and Item Classes
9.1
What are items?
9.2
What are item classes?
9.3
What are lists of values?
9.4
About setting up lists of values
9.5
What are alternative sorts?
9.6
Examples of different ways to implement alternative sorts
9.6.1
Example 1: Using a custom folder to implement alternative sorts
9.6.2
Example 2: Using a database table to implement alternative sorts
9.6.3
Example 3: Using a calculated item and a DECODE statement to implement alternative sorts
9.7
What is drill to detail?
9.8
About setting up drill to detail
9.9
What are date items?
9.10
What are date format masks?
9.11
About truncating date items and the EUL_DATE_TRUNC function
9.12
About applying conditions to truncated date items
9.13
About drilling out to other applications
9.14
About generating and updating EUL item names automatically
9.14.1
What are primary and secondary elements?
9.14.2
What does the Auto-Generate Name property do?
9.14.3
How to set the value of the Auto-Generate name property of a secondary element
9.14.4
How to set the default value of the Auto-Generate name property to Yes
9.14.5
What happens when you create a business area using the Load Wizard?
9.14.6
How to set the Auto-Generate name property to Yes for all secondary elements in an existing business area
9.14.7
Notes about the Auto-Generate Name property
9.15
How to edit item properties
9.16
How to create a LOV item class
9.17
How to create an alternative sort item class
9.18
How to create a drill to detail item class
9.19
How to create a list of values using a custom folder
9.20
How to edit an item class
9.21
How to add items to an item class
9.21.1
How to add items to an item class using drag and drop
9.21.2
How to add items to an item class using the Edit Item Class dialog
9.21.3
How to add items to an item class using the Item Properties dialog
9.22
How to remove items from an item class
9.22.1
How to remove items from an item class using a popup menu
9.22.2
How to remove items from an item class using the Edit Item Class dialog
9.22.3
How to remove items from an item class using the Item Properties dialog
9.23
How to view the items that use an item class
9.24
How to view the list of values for an item
9.25
How to view the list of values for an item class
9.26
How to delete items and item classes
9.27
About improving performance when end users select parameter values in worksheets
9.28
How to assign an indexed item to an item
9.29
Notes about items based on columns with user-defined datatypes
Part III Introduction to Administering Discoverer
10
Creating and Maintaining Joins
10.1
What are joins?
10.2
What are single item joins?
10.3
What are multi-item joins?
10.4
About joining more than two folders
10.5
What are non-equi-joins?
10.6
What are one-to-many joins, one-to-one joins, and many-to-many joins?
10.7
About joining two folders using more than one join
10.8
What effect do joins have on query results and query performance?
10.9
Examples of how joins can affect query results from complex folders
10.10
What are outer joins?
10.11
How to create joins
10.12
How to view or edit joins
10.13
How to delete a join
10.14
What are fan traps, and how does Discoverer handle them?
10.15
Example of a fan trap
10.16
What to do if you set up a fan trap inside a complex folder
10.17
What to do if you have a data type mismatch in a join
10.17.1
Example of how to create a join between two items that have mismatched data types
10.17.1.1
Step 1: Create a new item that converts the Day of Week item from a varchar to a date data type
10.17.1.2
Step 2: Create a join using the new item
11
Creating and Maintaining Calculated Items
11.1
What are calculated items?
11.2
What are derived items?
11.3
What are aggregate calculated items?
11.4
What restrictions apply to aggregate calculated items?
11.5
What are the differences in behavior between analytic functions and aggregate calculated items?
11.6
What are aggregate derived items?
11.7
Example of an aggregate derived item
11.8
How to create calculated items
11.9
How to edit calculated item properties
11.10
How to edit calculated items
11.11
How to delete calculated items
11.12
How to create a calculated item that enables end users to drill out from one worksheet to display another worksheet in Discoverer Viewer
11.13
Why do you need PL/SQL functions?
11.14
What are custom PL/SQL functions?
11.15
About registering custom PL/SQL functions
11.16
How to register custom PL/SQL functions automatically
11.17
How to register custom PL/SQL functions manually
12
Creating and Maintaining Conditions
12.1
What are conditions?
12.1.1
About condition categories
12.1.2
How do conditions work in Discoverer?
12.2
What are the different types of condition?
12.3
How to create simple conditions
12.4
How to create advanced conditions
12.5
How to edit conditions
12.6
How to edit condition properties
12.7
How to delete conditions
12.8
Example conditions
12.8.1
Example 1: Using a condition to find data for the year 2002
12.8.2
Example 2: Using a condition to find sales in the last seven days
12.8.3
Example 3: Using a condition to find shipments in Quarter 3
12.9
About outer joins and the DisableAutoOuterJoinsOnFilters registry setting
12.9.1
Example 1: No condition applied
12.9.2
Example 2: Condition applied to query and DisableAutoOuterJoinsOnFilters set to 1 (switched off)
12.9.3
Example 3: Condition applied to query and DisableAutoOuterJoinsOnFilters set to 0 (switched on)
12.10
How to create row level security using a mandatory condition
12.11
How to enable summary folders if a source folder includes a mandatory condition
13
Creating and Maintaining Hierarchies
13.1
What are hierarchies?
13.2
What are item hierarchies?
13.3
What are date hierarchies?
13.3.1
What are date hierarchy templates?
13.3.2
About date hierarchies and performance
13.3.2.1
Example of how a date hierarchy can affect performance in Discoverer Plus
13.3.2.2
Example of how performance can be retained
13.4
How to create item hierarchies
13.5
How to create date hierarchies and templates
13.6
How to edit item hierarchies
13.7
How to edit date hierarchy templates
13.8
How to apply a date hierarchy template to a date item
13.9
How to set the default date hierarchy template
13.10
How to delete item hierarchies or date hierarchy templates
13.11
How to modify default date hierarchies that use date format 'RR' following upgrade to Oracle Business Intelligence Discoverer Administrator
13.12
About creating a hierarchy using the CONNECT BY clause in a custom folder
13.13
How to create a hierarchy with a custom folder and the CONNECT BY clause, using the emp table from the scott schema
14
Managing Summary Folders
14.1
About folders and summary folders in Discoverer
14.2
What are summary folders?
14.3
What are Discoverer summary tables?
14.4
What are materialized views?
14.5
What is Automated Summary Management (ASM)
14.6
How does ASM work?
14.7
What are the prerequisites for creating summary folders with ASM?
14.8
What are the different ways to run ASM and when do you use them?
14.9
What is the ASM policy?
14.10
Why must you refresh summary data?
14.11
What happens when a summary folder is refreshed?
14.12
How to run ASM using the Summary Wizard
14.13
How to run ASM after bulk load using the Load Wizard
14.14
How to run ASM using the command-line interface
14.15
How to run ASM using a batch file and the operating system scheduler
14.16
How to configure the database for summary folders
14.16.1
How to confirm that DBMS_JOB is installed for summary management
14.16.2
How to use SQL*Plus to grant the privileges required to create summary folders
14.16.3
How to determine and reset tablespace quotas
14.16.4
How to check object/schema name
15
Creating Summary Folders Manually
15.1
What is manual summary folder creation?
15.2
What are the prerequisites for creating summary folders manually in Discoverer?
15.3
What are summary combinations?
15.4
What to consider when defining summary combinations?
15.5
Guidelines for setting up summary combinations
15.6
When will an expression use a summary folder?
15.7
How to create summary folders based on items in the EUL
15.8
How to create summary folders based on users' queries
15.9
How to create summary folders based on external summary tables
15.10
How to manually refresh a summary folder
15.11
How to edit the properties of summary folders
15.12
How to edit summary folders
15.13
How to edit database storage properties of summary combinations for a summary folder
15.14
How to delete summary folders
15.15
How to view the status of the summary tables/materialized views for a summary folder
16
Additional Information about Summary Folders
16.1
What is the context and future for Discoverer's use of summary tables/materialized views?
16.2
What is query rewrite?
16.3
What are the conditions for query rewrite by Discoverer?
16.4
About viewing the SQL and execution plan for query rewrite in Discoverer
16.5
About configuring how Discoverer displays SQL in the SQL Inspector dialog
16.6
Examples of execution plan (in Discoverer) using/not using a materialized view
16.7
Example of the SQL (in Discoverer) where Discoverer rewrites the query
16.8
Example illustrating the advantages of rewriting a query to use a summary table
16.9
What characteristics differ between summary folders in Oracle Standard Edition databases and Oracle Enterprise Edition databases?
16.10
What is different about summary folders that are based on external summary tables?
16.11
What is different between mapping external summary tables and views to EUL items, with Oracle Enterprise Edition databases?
16.12
Why can you register only one materialized view against a single external summary table in Oracle Enterprise Edition databases?
16.13
About refresh options for Oracle Enterprise Edition databases
16.14
About refreshing summary folders following import between Oracle databases
17
Using Discoverer with Oracle Applications
17.1
What are Oracle Applications?
17.2
What are Oracle Applications responsibilities?
17.3
What features does Discoverer support for Oracle Applications users?
17.4
What are the prerequisites for using Discoverer with Oracle Applications?
17.5
What is different about running Discoverer in Oracle Applications mode?
17.5.1
Differences with the Discoverer Connect dialog in Oracle Applications mode
17.5.2
Differences with Discoverer security in Oracle Applications mode
17.5.3
Differences with Discoverer summary folders in Oracle Applications mode
17.5.4
Differences with Discoverer and secure views/language settings in Oracle Applications mode
17.6
How to configure the Connect dialog for Oracle Applications users
17.7
How to create an Oracle Applications EUL
17.8
Which user should maintain an Oracle Applications EUL?
17.9
How to enable an Oracle Applications user to maintain an Oracle Applications EUL
17.10
How to specify the Oracle Applications users/responsibilities who can access a business area
17.11
How to specify the business areas that an Oracle Applications user/responsibility can access
17.12
How to specify the tasks an Oracle Applications user or responsibility can perform
17.13
How to specify the Oracle Applications users/responsibilities who can perform a specific task
17.14
How to display your Oracle Applications database user name and responsibility in a workbook
18
Using Discoverer with Components of Oracle Fusion Middleware
18.1
Using Discoverer with Oracle Fusion Middleware Control
18.2
Using Discoverer with Oracle Reports
18.3
Using Discoverer with Oracle Web Cache
18.4
Using Discoverer with Oracle Warehouse Builder
18.5
Using Discoverer with OracleAS Single Sign-On Server
18.6
Using Discoverer with Oracle Portal
19
EUL Status Workbooks
19.1
What are EUL status workbooks?
19.2
About the Discoverer EUL V5 business area
19.3
How to install the standard EUL status workbooks
19.4
How to install Oracle Applications EUL status workbooks
19.5
How to run Oracle Applications EUL status workbooks
19.6
How to uninstall the Discoverer EUL V5 business area
19.7
About the EUL Data Definition workbook
19.8
About the EUL Query Statistics workbook
19.9
About the EUL Access workbook
19.10
About the EUL Workbook Management workbook
19.11
Notes on EUL status workbooks and the table DBA_JOBS_RUNNING
20
Predicting Query Performance
20.1
About predicting query performance
20.2
How does query prediction work in Discoverer Plus?
20.3
Why might query prediction not be available?
20.4
About improving the speed and accuracy of query prediction
20.5
How to make the necessary database views available for query prediction
20.6
How to verify and change the timed_statistics parameter for query prediction
20.7
How to analyze data tables
20.8
How to verify and change the optimizer_mode parameter for query prediction
20.9
How to reduce long query prediction times
20.10
How to use query prediction with secure views
20.11
How to delete old query prediction statistics
21
Discoverer Registry Settings
21.1
What are Discoverer registry settings?
21.2
About Discoverer Plus and Discoverer Viewer registry settings
21.3
About Discoverer Administrator and Discoverer Desktop registry settings
21.4
Which registry settings improve Discoverer Desktop performance?
21.5
What are the Discoverer Administrator and Discoverer Desktop registry settings?
21.6
How to edit Discoverer Administrator and Discoverer Desktop registry settings
22
Discoverer Command-line Interface
22.1
Which Discoverer command-line interfaces are available?
22.2
What is the Oracle Business Intelligence Discoverer command-line interface?
22.3
What are the differences between the Discoverer command-line interface and the Discoverer EUL command line for Java
22.4
What is a Discoverer command-line interface command?
22.5
What is a Discoverer command-line interface command modifier?
22.6
About using the Discoverer command-line interface
22.7
What privileges are required to run the Discoverer command-line interface?
22.8
Notes on using commands
22.9
What command syntax conventions does this guide use?
22.10
What is the syntax for commands?
22.11
Examples of commands
22.12
What is a command file?
22.13
How to create a command file
22.14
How to run a command file
22.15
Examples of command files
22.16
Quick guide to Discoverer Administrator commands
22.17
Discoverer Administrator command reference
22.17.1
/?
22.17.2
/apps_fndnam
22.17.3
/apps_gwyuid
22.17.4
/apps_user
22.17.5
/asm
22.17.6
/cmdfile
22.17.7
/connect
22.17.8
/create_eul
22.17.9
/create_eul /apps_mode
22.17.10
/delete
22.17.11
/delete_bus_area
22.17.12
/delete_eul
22.17.13
/export (EUL objects)
22.17.14
/import (Business Area)
22.17.15
/import (EUL objects)
22.17.16
/load
22.17.17
/refresh_bus_area
22.17.18
/refresh_folder
22.17.19
/refresh_summary
22.18
Discoverer Administrator command modifier reference
22.18.1
/aggregate
22.18.2
/all
22.18.3
/apps_grant_details
22.18.4
/apps_responsibility
22.18.5
/apps_security_group
22.18.6
/asm_space, /asm_tablespace
22.18.7
/audit_info
22.18.8
/auto_gen_name
22.18.9
/ba_link
22.18.10
/business_area
22.18.11
/capitalize
22.18.12
/condition
22.18.13
/date_hierarchy
22.18.14
/db_link
22.18.15
/description
22.18.16
/eul
22.18.17
/eul_language
22.18.18
/external_element
22.18.19
/folder
22.18.20
/function
22.18.21
/hier_node
22.18.22
/hierarchy
22.18.23
/identifier
22.18.24
/insert_blanks
22.18.25
/item
22.18.26
/item_class
22.18.27
/join
22.18.28
/keep_folder
22.18.29
/keep_format_properties
22.18.30
/log
22.18.31
/log_only
22.18.32
/lov
22.18.33
/object
22.18.34
/overwrite
22.18.35
/parameter
22.18.36
/password
22.18.37
/private
22.18.38
/refresh
22.18.39
/remove_prefix
22.18.40
/rename
22.18.41
/schema
22.18.42
/show_progress
22.18.43
/sort_folders
22.18.44
/sort_items
22.18.45
/source
22.18.46
/summary
22.18.47
/user
22.18.48
/workbook
22.18.49
/xmlworkbook
22.19
Discoverer Desktop command reference
22.19.1
/?
22.19.2
/apps_fndnam
22.19.3
/apps_gwyuid
22.19.4
/apps_user
22.19.5
/batch
22.19.6
/cmdfile
22.19.7
/connect
22.19.8
/export
22.19.9
/open
22.19.10
/opendb
22.19.11
/parameter
22.19.12
/p
22.19.13
/pt
22.19.14
/savedb
22.19.15
/sheet
22.20
Discoverer Desktop command modifier reference
22.20.1
/all
22.20.2
/apps_responsibility
22.20.3
/eul
23
Discoverer Support for Non-Oracle Databases and Oracle Rdb
23.1
What are Heterogeneous Services?
23.2
About using generic connectivity to connect to non-Oracle databases and Oracle Rdb
23.2.1
What is the difference between using generic connectivity and ODBC drivers to connect to non-Oracle databases?
23.2.2
What are the advantages of using generic connectivity?
23.2.3
About setting up generic connectivity for Discoverer
23.2.4
How to migrate an EUL from a non-Oracle database (accessed using native ODBC drivers) to an Oracle database (to support generic connectivity)
23.2.5
About ORA-3113 Errors when Using Heterogeneous Data Services with Discoverer Administrator
23.3
About using the Transparent Gateway to connect to non-Oracle databases and Oracle Rdb
24
Upgrading the EUL from Earlier Versions of Discoverer
24.1
About Discoverer versions and EUL versions
24.1.1
About upgrading from Discoverer Version 10.1.2 to Version 11.1.1.1.0
24.2
Upgrading from earlier versions to Discoverer 10.1.2
24.2.1
Which upgrade path to take for Discoverer Version 10.1.2
24.2.2
What are the prerequisites for upgrading from earlier versions to Discoverer Version 10.1.2?
24.2.3
An overview of the upgrade process for Discoverer Version 10.1.2
24.2.4
Upgrading from Discoverer Release 3.1 (or earlier) to Discoverer Version 10.1.2
24.2.5
Upgrading from Discoverer Release 4.1 to Discoverer Version 10.1.2
24.2.5.1
About upgrading from Discoverer Release 4.1 to Discoverer Version 10.1.2
24.2.5.2
Upgrade step 1: Back up the Release 4.1 EUL
24.2.5.3
Upgrade step 2: Upgrade the Release 4.1 EUL
24.2.5.4
Upgrade step 3: Refresh summary folders
24.2.5.5
Upgrade step 4: Migrate users to Discoverer Version 10.1.2
24.2.5.6
Upgrade step 5: Remove the Release 4.1 EULs
24.2.5.7
Upgrade step 6: Remove Discoverer Release 4.1 products from client machines
24.2.6
Upgrading from Discoverer Version 9.0.x to Discoverer Version 10.1.2
24.2.6.1
About upgrading from Discoverer Version 9.0.x to Discoverer Version 10.1.2
24.2.6.2
Upgrade step 1: Back up the Version 5.0 EUL
24.2.6.3
Upgrade step 2: Upgrade the Version 5.0 EUL
24.2.6.4
Upgrade step 3: Refresh summary folders
24.2.6.5
Upgrade step 4: Migrate users to Discoverer Version 10.1.2
24.2.6.6
Upgrade step 5: Remove Discoverer Version 9.0.x products from client machines
24.2.7
Notes about upgrading to Discoverer Version 10.1.2
24.2.7.1
Notes about upgrading Oracle Applications EULs for Discoverer Version 10.1.2
24.2.7.2
Notes about upgrading EULs that contain analytic functions for Discoverer Version 10.1.2
24.2.7.3
Notes about upgrading the Video Stores tutorial for Discoverer Version 10.1.2
24.2.7.4
Notes about upgrading scheduled workbooks for Discoverer Version 10.1.2
24.2.7.5
Notes about upgrading workbooks saved in .dis files for Discoverer Version 10.1.2
24.2.7.6
Notes about upgrading Discoverer systems that use the EUL Gateway for Discoverer Version 10.1.2
24.2.7.7
Notes about upgrading summary folders that contain SET operators for Discoverer Version 10.1.2
24.2.7.8
Notes about upgrading identifiers that contain invalid characters for Discoverer Version 10.1.2
24.2.8
About scheduled workbooks and compatibility between Discoverer 10.1.2 and pre-Oracle9
i
database releases
Part IV Reference Information
25
Dialog Reference
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
Conditions dialog
Confirm Business Area Delete dialog
Confirm Delete dialog
Confirm Folder Delete dialog
Connect 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
Impact 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
Items dialog
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
Properties dialogs
Refresh Business Area dialog
Refresh Summaries dialog
Refresh Wizard dialog
Refresh Wizard Step 1
Refresh Wizard Step 2
Repository Users dialog
Responsibilities 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)
Using Help
Values dialog
Workarea: Data tab
Workarea: Hierarchies tab
Workarea: Item Classes tab
Workarea: Summaries tab
26
Using SQL Files and Trace Files
26.1
List of SQL files supplied with Discoverer
26.2
Working with Oracle Support to resolve Discoverer issues
26.3
How to create trace files to diagnose Discoverer problems
26.4
How to set the DCLOG_CONFIG_FILE Windows environment variable and create an EUL trace file
27
Installing the Discoverer Sample Data EUL, Data, and Workbook
27.1
What must exist in the database before users can start using Discoverer Administrator using the sample data?
27.2
What happens when you install the Discoverer sample data EUL, data, and workbook?
27.3
What privileges do you require to install the sample data?
27.4
What conditions apply when you connect to Discoverer Administrator for the first time?
27.5
Why must you create an EUL?
27.6
What steps do I follow to install the Discoverer sample data EUL, data, and workbook?
27.7
How to create a private EUL for the sample data
27.8
How to install the Discoverer sample data
27.9
How to grant access privileges to the VIDEO5 database user for the sample data EUL
27.10
How to install the tutorial business area in another End User Layer
27.11
How to uninstall the tutorial business area, tables and data
27.12
How to reinstall the sample data
A
Discoverer Administrative Account Information
A.1
Database privileges granted by Oracle Business Intelligence Discoverer scripts to the PUBLIC user
A.2
Database privileges granted by Oracle Business Intelligence Discoverer scripts to the Discoverer manager
B
Discoverer EUL Trigger Information
B.1
What are Oracle Business Intelligence Discoverer EUL triggers?
B.2
List of Oracle Business Intelligence Discoverer EUL triggers
B.3
How to register a PL/SQL function that can be executed by a Discoverer EUL trigger
B.4
Example for using a PL/SQL trigger to extract SQL from a worksheet when it is saved
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.