Oracle9i Discoverer Desktop User's Guide -- Index

!= operator in conditions, 1

& (ampersand) in worksheet titles, 1

+ (plus) sign in dialog boxes, 1

< operator in conditions, 1

<= operator in conditions, 1

<> operator in conditions, 1

= operator in conditions, 1

> operator in conditions, 1

>= operator in conditions, 1

3D graphs, 1

3D View command, 1

access rights, 1

accessing data, 1, 2

accessing workbooks, 1

active folder, 1

Active Only option, 1, 2

adding graphic bars, 1, 2

adding graphics to worksheets, 1, 2

adding new items to layouts, 1, 2

adding reports, 1

addition, 1

administrators, 1, 2, 3

Advanced button (Conditions), 1, 2

aggregations icon, 1

aligning

bitmaps in titles, 1

report headers/footers, 1

text in column headings, 1

All Items option, 1, 2

ampersand (&) in worksheet titles, 1

analysis bar, 1

analysis tools

applying to data, 1, 2

creating definitions, 1

deleting definitions, 1

editing definitions, 1

exporting and, 1

turning definitions on/off, 1

types listed, 1

viewing definitions, 1

Analytic Functions, 1, 2

and Oracle Server 8.1.6, 1

and Sequencing, 1

calculating cumulative values, 1

CASE, 1

categories, 1

Equi-height bands, 1

equi-height bands, 1

equi-width bands, 1

generic template, 1

in Conditions, 1

INTERCEPT, 1

Lag/Lead, 1

LEAD, 1

ORDER BY expression, 1

OVER expression, 1

PARTITION BY expression, 1

RANK(), 1, 2

Ranking, 1

RATIO_TO_REPORT, 1

REGR_AVGX, 1

REGR_COUNT, 1

REGR_R2, 1

Reporting, 1

SUM, 1, 2

Windowing with logical offsets, 1

Windowing with physical offsets, 1

analyzing data, 1, 2, 3, 4

AND operator, 1

and Responsibilities, 1

applications, 1

Apply group sort icon, 1

applying formats, 1

arrows as cursors, 1, 2

ascending sort order, 1

assigning workbooks, 1, 2

associating data with workbooks, 1

attaching to databases, 1

attachments, 1

audio files, 1

Auto Size command, 1

Average option, 1

averages, 1, 2

axes labels (graphs)

displaying, 1, 2, 3

formatting, 1

axis item icon, 1

axis item markers, 1, 2

selecting, 1

axis item value icon, 1

axis items, 1

crosstabs, 1

drilling into, 1, 2

drilling through sub-levels on, 1

moving data among, 1, 2

selecting, 1, 2, 3

sorting across, 1

sorting on, 1, 2

viewing values, 1

workbook window, 1

background colors

column headings, 1

worksheet titles, 1

Banding

Banding by rank, 1

Banding by value, 1

CASE, 1

with Analytical Functions, 1

bar formats

graphs, 1

tables, 1

BETWEEN operator, 1

bitmaps, 1, 2

Boolean operators, 1

Business area icon, 1

business areas, 1

displaying, 1

selecting items, 1, 2

buttons

Graph toolbar, 1

Print Preview window, 1

workbook window, 1

bypassing the Connect dialog, 1

cache, 1

Calculation dialog box, 1

Calculation Examples, 1

calculations, 1, 2, 3

creating, 1, 2

creating for conditions, 1

displaying results, 1

editing in new workbooks, 1

exporting and, 1

selecting for new workbooks, 1

standard syntax, 1, 2, 3, 4

viewing existing, 1

Calculations command, 1

Calculations dialog box, 1

canceling changes, 1

case-sensitive text filters, 1

cell spacing, 1

cells

drilling and, 1

selecting, 1, 2

changing data, 1

changing data formats, 1

changing graphs, 1, 2

changing pages

multi-page layouts, 1

workbooks, 1

changing text items, 1, 2

clock icon, 1

Close command, 1

closing Print Preview window, 1

closing workbooks, 1

Collapse command, 1

colors

column headings, 1

graphs, 1, 2

customizing, 1, 2

worksheet titles, 1

column headings, 1, 2, 3, 4

aligning text, 1

display options, 1

drilling and, 1

editing text, 1

formatting caution, 1

reformatting on crosstabs, 1

reformatting on tables, 1, 2

selecting, 1

wrapping text in, 1

column markers, 1, 2

columns, 1, 2

displaying text, 1

drilling multiple, 1

moving, 1, 2

group sorts and, 1

pivoting, 1, 2, 3

reformatting data, 1

removing from sorts, 1

resizing, 1, 2

automatically, 1

selecting, 1

selecting items, 1

sorting on two, 1

Columns Width command, 1

Command Line Interface, 1

command-line options, 1

company logos, 1

comparisons, 1, 2, 3

complex calculations, 1

complex conditions, 1

condition

parameter placeholder, 1

condition icon, 1

condition operators, 1

conditions, 1, 2, 3

adding descriptions to, 1

applying, 1, 2

assigning data items to, 1

changing on new worksheets, 1

conflicting, 1

copying, 1

creating advanced, 1, 2

creating definitions for, 1, 2

deleting definitions, 1, 2

editing definitions, 1

enabling/disabling definitions, 1, 2

exceptions vs., 1

exporting and, 1

naming, 1

nesting, 1

removing, 1

selecting, 1

selecting for new worksheets, 1

selecting multiple values for, 1

viewing definitions

for specific items, 1

Conditions command, 1

Conditions dialog box, 1

Configuring Discoverer to use standard EULs, 1

Configuring the Oracle Applications user Connect dialog, 1

Connect to Discoverer dialog box, 1

connecting to databases, 1

Copy Graph to Clipboard button, 1, 2

copying conditions, 1

copying SQL statements, 1

correlated items, 1, 2

correlation, 1

Count All Rows command, 1

Count Distinct option, 1

Count option, 1

covariance, 1

Create Calculation option, 1

Create Subquery dialog box, 1

creating calculations, 1, 2

creating graphs, 1, 2, 3

creating reports, 1

creating workbooks, 1

creating workbooks and worksheets, 1, 2, 3

arranging layouts, 1

choosing data items, 1, 2

optional steps, 1

selecting conditions, 1

selecting display type, 1

sorting data, 1

specifying calculations, 1

crosstabs, 1, 2, 3

arranging items on new, 1

data points and, 1

delineating data, 1, 2

drilling and, 1

multiple columns or rows, 1, 2

procedure described, 1

skipping hierarchical levels, 1, 2

duplicating, ?? to 1

editing layouts, 1, 2

getting data for new, 1

item markers and, 1, 2

larger than a page, 1

overview, 1

pivoting items, 1

reformatting column headings, 1

reformatting data, 1

scaling, 1

selecting as display type, 1

selecting items, 1, 2, 3

sorting data, 1, 2

across axes, 1

adding data points, 1

defaults, 1

group sorts and, 1

restoring previous state, 1

with multiple pages, 1, 2

current date, 1, 2

data, 1

accessing, 1, 2

adding to graphs, 1

aggregating, 1

analyzing, 1, 2, 3, 4

canceling changes, 1

comparing, 1, 2, 3

delineating with bars, 1, 2

displaying specific items, 1, 2

filtering, 1, 2, 3

finding exceptions, 1, 2

defining item for, 1

getting details, 1

pivoting, 1, 2, 3

on crosstabs, 1

reformatting, 1, 2

replacing, 1

retrieving, 1, 2, 3

for new crosstabs, 1

saving changes to, 1

selecting for drilling, 1

automatically, 1

in other sheets, 1

tables, 1

selecting for new worksheets, 1, 2

sorting, 1, 2, 3

automatically, 1

crosstabs and, 1, 2, 3

data within, 1, 2

display options, 1

in groups, 1, 2, 3

on new worksheets or workbooks, 1, 2, 3

subtotals and ungrouped, 1

totals for non-numeric, 1

updating, 1

viewing, 1, 2, 3, 4

Data command, 1, 2

data points, 1

calculations and, 1

defined, 1

getting totals for, 1, 2, 3

sorting, 1

databases, 1, 2, 3

connecting to, 1

loading, 1

non-Oracle, 1

saving workbooks with, 1

dates

adding to reports, 1, 2

setting for scheduled reports, 1

decimal places, 1, 2

default aggregate, 1

default formats, 1

Define Custom Colors option, 1

Delete button, 1

Delete command, 1

Delete Workbook from Database dialog, 1

deleting

analysis tool definitions, 1

items from workbooks and worksheets, 1

items on new worksheets, 1

sort columns, 1

workbooks, 1

descending sort order, 1

descriptions for workbooks, 1

designing reports, 1

dimensions, 1, 2

Discoverer

running, 1

Discoverer Desktop

basic concepts, 1

shortcuts, 1

disk cache, 1

display options, 1

display types, 1, 2

selecting, 1

displaying

business areas, 1

data, 1, 2, 3, 4

specific items, 1, 2

graph labels, 1, 2, 3

graphs, 1

items in folders, 1

multi-page reports, 1

page headers/footers, 1

sorted data, 1

SQL statements, 1, 2

text, 1

workbooks, 1

worksheets, 1

distinct values, 1

distributing reports, 1, 2

donut graphs, 1

double-headed cursors, 1

Drill command, 1

Drill dialog box, 1, 2

opening, 1

drill options, 1, 2

from menus, 1

Drill Options dialog box, 1

drilling, 1, 2, 3

across worksheets, 1, 2

automatically, 1

basic procedure described, 1

crosstabs and, 1

data out of sequence, 1, 2

display options, 1

tables and, 1, 2, 3, 4

to related items, 1, 2, 3

drilling menus, 1

Duplicate as Table dialog box, 1

duplicate rows, 1

duplicate values, 1

duplicating tables and crosstabs, ?? to 1

Edit Calculation dialog box, 1, 2

Edit Condition dialog box, 1

Edit Graph command, 1

Edit Parameter Values command, 1

Edit Sheet command, 1

Edit Sheet dialog box, 1

adding/removing items, 1

changing conditions, 1

changing layouts, 1

changing sorting preferences, 1

edit subquery, 1

Edit Title command, 1, 2, 3

Edit Title dialog box, 1, 2, 3

Insert button, 1

editing

analysis tool definitions, 1

column headings, 1

exception items, 1

graphs, 1, 2

new worksheets and workbooks, 1, 2

scheduled report settings, 1, 2

worksheet titles, 1

editing subqueries, 1

e-mail, 1, 2

adding attachments, 1

format options, 1

equal values, 1

equality, 1

error messages, 1

EUL (End User Layer), 1

Excel tool, 1

Excel workbooks, 1, 2

Exception dialog box, 1, 2

exceptions, 1, 2

conditions vs., 1

conflicts, 1

creating, 1, 2

defining expressions, 1, 2

editing, 1

enabling/disabling, 1, 2

formatting, 1

Exceptions command, 1

Exceptions dialog box, 1

opening, 1

Exceptions tool, 1

Execution Plan

Materialized Views, 1

expanding items in dialog boxes, 1

expiration dates, 1

Export command, 1, 2

Export dialog box, 1

for Oracle Reports, 1

Export SQL from a Workbook, 1

exporting reports, 1

exporting SQL statements, 1

expressions, 1

defining for conditions, 1, 2, 3

defining for exceptions, 1, 2

external applications, 1, 2

files, 1

filters, 1, 2, 3

Find button, 1

finding

exceptions to data values, 1

specific text items, 1

flattened SQL, 1

folders, 1

active vs. unavailable, 1

viewing items, 1

Folders icon, 1

fonts

column headings, 1

graphs, 1

report headers/footers, 1

footers, 1, 2

adding text codes, 1

Format Data dialog box, 1, 2

Format Heading dialog box, 1

Format Title dialog box, 1

formatting axes labels, 1

formatting bar, 1

reformatting column headings, 1, 2

formatting options

bitmaps, 1

exceptions, 1

percentages, 1

totals and subtotals, 1

worksheet titles, 1

formatting worksheets, 1, 2

column headings, 1, 2

titles, 1

Foundation Name, 1

Gateway User ID, 1

Generate Label Automatically option, 1

Graph button, 1

Graph menu, 1

Graph window, 1

resizing, 1

Graph Wizard, 1, 2, 3

graphic bars, 1, 2

graphics, 1, 2

graphs, 1, 2

adding legends, 1

adding patterns, 1, 2

adding to worksheets, 1, 2, 3

color options, 1

display options, 1

distributing via e-mail, 1, 2

modifying, 1, 2

plotting data on, 1

printing, 1, 2, 3

removing patterns, 1

resizing, 1

rotating, 1

z-axis, 1

selecting type, 1, 2, 3, 4

updating, 1

visual enhancements, 1, 2

gridlines, 1, 2

group names, 1

group sorts, 1, 2, 3

automatic, 1

headers, 1, 2

adding text codes, 1

Headings command, 1, 2

Hi to Lo sort order, 1

hiding duplicate rows, 1

high values, 1, 2, 3

highlighting, 1

hints, 1

HKEY_CURRENT_USER - registry setting, 1

horizontal gridlines, 1

icons (New Sheet dialog), 1, 2

1

Import SQL command, 1

importing SQL, 1

importing SQL statements, 1

IN operator, 1

informational messages, 1

Inline Views, 1

Insert Data Point Name option, 1, 2

Insert Item Name option, 1, 2

Insert menu, 1

Insert Value option, 1, 2

IS NOT NULL operator, 1

IS NULL operator, 1

item handles, 1

item markers, 1, 2

selecting, 1

items, 1

adding new, 1, 2

adding to printed reports, 1

arranging in layouts, 1, 2

attaching to conditions, 1

deleting on new worksheets, 1

editing, 1, 2

expanding in dialog boxes, 1

formatting, 1, 2

pivoting on crosstabs, 1

pivoting on tables, 1, 2

removing from workbooks and worksheets, 1

selecting, 1, 2

in multiple positions, 1

selecting for exceptions, 1

selecting for scheduled reports, 1, 2

viewing conditions for specific, 1

viewing in folders, 1

join definitions - importing SQL, 1

labels, 1

adding text codes

percentages and, 1

totals and subtotals, 1

displaying on graphs, 1, 2, 3

formatting graph axes, 1

generating automatically, 1

percentages columns, 1, 2

removing text codes, 1, 2

wrapping text in, 1

Landscape mode, 1

large worksheets, 1

layout options, 1

layouts, 1, 2

arranging items, 1, 2

changing, 1, 2

selecting, 1

Legend command, 1

legends, 1

adding to graphs, 1

displaying, 1, 2

LIKE operator, 1

linear regression, 1

lines, 1, 2, 3

lists, 1, 2

Lo to Hi sort order, 1

loading databases, 1

logos, 1

Lotus 1-2-3 spreadsheet, 1

low values, 1, 2, 3

magnifying glass, 1

mailing lists, 1

main window, 1

margins, 1

Match Case option, 1

Materialized View, 1

mathematical functions

selecting, 1

Maximum option, 1

memory cache, 1

menus, 1, 2

drilling options, 1

metafiles, 1

Microsoft Excel workbooks, 1, 2

Minimum option, 1

Modify Graph button, 1, 2

Modify Graph dialog box, 1

monthly reports, 1

moving columns, 1, 2

group sorts and, 1

1

multi-dimensional crosstabs, 1

multi-page crosstabs, 1

changing pages, 1

multi-page reports, 1

multi-page tables, 1

changing pages, 1

multiple columns or rows

drilling, 1, 2

multiple workbooks

opening, 1, 2

switching among, 1

nesting conditions, 1

New command, 1

New Condition dialog box, 1, 2

New Graph Type button, 1, 2, 3

New Graph Type drop down list, 1

New Parameter command, 1

New Parameter dialog box, 1

new sheet

for subqueries, 1

New Sheet command, 1

New Sheet dialog box, 1

arranging items on layouts, 1

icons described, 1, 2

moving items to Selected list, 1

opening, 1

selecting calculations, 1

setting conditions, 1

sorting data, 1

non-numeric data totals, 1

non-Oracle databases, 1, 2

NOT BETWEEN operator, 1

NOT IN operator, 1

NOT LIKE operator, 1

null values, 1

numbers, 1, 2

adding graphic bars, 1, 2

adding to new crosstabs, 1

getting exceptions to, 1

getting totals and subtotals for, 1, 2

sorting, 1, 2, 3

numeric item icon, 1

ODBC SQL, 1

OLE automation, 1

OLE demonstration, 1

OLE support in Discoverer, 1

OLEdemo.doc, 1

OLEdev.doc, 1

One Page button, 1

on-line transaction processing, 1

/open option, 1

Open command, 1

/open option, 1

Open Scheduled Workbook dialog box, 1

Open Workbook dialog box, 1

opening Scheduling Manager, 1

opening workbooks, 1, 2, 3, 4

multiple, 1, 2

non-Oracle, 1

operator buttons, 1

operators, 1

Boolean, 1

conditional expressions, 1

Options button, 1

Options command, 1

Options dialog box, 1, 2

Oracle Applications

automatic Connect, 1

choosing a Responsibility, 1

configuring the Connect dialog, 1

Connect dialog, 1

connect to Discoverer, 1

connection configuration, 1

Foundation Name, 1

Gateway User ID, 1

Prerequisites, 1

shortcut icon, 1

supported features, 1

Oracle Applications User, 1

Oracle Reports, 1, 2

ordered lists, 1

Orientation option, 1

outlined cells, 1

/p <file> option, 1

page axis, 1

containing data, 1

moving columns to, 1, 2

page detail crosstab layouts, 1

changing pages, 1

page detail tabular layouts, 1

changing pages, 1

page headers and footers, 1, 2

adding text codes, 1

page item marker, 1

page items

editing, 1

pivoting, 1

reformatting, 1

removing from layouts, 1

page numbers, 1

page orientation, 1

Page Setup command, 1

Page Setup dialog box, 1, 2

opening, 1

pagebreaks, 1

paint jar, 1

Parameter dialog box, 1

parameters

adding to conditions, 1

attaching to conditions, 1

calculations and, 1

creating, 1, 2

defined, 1

defining default, 1

enabling/disabling, 1

entering multiple values in, 1, 2

naming, 1

selecting data items for, 1

viewing existing, 1

Parameters command, 1

Parameters dialog box, 1

passwords, 1

Pattern Editor, 1

patterns, 1

adding to graphs, 1, 2

customizing, 1

removing from graphs, 1

pencil tool, 1

Percentage dialog box, 1

Percentage of Grand Total option, 1

percentages, 1, 2

creating definitions for, 1

editing definitions, 1

enabling/disabling definitions, 1

formatting options, 1

getting, 1

group sorts and, 1

not totaling 100%, 1

removing, 1

rounding and, 1

viewing definitions, 1

percentages columns

labeling, 1, 2

Percentages command, 1

Percentages dialog box, 1

opening, 1

Percentages tool, 1

pie graphs, 1

pivoting, 1, 2, 3

examples, 1, 2, 3, 4

items on crosstabs, 1

items on tables, 1, 2

plus signs (+) in dialog boxes, 1

pointers

as arrows, 1, 2

as double-headed lines, 1

as magnifying glass, 1

as paint jar, 1

as pencil, 1

item markers and, 1

page axis and, 1

pop-up menus, 1

Portrait mode, 1

preface

conventions table sample, 1

heading

PH PrefaceHead, 1

PT PrefaceTitle, 1

Prepare Mail dialog box, 1

Preview button, 1, 2

previewing reports, 1, 2

Print button, 1, 2

print options, 1, 2

Print Preview command, 1

Print Preview window, 1

closing, 1

moving through report pages, 1

printing, 1, 2

from files, 1

graphs, 1, 2, 3

large worksheets, 1

reports, 1, 2, 3

progressions, 1

prompts, 1

properties, 1, 2

Properties command, 1

PT PrefaceTitle, 1

queries, 1, 2, 3

running, 1

running for all sheets, 1

query estimate dialog, 1

Query Governor, 1

RANK

default ordering, 1

ordering by ASC, 1

ordering by DESC, 1

RDF files, 1

rearranging columns, 1, 2

group sorts and, 1

reference lines (graphs), 1

reformatting worksheets, 1, 2

column headings, 1, 2

titles, 1

Refresh Sheet command, 1, 2

refreshing worksheets, 1

regedit, 1

registry settings, 1

removing items from workbooks and worksheets, 1

removing sort columns, 1

removing workbooks, 1

renaming workbooks, 1

reordering columns, 1, 2

group sorts and, 1

replacing data, 1

report templates (Oracle Reports), 1

reports, 1, 2

adding date/time entries, 1, 2

adding headers/footers, 1

designing page layouts, 1

displaying two pages side-by-side, 1

distributing with e-mail, 1, 2

exporting, 1

previewing, 1, 2

printing, 1, 2, 3

removing headers/footers, 1

running scheduled, 1, 2

saving, 1

setting margins, 1

unscheduling, 1

viewing multi-page, 1

resizing columns, 1, 2

automatically, 1

resizing graphs, 1

resizing windows, 1

result sets, 1, 2

selecting, 1

viewing, 1

Retrieve All Rows command, 1

retrieving rows, 1

right-click menus, 1

rotating graphs, 1

rounding, 1

row markers, 1

row numbers, 1, 2

rows, 1

drilling multiple, 1, 2

drilling single, 1, 2

hiding duplicate, 1

retrieving, 1

selecting, 1

running Discoverer, 1

running queries, 1

running scheduled reports, 1, 2

sample database, 1, 2

Save As command, 1

Save As dialog box, 1

Save command, 1

Save Workbook dialog box, 1

Save Workbook to Database dialog box, 1

saving exported reports, 1

saving workbooks, 1, 2

Scale command, 1

scaling printouts, 1

Schedule button, 1, 2

Schedule command, 1

Schedule Workbook dialog box, 1, 2, 3, 4

opening, 1

scheduled reports, 1, 2

deleting completed, 1

displaying, 1

editing settings, 1, 2

error messages, 1

expiration dates, 1

naming, 1

running, 1, 2

selecting items, 1, 2

unscheduling, 1

viewing results, 1, 2, 3

Scheduled Workbook

Oracle Applications User, 1

scheduled workbooks, 1, 2

Oracle Applications Users, 1

Scheduling Manager, 1, 2

opening, 1

Scheduling Manager button, 1

Scheduling Manager command, 1

screen markers, 1, 2, 3

scroll bars, 1

scroll buttons, 1, 2

scrolling, 1

Select Condition option, 1

selecting

data for drilling, 1

automatically, 1

in other sheets, 1

tables, 1

data for new worksheets, 1, 2

display type, 1

exception items, 1

items for scheduled reports, 1, 2

items on worksheets, 1, 2

in multiple positions, 1

multiple values for conditions, 1

result sets, 1

workbooks, 1, 2

worksheets, 1, 2, 3

selection boxes, 1

Send command, 1

sending e-mail messages, 1

sequential conditions, 1

servers, 1

Set Bitmap option, 1

setting options, 1

setting properties

workbooks, 1, 2

setting report margins, 1

setting sort order, 1, 2

shading, 1

shadows, 1

Share Workbooks dialog box, 1, 2

Sharing command, 1

sharing workbooks, 1, 2

/sheet ALL option, 1

shortcuts, 1

Show Graphic Bars option, 1

Show Page Items option, 1

Show/Hide Labels button, 1, 2, 3

Show/Hide Legend button, 1, 2

simple calculations, 1, 2

Sort command, 1, 2

Sort Crosstab dialog box, 1, 2

opening, 1

sort order, 1, 2

reversing, 1

Sort Table dialog box, 1

ordering columns in, 1

sorting data, 1, 2, 3

adding sort columns, 1, 2

automatically, 1

crosstabs and, 1, 2, 3

display options, 1

group sorting and, 1, 2, 3

on new worksheets or workbooks, 1, 2, 3

removing columns, 1

sorting options, 1, 2

sorting tools, 1

crosstabs and, 1, 2

spacing, 1

spreadsheets, 1, 2

SQL Inspector

Execution Plan, 1

SQL Inspector command, 1, 2

SQL program - importing, 1

SQL statements, 1

SQL syntax, 1

SQLType - registry setting, 1

standard deviation, 1

calculating, 1

Standard Deviation option, 1

starting

Discoverer Desktop, 1

Statistics, 1

status bar, 1

Status Bar command, 1

subqueries, 1

edit, 1

new workbooks, 1

subqueries, correlated items, 1

subqueries, creating, 1

subtotals, 1, 2

adding lines to, 1

getting, 1, 2

getting percentages for, 1

placement options, 1

removing, 1

ungrouped data and, 1

viewing definitions, 1

Sum option, 1

summaries, 1

sums, 1, 2

suqueries

editing, 1

table

larger than a page, 1

tables, 1, 2, 3, 4

arranging items on new, 1

changing sorting preferences, 1

data points and, 1

delineating data, 1, 2

drilling and, 1, 2, 3, 4

procedure described, 1

skipping hierarchical levels, 1, 2

duplicating, ?? to 1

editing layouts, 1, 2

item markers and, 1

layout options, 1

moving columns, 1, 2

group sorts and, 1

pivoting items, 1, 2

reformatting column headings, 1, 2

reformatting data, 1

resizing columns, 1, 2

automatically, 1

retrieving rows, 1

scaling, 1

selecting as display type, 1

selecting items, 1, 2, 3

sorting data, 1, 2

automatically, 1

with multiple pages, 1, 2

tabs, 1, 2

templates (Oracle Reports), 1

text

aligning

in column headings, 1

case-sensitive filters, 1

data points and totals for, 1

defining conditions for, 1

editing, 1, 2

finding specific, 1

getting exceptions to, 1

mathematical functions and, 1

resizing columns and, 1

sorting, 1, 2, 3

word wrapping, 1, 2

text codes

adding to labels

percentages columns, 1

totals and subtotals, 1

removing, 1, 2

report headers/footers, 1

Text Wrap button, 1

three-dimensional graphs, 1

time estimate dialog, 1

time limit warnings, 1

time settings for scheduled reports, 1

time stamps, 1

Title command, 1

titles

adding bitmaps, 1

adding to graphs, 1, 2

editing, 1

formatting, 1, 2

totals and subtotals, 1

tool bar

Graph window, 1, 2

Print Preview window, 1

tool tips, 1

Toolbar command, 1

Total dialog box, 1

totals, 1, 2, 3, 4

adding lines to, 1

creating definitions for, 1

editing definitions, 1

enabling/disabling definitions, 1

entering labels for, 1

finding percentages of, 1

formatting options, 1

getting percentages for, 1

placement options, 1

removing, 1

viewing definitions, 1

Totals command, 1

Totals dialog box, 1

Totals tool, 1

options, 1

transaction processing, 1

trends, 1

truncated text, 1

Two Page button, 1

unavailable folders, 1

unique values, 1

Unschedule button, 1

updating graphs, 1

updating worksheets, 1

User -> Workbook tab, 1

user names, 1

Value(s) option (Conditions), 1, 2

values, 1

counting unique, 1

creating conditions for, 1

getting exceptions to, 1, 2

defining expressions for, 1

getting totals and subtotals for, 1

null, 1

selecting multiple for conditions, 1

sorting and duplicate, 1

viewing for zxis items, 1

variables, 1

Variance option, 1

vertical gridlines, 1

Video database, 1

video files, 1

Video.dis - OLE demonstration workbook, 1

View Conditions For option, 1

View Errors option, 1

Viewer checkboxes, 1

viewing

business areas, 1

data, 1, 2, 3, 4

specific items, 1, 2

file types, 1

graph labels, 1, 2, 3

graphs, 1

items in folders, 1

multi-page reports, 1

page headers/footers, 1

sorted data, 1

SQL statements, 1, 2

text, 1

workbooks, 1

worksheets, 1

views, 1

weekly reports, 1

"what if" scenarios, 1

Window menu, 1

wizards

for creating graphs, 1

for creating workbooks, 1

for opening workbooks, 1

WMF formats, 1

Workbook -> User tab, 1

Workbook Properties dialog box, 1

workbook window, 1, 2

display types, 1, 2, 3

resizing, 1

Workbook Wizard, 1, 2

workbooks, 1, 2

accessing, 1

assigning to users, 1, 2

associating data with, 1

canceling changes, 1

closing, 1

creating, 1, 2, 3, 4

optional steps, 1

creating subqueries, 1

defined, 1

deleting, 1

getting information about, 1

identifying location, 1

opening, 1, 2, 3, 4

multiple, 1, 2

non-Oracle, 1

reformatting, 1, 2

removing items, 1

renaming, 1

saving, 1, 2

selecting, 1, 2

selecting data, 1

selecting display types for new, 1

selecting multiple items, 1

setting properties, 1, 2

sharing, 1, 2

switching pages, 1, 2, 3

viewing, 1

worksheet

change subquery, 1

for subqueries, 1

worksheet tabs, 1, 2

worksheets, 1, 2

activating all, 1

adding bitmaps, 1

adding graphs, 1, 2, 3

adding items to new, 1

changing data, 1

choosing items, 1, 2

in multiple positions, 1

creating, 1, 2, 3

optional steps, 1

deleting items on new, 1

distributing via e-mail, 1

drilling across, 1, 2

editing new, 1, 2

editing titles, 1

formatting items, 1, 2

identifying workbook location, 1

large, 1

printing large, 1

refreshing, 1

removing items, 1

replacing data, 1

retrieving data, 1, 2, 3

for new crosstabs, 1

scheduled reports and, 1

selecting, 1, 2, 3

selecting data, 1

selecting display types for new, 1

selecting multiple items, 1

viewing, 1

Wrap Text option, 1, 2

X Labels command, 1

y-axis scale, 1

setting, 1, 2

z-axis, 1

Zip Codes, 1

zoom in, 1

zoom out, 1

Index

Symbols

Numerics

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z