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, 23, 23
Numerics
- 80-20 analysis, 23
A
- about Discoverer Plus Relational, 2.1
- advanced options, 22.3.5
- automatic querying, 22.3.5.1
- fan traps, 22.3.5.2
- aggregation for multidimensional data, 3.11
- analytic function examples, A.6
- analytic function templates
- Band by Rank, 23
- Band by Value, 23
- Difference, 23
- Following Value, 23
- Group Total, 23
- Moving Total, 23
- Percent Contribution, 23
- Percent Difference, 23
- Percent Rank, 23
- Percent Running Contribution, 23
- Preceding Value, 23
- quartiles, 23
- Rank, 23, 23
- Running Total, 23
- 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, 22.3.5.1
- axis items
- about, 5.6
B
- banding, 23
- 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, 23, 23
- example, 11.6
- CASE statements, A.2, A.6.5.1
- Catalog, Discoverer, 3.13
- column width, 7.1, 23
- concatenated items, 17.1
- Conditional formatting, 2.7
- 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, 23, 23
- 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, 23
- 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, 22.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 Gauge portlet
- adding, 21.14
- Discoverer List of Worksheets portlet
- adding, 21.12
- 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 Portlet Provider
- Gauges portlet, 21.3.3
- List of Worksheets portlet, 21.3.1, 21.3.1
- types, 21.3
- using, 21.12, 21.13, 21.14
- Worksheet portlet, 21.3.2
- Discoverer Viewer
- customizing worksheets, 21.17
- Discoverer work area
- about, 5.1
- Discoverer Worksheet portlet
- adding, 21.13
- div/0 error, 23, 23
- divide by zero error, 23, 23
- Drill dialog, 23
- 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
- Enhanced interactivity, 2.7
- examples of analytic functions, A.6
- Excel
- exporting to, 19.3
- row limits, 19.3
- support for export to, 19.3
- execution plans, 22.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, 23
- security level in Microsoft Excel, 23
- to Microsoft Excel, 19.3
- to Oracle Reports, 19.2
- troubleshooting Excel macro error, 23
- worksheets and graphs, 19.5
F
- fan traps, 22.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, 23
- functions
- analytic function examples, A.6
G
- Gauges portlet, 21.3
- graphs
- about, 8.1
- adding reference lines, 23, 23
- 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, 23
- 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, 23
- List of worksheets portlet, 21.3
- LOVs
- about, 22.2.1
- and cascading parameters, 11.6, 23, 23
- examples, 22.2.2
- selecting multiple values, 22.2.3.2
- selecting single values, 22.2.3.1
- using long LOVs, 22.2.3
M
- macros
- in Microsoft Excel, 23
- Manage Links dialog, 23
- 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, 23
- 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, 22.3.5.3
N
- Native support of the database OLAP option, 2.7
- new features, 2.7
- New Link dialog, 23
- non-Oracle databases, 6.8
O
- OLAP
- why use, 3.3
- online analytic processing
- defined, 3.3
- ORA-01858 error message, 23
- 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
- OracleAS Portal
- about, 21.1, 21.1
- adding a Gauge Portlet, 21.14
- adding a List of Worksheets Portlet, 21.12
- adding a Worksheet Portlet, 21.13
- Discoverer Gauges portlet, 21.3.3
- Discoverer List of Worksheets portlet, 21.3.1
- Discoverer portlet types available, 21.3
- Discoverer Worksheet portlet, 21.3.2
- portlet types available, 21.3
- what you need, 21.4
P
- Page Setup options, 18.3
- for graphs, 18.4
- parameters
- about filtering parameter LOVs by specifying associated conditions, 11.6
- cascading, 11.6, 23, 23
- creating, 11.10
- deleting, 11.11
- entering reserved words, 23
- examples, 11.12
- mapping to Discoverer Portlet parameters, 21.18.1
- Parameters dialog, 23
- Pareto analysis, 23
- password
- changing, 4.7.8
- PDF
- creating by printing, 18.8
- creating using export, 19.1
- page size constraints in Letter format, 23
- Percent Rank
- and conditions, 23, 23
- Percentage Contribution
- and conditions, 23, 23
- percentage values as decimal, 23, 23
- 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
- portlet parameters, 21.18.1
- portlets
- about Gauges portlet, 21.3.3
- about List of Worksheets portlet, 21.3.1
- about Worksheet portlet, 21.3.2
- customizing, 21.16
- customizing in Discoverer Viewer, 21.17
- editing, 21.15
- Gauges, 21.14
- List of Worksheets, 21.12
- Worksheet, 21.13
- 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, 23
- queries
- OLAP, 3.3
R
- reference lines, 23
- relational data sources, 2.2
- reserved word
- enter in parameter field, 23
- TODAY, 23
S
- sample database, 2.6
- scheduled workbooks
- about, 22.1.1, 22.1.3
- accessing results, 22.1.4
- copying, 22.1.8
- creating, 22.1.6
- editing, 22.1.7
- how to delete results, 22.1.10
- how to schedule workbooks, 22.1.6
- how to unschedule, 22.1.9
- processing, 22.1.5
- sharing, 20.2
- when to use, 22.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
- Single Sign-On support for Virtual Private Databases, 2.7
- 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, 22.4, 22.4.1
- and execution plans, 22.4.5
- and summaries, 22.4.3
- and summary folders, 22.4.4
- how to view, 22.4.7
- how to view an execution plan, 22.4.8
- using, 22.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, 23, 23
- TODAY reserved word, 23
- 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 OracleBI, 14.6
- migrating totals to OracleBI 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 portlet, 21.3
- worksheet properties
- about, 6.26
- editing, 6.27
- view identifier, 6.27
- worksheet settings
- about, 22.3.1
- changing, 22.3
- how to change, 22.3.2
- reverting to default, 22.3.3
- worksheet text
- creating, 6.15
- worksheet title
- about editing, 6.15
- text limit, 23, 23
- text variables, 23, 23
- 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, 22.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