Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Numerics
- 80-20 analysis, 1
A
- Accessibility
- about, 1
- enhanced readability, 1
- font sizes, 1
- JAWS, 1
- keyboard, 1
- screen readers, 1
- software, 1
- advanced options, 1
- automatic querying, 1
- fan traps, 1
- aggregation, 1
- controlling, 1
- examples, 1,
2
- linear and non-linear calculations, 1
- outline values, 1
- what is, 1
- analytic function examples, 1
- analytic function templates
- Band by Rank, 1
- Band by Value, 1
- Difference, 1
- Following Value, 1
- Group Total, 1
- Moving Total, 1
- Percent Contribution, 1
- Percent Difference, 1
- Percent Rank, 1
- Percent Running Contribution, 1
- Preceding Value, 1
- quartiles, 1
- Rank, 1,
2
- Running Total, 1
- analytic functions, 1,
2,
3
- about, 1
- and sequencing, 1
- applying conditions, 1
- banding, 1,
2,
3
- banding using CASE statement, 1
- banding using GREATEST(), 1
- banding with WIDTH_BUCKET, 1
- categories, 1
- creating using templates, 1,
2
- examples of, 1
- examples of sequencing, 1
- FIRST/LAST, 1
- how to create, 1
- hypothetical rank, 1,
2
- inverse percentile, 1
- LAG(), 1,
2
- LAG/LEAD, 1
- linear regression, 1
- MAX(), 1
- MIN(), 1
- Oracle8i, 1
- Oracle9i, 1
- PERCENTILE_CONT(), 1
- PERCENTILE_DISC(), 1
- RANK(), 1,
2,
3,
4
- ranking, 1
- reporting, 1
- reporting using RATIO_TO_REPORT(), 1
- reporting using SUM(), 1,
2,
3
- sequencing examples, 1
- statistical functions, 1
- template, 1
- templates available, 1
- using templates with parameters, 1
- windowing, 1
- windowing using AVG(), 1
- windowing using SUM(), 1,
2
- automatic querying, 1
- axis items
- about, 1
B
- banding, 1
- business areas
- about, 1,
2
C
- calculations
- about, 1
- concatenate items, 1
- creating, 1
- deleting, 1
- displaying and hiding, 1
- editing, 1
- examples, 1,
2
- linear and non-linear, 1
- mathematical, 1
- providing dynamic input to, 1
- removing carriage returns, 1
- ROWCOUNT, 1
- UPPER, 1
- using, 1
- carriage returns in calculations, 1
- CASE statements, 1,
2
- concatenate items, 1
- conditions
- about, 1
- and aggregates, 1
- and roll-up values, 1
- applying more than one, 1
- applying to roll-ups, 1
- creating multiple, 1
- creating nested, 1
- creating single, 1
- deleting, 1
- editing, 1
- examples, 1
- multiple conditions, 1
- nested conditions, 1
- order of application with analytic functions, 1
- turning off, 1
- turning on, 1
- using, 1
- connections
- about (see Discoverer connections), 1
- crosstab worksheets, 1
- cumulative distribution, 1
D
- data points
- about, 1
- database accounts
- about, 1
- DECODE, 1,
2
- default settings
- about, 1
- changing, 1
- how to change, 1
- reverting to default, 1
- default worksheet format, 1
- deleting
- workbooks, 1
- worksheets, 1
- designing workbooks, 1
- dialogs
- list of, 1
- Discoverer
- changing passwords, 1
- getting data, 1
- how to change passwords, 1
- how to exit, 1
- how to start, 1,
2
- workflow, 1
- Discoverer connections
- about, 1
- about public, 1
- changing EULs, 1
- creating, 1
- deleting, 1
- editing, 1
- Discoverer manager
- about the, 1
- Discoverer Plus
- about, 1
- about the workarea, 1
- introduction to, 1
- new features in release 9.0.4, 1
- unique features, 1
- using, 1
- Discoverer Portlet Provider, 1
- adding, 1,
2
- adding portlets, 1
- list of database workbooks, 1
- types, 1
- worksheet portlet, 1
- displaying a worksheet title, 1
- drilling
- about, 1
- drill options, 1
- drilling down, 1
- drilling out, 1
- drilling up, 1
- examples, 1
- into numeric data, 1
- when to use, 1
E
- Excel
- exporting to, 1
- row limits, 1
- support for export to, 1
- execution plans, 1
- exiting Discoverer
- how to exit, 1
- exporting
- about, 1
- accessing exported files, 1
- and page items, 1
- how to export data, 1
- to Microsoft Excel, 1
- to Oracle Reports, 1
- worksheets and graphs, 1
- external applications, 1
F
- fan traps, 1
- folders
- about, 1
- frequency distribution, 1
- frequency distribution analysis, 1
- functions
- analytic function examples, 1
- Oracle8i analytic functions, 1
- Oracle9i analytic functions, 1
G
- graphs
- about, 1
- adding reference lines, 1,
2,
3
- components, 1
- creating, 1
- creating bubble graphs, 1
- creating dual-Y charts, 1
- creating hi-low-close stock charts, 1
- creating pie graphs, 1
- deleting, 1
- editing, 1
- positioning, 1
- reference lines, 1,
2
- saving, 1
- setting fonts, 1
- types and sub-types, 1
- types available, 1
- using, 1
- using with worksheets, 1
H
- help system
- about, 1
- hiding a worksheet title, 1
I
- identifiers
- in workbook properties, 1
- IF statements, 1,
2
- item headings, 1
- changing the format, 1
- item navigator
- icons, 1
- items
- about, 1,
2
J
- JAWS screen reader, 1
K
- Keyboard
- accessibility, 1
- navigation, 1
L
- List of values
- about, 1
- LOVs
- about, 1
- examples, 1
- selecting multiple values, 1
- selecting single values, 1
- using long LOVs, 1
M
- maximising Discoverer performance, 1
- median, 1
- calculating the, 1,
2
- menu bar, 1
- migration
- Discoverer 4i totals, 1
- multiple join paths, 1
N
- non-Oracle databases, 1,
2
O
- opening scheduled, 1
- Oracle Applications, 1
- about, 1
- Discoverer support for, 1
- how to create a new login, 1
- how to start Discoverer using, 1
- new connection, 1
- Oracle Reports
- opening XML files, 1
- OracleAS Portal
- about, 1,
2
- adding a Worksheet portlet, 1
- adding portlets, 1
- Discoverer portlet types available, 1
- editing portlets, 1
- list of database workbooks portlet, 1
- portlet types available, 1
- publishing example, 1
- publishing workbooks to, 1
- security, 1
- shared workbooks, 1
- what you need, 1
- Worksheet portlet, 1
- outline values
- and aggregation, 1
P
- Page Items
- about, 1
- parameters
- creating, 1
- deleting, 1
- editing, 1
- examples, 1
- Pareto analysis, 1
- percentages
- about, 1
- creating, 1
- deleting, 1
- displaying and hiding, 1
- editing, 1
- examples, 1
- percentile analysis, 1
- performance
- maximizing Discoverer, 1
- worksheet design, 1
- pivoting
- about, 1
- on crosstab worksheets, 1,
2
- on table worksheets, 1,
2
- unexpected results, 1
- prerequisites, 1
- Print Wizard, 1
- printing
- and page items, 1
- how to print, 1
- output options, 1
- PDF format, 1
- print dialog, 1
- scaling, 1
- worksheets and graphs, 1
Q
- quartiles, 1
- creating, 1
- queries
- about, 1,
2
R
- reference dialogs
- list of, 1
- reference lines, 1
- roll-up examples, 1
- roll-up values, 1
S
- scheduled workbooks
- about, 1,
2
- accessing results, 1
- copying, 1
- editing, 1
- how to delete results, 1
- how to schedule workbooks, 1
- how to unschedule, 1
- opening, 1
- processing, 1
- scheduling unopened workbooks, 1
- when to use, 1
- security warnings, 1
- sharing data in Discoverer, 1
- sharing workbooks
- about, 1
- with a single user, 1
- with multiple users, 1
- Single Sign-on
- about, 1
- passwords and Discoverer passwords, 1
- sorting
- about, 1
- about group sorting, 1
- changing sort item, 1
- examples, 1
- on crosstab worksheets, 1,
2
- on table worksheets, 1,
2
- removing, 1
- SQL
- about, 1,
2
- and execution plans, 1
- and summaries, 1
- and summary folders, 1
- examples, 1
- how to view, 1
- how to view an execution plan, 1
- in 8.1.6+ databases, 1
- using, 1
- starting Discoverer
- how to start, 1,
2
- initialization, 1
- security warnings, 1
T
- table worksheets, 1
- templates
- for analytic functions, 1
- using, 1
- title
- about editing worksheet title, 1
- display or hide, 1
- worksheet, 1
- tool tips, 1
- toolbar, 1
- totals
- about SUM and Cell SUM, 1
- aggregation, 1
- Cell SUM, 1
- creating, 1
- deleting, 1
- displaying and hiding, 1
- editing, 1
- examples, 1
- in worksheets, 1
- migrating totals to OracleAS, 1
- migration from Discoverer 4i, 1
- on crosstab worksheets, 1
- SUM, 1
- when to use Cell SUM, 1
- when to use SUM, 1
U
- UI dialogs
- list of, 1
- User's Guide
- conventions, 1
- intended audience, 1
- navigation and accessibility, 1
- related documents, 1
- structure, 1
V
- Video Stores Tutorial
- about the, 1
- Video Tutorial Workbook, 1
W
- workarea, 1
- workbook properties, 1
- workbook window
- about, 1
- workbook wizard
- about, 1
- icons, 1
- workbooks, 1
- about, 1,
2,
3
- adding new worksheets, 1
- creating, 1,
2
- deleting from database, 1
- designing for maximum performance, 1
- editing, 1
- non-Oracle databases, 1
- opening, 1
- renaming, 1
- reordering, 1
- saving, 1
- viewing properties, 1
- worksheet title
- about editing, 1
- display or hide, 1
- text limit, 1
- text variables, 1
- worksheets
- about, 1,
2,
3
- about table, 1
- adding items, 1
- changing the format, 1
- crosstab, 1
- default format, 1
- deleting, 1
- designing for maximum performance, 1
- duplicating, 1
- editing, 1
- performance, 1
- refreshing, 1
- removing items, 1
- renaming, 1
- reordering, 1
- table with page detail, 1
- types of, 1