Discoverer 4i Plus Online Help -- Index

!= operator in conditions, 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

access rights, 1

active folder, 1

Active Only option, 1

adding new items to layouts, 1

addition, 1

Advanced button (Conditions), 1

aggregations icon, 1

All Items option, 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

ascending sort order, 1

assigning workbooks, 1

automatic querying, 1

Average distinct option, 1

Average option, 1

averages, 1, 2, 3

axis item icon, 1

axis item value icon, 1

axis items, 1

moving data among, 1

sorting on, 1

viewing values, 1

Banding

Banding by rank, 1

Banding by value, 1

CASE, 1

with Analytical Functions, 1

BETWEEN operator, 1

Business area icon, 1

business areas

displaying, 1

selecting items, 1, 2

Calculation Examples, 1

calculation icon, 1

calculations, 1, 2

about, 1

displaying results, 1

exporting and, 1

viewing existing, 1

Calculations command, 1

canceling changes, 1

case-sensitive text filters, 1

changing data, 1

changing data formats, 1

choosing font options, 1

Close command, 1

closing workbooks, 1

columns, 1

group sorts and, 1

moving, 1, 2

complex calculations, 1

condition

parameter placeholder, 1

condition icon, 1

condition operators, 1

conditions

adding descriptions to, 1

applying, 1

assigning data items to, 1

conflicting, 1

creating definitions for, 1

editing definitions, 1

enabling/disabling definitions, 1

exporting and, 1

naming, 1

viewing definitions, 1

Conditions command, 1, 2

Conditions dialog box, 1, 2

copying SQL statements, 1

correlation, 1

Count Distinct option, 1

Count option, 1

covariance, 1

creating workbooks and worksheets

choosing data items, 1

Crosstab Layout command, 1

crosstab options, 1

crosstabs, 1, 2

drilling, 1

editing layouts, 1

getting data for new, 1

sorting data, 1, 2

adding data points, 1

group sorts and, 1

restoring previous state, 1

data

aggregating, 1

canceling changes, 1

filtering, 1

getting details, 1

retrieving, 1

for new crosstabs, 1

saving changes to, 1

selecting for drilling, 1

selecting for new worksheets, 1, 2

sorting, 1, 2

crosstabs and, 1, 2

in groups, 1, 2

totals for non-numeric, 1

data points

getting totals for, 1, 2

sorting, 1

databases

non-Oracle, 1

default aggregate, 1

Delete command, 1

deleting

items from workbooks and worksheets, 1

items on new worksheets, 1

workbooks, 1

descending sort order, 1

display options, 1

displaying

business areas, 1

items in folders, 1

SQL statements, 1, 2

distinct values, 1

drilling, 1, 2

basic procedure described, 1

data out of sequence, 1

to related items, 1

duplicate values, 1

Edit Condition dialog box, 1

Edit Parameter Values command, 1

Edit Sheet command, 1, 2

Edit Sheet dialog box, 1

adding/removing items, 1

editing

new worksheets and workbooks, 1

equality, 1

EUL (End User Layer), 1

Excel tool, 1

Excel workbooks, 1

Execution Plan

Materialized Views, 1

Export command, 1

expressions

defining for conditions, 1, 2

fan trap

about fan traps, 1

cartesian products, 1

Fan-Trap Detection, 1

files, 1

filters, 1

folders

active vs. unavailable, 1

viewing items, 1

Folders icon, 1

Font Options dialog, 1

formatting options, 1

functions, 1

Graphing

3D Effect, 1

Creating a Graph, 1

Font Options dialog, 1

graph types, 1

Graph Wizard, 1

Legend, 1

Legend dialog, 1

Plot Area dialog, 1

Positioning a graph, 1

X-Axis dialog, 1

Y1-Axis dialog, 1

group names, 1

group sorts, 1, 2

Hi to Lo sort order, 1

hidden column, 1

high values, 1, 2

icons (New Sheet dialog), 1, 2

1

Identifiers, 1

IN operator, 1

Insert Data Point Name option, 1, 2

Insert Item Name option, 1, 2

Insert Value option, 1, 2

IS NOT NULL operator, 1

IS NULL operator, 1

items

adding new, 1

deleting on new worksheets, 1

removing from workbooks and worksheets, 1

viewing in folders, 1

joins, 1, 2

labels

adding text codes

percentages and, 1

totals and subtotals, 1

removing text codes, 1, 2

layouts

changing, 1

LIKE operator, 1

linear regression, 1

Lo to Hi sort order, 1

low values, 1, 2

Match Case option, 1

Materialized View, 1

mathematical functions, 1

selecting, 1

Maximum option, 1

Microsoft Excel workbooks, 1

Minimum option, 1

monthly reports, 1

moving columns, 1

group sorts and, 1

New Calculation dialog box, 1

New command, 1

New Condition dialog box, 1

New Parameter dialog box, 1

New Sheet command, 1

New Sheet dialog box

icons described, 1, 2

moving items to Selected list, 1

non-numeric data totals, 1

non-Oracle databases, 1

NOT BETWEEN operator, 1

NOT IN operator, 1

NOT LIKE operator, 1

null values, 1

numbers, 1, 2

adding to new crosstabs, 1

getting totals and subtotals for, 1, 2

sorting, 1

numeric item icon, 1

Open command, 1

Open Workbook dialog box, 1

opening workbooks, 1, 2

non-Oracle, 1

operators, 1

conditional expressions, 1

Options button, 1, 2, 3, 4, 5, 6

Options command, 1, 2, 3, 4, 5, 6

Oracle 8.1.6+ database, 1

Oracle Applications

Connect dialog, 1

connect to Discoverer, 1

Prerequisites, 1

supported features, 1

Oracle Applications User, 1

page break, 1

page items

pivoting, 1, 2

parameters

calculations and, 1

creating, 1, 2

defined, 1

defining default, 1, 2

entering multiple values in, 1, 2

naming, 1, 2

selecting data items for, 1

uses for, 1

Parameters command, 1, 2

Parameters dialog box, 1, 2

passwords, 1

Percentage dialog box, 1

Percentage of Grand Total option, 1

percentages, 1, 2, 3

creating definitions for, 1, 2

editing definitions, 1

enabling/disabling definitions, 1

getting, 1

group sorts and, 1

not totaling 100%, 1

removing, 1

rounding and, 1

viewing definitions, 1

percentages columns

labeling, 1

Percentages command, 1

Percentages dialog box, 1, 2

opening, 1

Percentages tool, 1

pivot data, 1

plus signs (+) in dialog boxes, 1

Print command, 1, 2

Print dialog box

opening, 1

printing

worksheet, 1, 2

prompts, 1, 2

properties, 1, 2

Properties command, 1

queries

running, 1

running automatically, 1

Query Governor, 1

rearranging columns, 1

group sorts and, 1

removing items from workbooks and worksheets, 1

removing workbooks, 1

reordering columns, 1

group sorts and, 1

result sets, 1

rounding, 1

running queries, 1, 2

Save command, 1

saving workbooks, 1, 2

Scheduled Workbook, 1

Oracle Applications User, 1

Responsibilities, 1

scheduled workbooks, 1, 2

viewing results, 1

selecting

data for drilling, 1

data for new worksheets, 1, 2

servers, 1

setting properties

workbooks, 1, 2

setting sort order, 1

Sharing command, 1, 2

sharing workbooks, 1, 2

simple calculations, 1, 2

sort

hidden column, 1

Sort command, 1, 2, 3

Sort Crosstab dialog box, 1, 2

opening, 1

sort order, 1

reversing, 1

Sort Table dialog box, 1, 2

ordering columns in, 1

sorting data, 1, 2

crosstabs and, 1, 2

group sorting and, 1, 2

sorting options, 1, 2

SQL Inspector

Execution Plan, 1

SQL Inspector command, 1, 2

SQL statements, 1

standard deviation, 1

calculating, 1

Standard Deviation option, 1

Statistics, 1

subtotals

finding percentages of, 1

getting, 1

getting percentages for, 1

removing, 1

viewing definitions, 1

sum distinct, 1

Sum option, 1

summary data, 1

Summary Folder, 1

summary table, 1

sums, 1

Table Layout command, 1

table options, 1

tables, 1, 2

drilling, 1

editing layouts, 1

moving columns, 1

group sorts and, 1

sorting data, 1, 2

text

case-sensitive filters, 1

data points and totals for, 1

defining conditions for, 1

mathematical functions and, 1

sorting, 1, 2

text codes

adding to labels

percentages columns, 1

totals and subtotals, 1

removing, 1, 2

titles

totals and subtotals, 1

Total dialog box, 1

totals, 1, 2

creating definitions for, 1

editing definitions, 1

enabling/disabling definitions, 1

finding percentages of, 1

getting percentages for, 1

placement options, 1

removing, 1

viewing definitions, 1

Totals command, 1

Totals dialog box, 1

Totals tool, 1

unavailable folders, 1

unique values, 1

User -> Workbook tab, 1

Value(s) option (Conditions), 1

values, 1

counting unique, 1

creating conditions for, 1

getting totals and subtotals for, 1

null, 1

sorting and duplicate, 1

viewing for axis items, 1

variables, 1

Variance option, 1

View Conditions For option, 1

viewing

business areas, 1

file types, 1

items in folders, 1

SQL statements, 1, 2

weekly reports, 1

"what if" scenarios, 1

wizards

for creating workbooks, 1

Workbook -> User tab, 1

Workbook properties

Description box, 1

Identifiers, 1

Workbook Wizard, 1

workbooks

assigning to users, 1

canceling changes, 1

closing, 1

deleting, 1

opening, 1, 2

non-Oracle, 1

removing items, 1

saving, 1, 2

selecting data, 1

selecting multiple items, 1

setting properties, 1, 2

sharing, 1, 2

Worksheet Wizard, 1

worksheets

adding items to new, 1

changing data, 1

deleting items on new, 1

open with parameters, 1

parameters, 1

printing, 1, 2

removing items, 1

retrieving data, 1

for new crosstabs, 1

scheduled reports and, 1

selecting data, 1

selecting multiple items, 1

XLS files, 1

Index

Symbols

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

V

W

X