Oracle9iAS Discoverer Plus User's Guide -- Index

about, 1

Accessibility

about, 1

enhanced readability, 1

font sizes, 1

keyboard, 1

advanced options, 1

advanced settings

automatic querying, 1

fan traps, 1

analytic functions, 1

and sequencing, 1

applying conditions, 1

banding, 1, 2, 3

banding using CASE statement, 1

banding using GREATEST(), 1

banding using NTILE(), 1

banding with WIDTH_BUCKET, 1

categories, 1

examples of, 1

examples of sequencing, 1

FIRST/LAST, 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

windowing, 1

windowing using AVG(), 1

windowing using SUM(), 1, 2

automatic querying, 1

axis items

about, 1

business areas

about, 1, 2

calculations

about, 1

creating, 1

deleting, 1

displaying and hiding, 1

editing, 1

examples, 1, 2

mathematical, 1

providing dynamic input to, 1

ROWCOUNT, 1

UPPER, 1

using, 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

data points

about, 1

database accounts

about, 1

default settings

about, 1

changing, 1

how to change, 1

reverting to default, 1

default worksheet format, 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

workflow, 1

Discoverer connection

about, 1

Discoverer connections

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.2, 1

unique features, 1

using, 1

Discoverer support for, 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

Excel

exporting to, 1

support for export to, 1

execution plans, 1

exiting Discoverer

how to exit, 1

export to Excel

row limits, 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

fan traps, 1

folders

about, 1

functions

analytic, 1

analytic functions, 1

graphs

about, 1

components, 1

creating, 1

creating bubble graphs, 1

creating dual-Y charts, 1

creating hi-low-close stock charts, 1

creating pie charts, 1

deleting, 1

editing, 1

positioning, 1

saving, 1

setting fonts, 1

types and sub-types, 1

types available, 1

using, 1

using with worksheets, 1

help system

about, 1

how to create a new login, 1

how to start Discoverer using, 1

identifiers

in workbook properties, 1

item headings, 1

changing the format, 1

item navigator

icons, 1

items

about, 1, 2

Keyboard

accessibility, 1

navigation, 1

List of values

about, 1

LOVs

about, 1

examples, 1

selecting multiple values, 1

selecting single values, 1

using long LOVs, 1

menu bar, 1

migration

Discoverer 4i totals, 1

multiple join paths, 1

new connection, 1

non-Oracle databases, 1, 2

opening scheduled, 1

Oracle Applications, 1, 2, 3

Oracle Reports

opening XML files, 1

Page Items

about, 1

parameters

creating, 1

deleting, 1

editing, 1

examples, 1

percentages

about, 1

creating, 1

deleting, 1

displaying and hiding, 1

editing, 1

examples, 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

queries

about, 1, 2

reference dialogs

list of, 1

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

group sorting, 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

initialization, 1

security warnings, 1

table worksheets, 1

tool tips, 1

toolbar, 1

totals

about SUM and Cell SUM, 1

Cell SUM, 1

creating, 1

deleting, 1

displaying and hiding, 1

editing, 1

examples, 1

in worksheets, 1

migrating totals to Oracle9iAS, 1

migration from Discoverer 4i, 1

on crosstab worksheets, 1

SUM, 1

when to use Cell SUM, 1

when to use SUM, 1

UI dialogs

list of, 1

User's Guide

conventions, 1

intended audience, 1

navigation and accessibility, 1