Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  T  U  W 

Symbols

% values as decimal, 22, 22

Numerics

80-20 analysis, 22

A

about Discoverer Plus Relational, 2.1
advanced options, 21.3.5
automatic querying, 21.3.5.1
fan traps, 21.3.5.2
aggregation for multidimensional data, 3.11
analytic function examples, A.6
analytic function templates
Band by Rank, 22
Band by Value, 22
Difference, 22
Following Value, 22
Group Total, 22
Moving Total, 22
Percent Contribution, 22
Percent Difference, 22
Percent Rank, 22
Percent Running Contribution, 22
Preceding Value, 22
quartiles, 22
Rank, 22, 22
Running Total, 22
analytic functions, 17.3
about, 17.3
and sequencing, A.6.11
applying conditions, A.6.11
banding, A.6.5, A.6.15.1, A.6.16
banding using CASE statement, A.6.5.3
banding using GREATEST(), A.6.5.2
banding with WIDTH_BUCKET, A.6.16.1
categories, A.6.1
creating using templates, 17.3, 17.7
examples of sequencing, A.6.12
FIRST/LAST, A.6.17
how to create, 17.3
hypothetical rank, A.6.15, A.6.15.1
inverse percentile, A.6.13
LAG(), A.6.8.2, A.6.8.3
LAG/LEAD, A.6.8
linear regression, A.6.9.2
MAX(), A.6.17.1
MIN(), A.6.17.2
PERCENTILE_CONT(), A.6.14.2
PERCENTILE_DISC(), A.6.14.1
RANK(), A.6.4.2, A.6.4.3, A.6.4.4, A.6.8.4
ranking, A.6.4
reporting, A.6.7
reporting using RATIO_TO_REPORT(), A.6.7.5
reporting using SUM(), A.6.7.2, A.6.7.3, A.6.7.4
sequencing examples, A.6.12
statistical functions, A.6.9
templates available, 17.4
using templates with parameters, 17.7
windowing, A.6.6
windowing using AVG(), A.6.6.2
windowing using SUM(), A.6.6.3, A.6.6.4
attributes, 3.9
automatic querying, 21.3.5.1
axis items
about, 5.6

B

banding, 22
business areas
about, 2.3

C

calculations
about, 17.1
concatenated items, 17.1
creating, 17.6
deleting, 17.9
displaying and hiding, 17.5
editing, 17.8
examples, 17.10
mathematical, A.5
providing dynamic input to, A.4
removing carriage returns, 17.1
ROWCOUNT, A.5
UPPER, A.5
using, 17.2
carriage returns in calculations, 17.1
cascading parameters, 11.6, 22, 22
example, 11.6
CASE statements, A.2, A.6.5.1
Catalog, Discoverer, 3.13
column width, 7.1, 22
concatenated items, 17.1
conditions
about, 13.1
and aggregates, 13.12
and roll-up values, 13.12
applying more than one, 13.5
applying to roll-ups, 13.12
creating multiple, 13.8
creating nested, 13.9
creating single, 13.7
deleting, 13.11
editing, 13.10
examples, 13.14
IF statements, A.6.5.1
multiple conditions, 13.2
nested conditions, 13.3
on Percent Rank or Percentage Contribution calculations, 22, 22
order of application with analytic functions, A.6.11
turning on, 13.6
using, 13.4
connections
about (see Discoverer connections), 4.1
crosstab worksheets, 6.5
cubes in multidimensional data sources, 3.5
cumulative distribution, 22
currency symbol
how to set, 7.8

D

data points
about, 5.7
database
sample, 2.6
database accounts
about, 4.7.2
DECODE, A.2, A.6.5.1
default worksheet format, 21.3.4
deleting
workbooks, 6.13
worksheets, 6.20
designing workbooks, 6.6
dimensions
attributes, 3.9
defined, 3.7
filters, 3.12
hierarchies, 3.8
Discoverer
changing passwords, 4.7.8
getting data, 1.4.1
how to change passwords, 4.7.9
how to exit, 4.6
how to start, 4.2
how to start using a connection, 4.4
workflow, 1.4
Discoverer Catalog, 3.13, 3.13
Discoverer connection
user defined, 4.7.7
Discoverer connections
about, 4.1
about public, 4.7.6
changing EULs, 4.7.10
creating, 4.7.3
deleting, 4.7.5
editing, 4.7.4
private, 4.7.7
Discoverer manager
about the, 1.6
Discoverer Plus Relational
about, 2.1
menus, 5.3
new features in release 10.1.2, 2.7
sample database, 2.6
toolbars, 5.4
Discoverer work area
about, 5.1
div/0 error, 22, 22
divide by zero error, 22, 22
Drill dialog, 22
drill hierarchies
about, 10.2
default, 10.2
multiple, 10.2
drill links
about, 10.8, 10.8.1
creating, 10.9, 10.9.1, 10.9.2
defined by Discoverer manager, 10.8.2
types, 10.8
using, 10.8.3, 10.10
drill out, 10.8.2
drilling
about, 10.1
drill hierarchies, 10.2
how to drill in graphs, 10.3.2
how to drill to detail, 10.7
how to drill up and down, 10.3
out, 10.8.2
to detail, 10.6
to related items, 10.4, 10.5
with drill links, 10.8.1

E

examples of analytic functions, A.6
Excel
exporting to, 19.3
row limits, 19.3
support for export to, 19.3
execution plans, 21.4.6
exiting Discoverer
how to exit, 4.6
exporting
about, 19.1
accessing exported files, 19.7
and page items, 19.6
how to export data, 19.8
macro settings, 22
security level in Microsoft Excel, 22
to Microsoft Excel, 19.3
to Oracle Reports, 19.2
troubleshooting Excel macro error, 22
worksheets and graphs, 19.5

F

fan traps, 21.3.5.2
filtering parameter LOVs by associating conditions with a parameter, 11.6
filters for aggregation, 3.11
Find dialog
using to find worksheet data, 6.21
finding worksheet data, 6.21
folders
about, 2.4
frequency distribution, A.6.5.1
frequency distribution analysis, 22
functions
analytic function examples, A.6

G

graphs
about, 8.1
adding reference lines, 22, 22
components, 8.3
creating, 8.10
creating bubble graphs, 8.6
creating dual-Y charts, 8.8
creating hi-low-close stock charts, 8.7
creating pie graphs, 8.9
drilling in, 10.3.2
editing, 8.11
positioning, 8.12
reference lines, 8.3, 22
sub-types, 8.4
types available, 8.5
using, 8.2

H

headings
changing, 7.10
help system
about, 2.8, 3.15
hierarchies, 3.8
hierarchy
drill hierarchies, 10.2

I

identifiers
editing worksheet properties, 6.27
in workbook properties, 6.25
IF statements, A.2
IF statements in conditions, A.6.5.1
item headings
changing the format, 7.10
items
about, 2.5

L

Letter page size
PDF constraints, 22
LOVs
about, 21.2.1
and cascading parameters, 11.6, 22, 22
examples, 21.2.2
selecting multiple values, 21.2.3.2
selecting single values, 21.2.3.1
using long LOVs, 21.2.3

M

macros
in Microsoft Excel, 22
Manage Links dialog, 22
maximizing Discoverer performance, 6.6
measures, 3.6
median, A.6.14.1
calculating the, A.6.14.1
medians
calculating, A.6.13
Microsoft Excel
troubleshooting exported files, 22
migration
Discoverer 4i totals, 14.6, 14.7, 14.8
multidimensional data sources, 3.4
aggregation, 3.11
attributes, 3.9
cubes, 3.5
dimensions, 3.7
filters, 3.12
hierarchies, 3.8
measures, 3.6
multiple join paths, 21.3.5.3

N

new features, 2.7
New Link dialog, 22
non-Oracle databases, 6.8

O

OLAP
why use, 3.3
online analytic processing
defined, 3.3
ORA-01858 error message, 22
Oracle Applications
about, B.1
Discoverer support for, B.2
how to start Discoverer using, B.5
prerequisites, B.3
Oracle Reports
opening XML files, 19.2

P

Page Setup options, 18.3
for graphs, 18.4
parameters
about filtering parameter LOVs by specifying associated conditions, 11.6
cascading, 11.6, 22, 22
creating, 11.10
deleting, 11.11
entering reserved words, 22
examples, 11.12
Parameters dialog, 22
Pareto analysis, 22
password
changing, 4.7.8
PDF
creating by printing, 18.8
creating using export, 19.1
page size constraints in Letter format, 22
Percent Rank
and conditions, 22, 22
Percentage Contribution
and conditions, 22, 22
percentage values as decimal, 22, 22
percentages
about, 15.1
creating, 15.3
deleting, 15.5
displaying and hiding, 15.2
editing, 15.4
examples, 15.6
percentile analysis, A.6.5.1
performance
maximizing Discoverer, 6.6
worksheet design, 6.6
pivoting
about, 9.1
on crosstab worksheets, 9.2
unexpected results, 9.5
printing
how to print, 18.6, 18.7
output options, 18.5
Page Setup options, 18.3
PDF format, 18.8
print dialog, 18.5
scaling, 18.5
worksheet and graph on same page, 8.2, 18.1
worksheet elements, 18.2
private connections, 4.7.7

Q

quartiles, A.6.5.1
creating, 22
queries
OLAP, 3.3

R

reference lines, 22
relational data sources, 2.2
reserved word
enter in parameter field, 22
TODAY, 22

S

sample database, 2.6
scheduled workbooks
about, 21.1.1, 21.1.3
accessing results, 21.1.4
copying, 21.1.9
creating, 21.1.7
editing, 21.1.8
how to delete results, 21.1.11
how to schedule workbooks, 21.1.7
how to unschedule, 21.1.10
processing, 21.1.5
sharing, 20.2
when to use, 21.1.2
sharing workbooks
about, 20.1, 20.2
with a single user, 20.3.2
with multiple users, 20.3.1
Single Sign-on
about, 4.7.11
passwords and Discoverer passwords, 4.7.12, 4.7.13
sorting
about, 16.1
about group sorting, 16.4
changing sort item, 16.7
examples, 16.9
on crosstab worksheets, 16.3, 16.6
on table worksheets, 16.2, 16.5
removing, 16.8
SQL
about, 21.4, 21.4.1
and execution plans, 21.4.5
and summaries, 21.4.3
and summary folders, 21.4.4
how to view, 21.4.7
how to view an execution plan, 21.4.8
using, 21.4.2
starting Discoverer
directly, 4.5
how to start, 4.2, 4.4
symbol
setting the currency symbol, 7.8

T

table worksheets, 6.4
templates
for analytic functions, 17.3
using, 17.7
title
about editing worksheet title, 6.15
worksheet, 22, 22
TODAY reserved word, 22
totals
about SUM and Cell SUM, 14.3
Cell SUM, 14.3
creating, 14.10
deleting, 14.12
displaying and hiding, 14.9
editing, 14.11
examples, 14.13
migrating totals to Oracle BI, 14.6
migrating totals to Oracle BI Discoverer, 14.8
migration from Discoverer 4i, 14.6, 14.7, 14.8
on crosstab worksheets, 14.2
SUM, 14.3
when to use Cell SUM, 14.5
when to use SUM, 14.4

U

user defined connection, 4.7.7

W

work area, 5.1
drag and drop features, 5.2
menus, 5.3
tool tips, 5.4.6
toolbars, 5.4
workbook properties, 6.25
workbooks
about, 6.1
adding new worksheets, 6.24
creating, 6.22, 6.23
deleting from database, 6.13
designing for maximum performance, 6.6
editing, 6.9
non-Oracle databases, 6.8
opening, 6.7
renaming, 6.17
reordering, 6.18
saving, 6.10, 6.11, 6.12
viewing properties, 6.25
worksheet data
finding, 6.21
worksheet properties
about, 6.26
editing, 6.27
view identifier, 6.27
worksheet settings
about, 21.3.1
changing, 21.3
how to change, 21.3.2
reverting to default, 21.3.3
worksheet text
creating, 6.15
worksheet title
about editing, 6.15
text limit, 22, 22
text variables, 22, 22
worksheet wizard
about, 5.8
worksheets
about, 6.2
about table, 6.4
adding items, 7.3, 7.4
changing the format, 7.7, 7.9
crosstab, 6.5
default format, 21.3.4
deleting, 6.20
designing for maximum performance, 6.6
duplicating, 7.6
editing, 7.1, 7.2
performance, 6.6
refreshing, 6.19
removing items, 7.5
renaming, 6.17
reordering, 6.18
types of, 6.3