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-Oracle9i 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