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