Oracle Discoverer Administration Edition Administration Guide -- Index

accessing

business areas, 8-1

data, 1-5, 8-1

online help, 3-20

PL/SQL functions, 12-13

adding

folders to business areas, 3-10, 6-9

items to complex folders, 4-60, 4-63

items to folders, 3-10

items to hierarchies, 4-66, 4-68, 4-75

items to joins, 11-3, 11-7

objects to business areas, 7-5

tables and views to business areas, 7-10

address records, 4-56

Administration Edition, 1-2

access rights and privileges, 8-1

insufficient, A-23

client errors, A-1

described, 1-5

main window, 3-6, 4-16

Administration privilege, 8-2

administrators, xxi

maintaining assigned privileges, 8-10, 17-25

maintaining EUL, 5-8

predefining items, 12-4

role defined, 1-1, 1-9

setting up EUL, 1-10

tasks summarized, 1-9

aggregate calculations, 12-2 to 12-3

defined, 12-2

restrictions, 12-3

aggregate derived items, 12-2

aggregate functions

aggregated detail items, 4-82

aggregated items

examples, 4-57

summary tables and, 15-19

viewing, 3-11

aliases, 6-8

alphabetical listing of errors, A-1

Alternative Sort tab, 10-16

alternative sorts, 1-8, 10-3

changing sort sequences, 10-16

tutorial, 4-49

viewing attributes, 3-16

analysis, 1-9, 4-37

item hierarchies and, 14-6

simplifying, 4-60, 4-85

ANALYZE TABLE command, C-2

applications

Discoverer components and, 1-4

launching external, 4-79, 4-80

workbook scheduling and, 9-2

Applications Mode EUL, D-12

Apply button, 4-26

Arguments tab (PL/SQL), 12-15

arithmetic operations, 3-11

invalid types in, A-23

ASM

assigning

items to date hierarchies, 4-76

rights and privileges

End User Layer, 5-2

tutorial, 4-17 to 4-24

user IDs to databases, 7-6

attributes, 3-17

assigning to business areas, 7-11

viewing, 3-16

auto-load options, 4-12

automated summary management

asm, 16-1

auto-starting with tasklist, 3-6

AVG function, 12-2, 12-4

axis item icon, 3-11

axis items, 7-12

aggregates and, 12-2, 12-3

in reports, 4-89

selecting, 3-11

setting display sequence, 4-42

summary tables and, 15-18

axis position options, 3-11

batchusr.sql, 2-3

BFILE - Content Type, 10-7

bulk load

asm, 16-4

running ASM after, 16-4

bulk loads, 4-14

business area icon, 3-9

business areas, 3-5, 7-2

business example, 4-1

buttons (toolbar), 3-19

calculated items, 12-4

creating

tutorial, 4-55 to 4-57

creating joins with, 11-7

calculations, 6-2, 12-1

creating

tutorial, 4-55

examples, 4-56

aggregates, 12-2, 12-3

derived items, 12-2, 12-3

restrictions for aggregate, 12-3

syntactical reference, 12-7

types described, 12-1

calculations, getting more information, 12-5

Cartesian products, 11-6

case storage attribute, A-16

catch-all summaries, 15-18

changing

business areas

tutorial, 4-25 to 4-31

condition type, 13-2

content types, 4-79

item names in complex folders, 6-5

options in dialogs, 4-26

property settings, 6-10

characters, 4-68

invalid, A-12

choosing

data sources, 7-3, 7-14

items

for item classes, 4-46

for summary reports, 4-88, 4-89

from list of values, 4-48

in hierarchies, 4-68, 4-75

menu commands, 3-19

circular references, A-13

client errors, A-1

client/server applications

Discoverer components and, 1-4

workbook scheduling and, 9-2

closing

business areas, 3-10

dialog boxes, 4-26

tasklist, 3-6

columns, 1-6, 1-7, 4-29, 4-79, 6-2

aliasing expressions in, 6-8

analyzing details, 2-11

mapping to summary tables

example, 15-18

tutorial, 4-89

resizing, A-4

command line interface

/asm, D-32

/delete, D-19, D-21, D-26

/eul, D-34

/keep_format_properties, D-36

/lov, D-37

/refresh_bus_area, D-23

/refresh_summary, D-22, D-24, D-25

case-sensitivity, D-3

change existing standard database user to an Oracle Applications user, D-14

command rules, D-3

connect as an Oracle Applications user, D-15

command-line interface, D-1

command-line options, D-1

syntax, D-4

commits, 8-14

complex folder icon, 3-10

complex folders, 6-1 to 6-5

adding items, 3-10, 4-60, 4-63

creating, 4-60 to 4-65

mandatory conditions and, 6-5, 13-2

Conceptually Identical Objects, 7-19

condition icon, 3-11

conditions, 3-17

adding multiple join, 11-4

aggregates and, 12-3

calculated items and, 12-8

changing type, 13-2

creating

tutorial, 4-63 to 4-65

creation errors, A-9, A-20, A-39

displaying existing, 3-11

duplicate names, A-2

invalid, A-4

mandatory, 6-3

types described, 13-2

Confirm Folder Delete dialog, 6-18, 10-24, 11-12, 12-11, 13-11, 14-17, 15-51

CONNECT BY clauses (SQL), 6-8

Connect dialog box, 3-2

connect.cmd, D-6

connection errors, A-20, A-45

connections, D-6

getting information about, 3-20

Content Type

avi, 10-7

BFILE, 10-7

BLOB, 10-7

CLOB, 10-7

LCLOB, 10-7

Content Type property

usage tutorial, 4-79

copied items, 4-60, 6-3

Copy command, 6-3

copying folders, 6-3

corrupted files, fixing, A-12, A-31

Cost optimizer, 2-11

Create EUL Wizard, 5-5, 5-6

Create Procedure privilege, 2-3

Create Subquery option, 6-8

Create Table privilege, 2-3

Create View privilege, 2-3

create.cmd, D-6

creating

cross tab worksheets

placing items, 7-12

Custom Folder dialog, 4-33, 6-6

custom folder icon, 3-11

Custom Folder Properties dialog, 6-14

Custom Folder Properties dialog box, 4-35

custom folders

aliasing expressions in, 6-8

creating, 6-6

editing SQL statements, 6-13

queries and, 6-8

setting properties, 6-4

tutorial for creating, 4-31 to 4-36

customizing items tutorial, 4-41 to 4-59

cyclic hierarchies, A-6

data

data integrity, 1-5

data point item icon, 3-11

data point items, 7-12

data points

creating, 3-11

data sources, 7-3

Oracle Designer and, 7-14

Data tab, 3-8 to 3-9

data types

axis items and, 7-12

incompatible, A-3

invalid, A-6, A-20, A-23, A-30, A-41, A-45

database administrators, xxi

Database Information command, 2-9, 3-20

database links, 7-6

database servers

connection errors, A-20, A-45

reducing load, C-1

testing operational parameters, 2-10

databases, 1-2, 1-5

access rights and privileges, 8-1

connecting to, 3-2

defining hierarchical relationships, 14-1

duplicate links, A-7

generated values and, 1-8

invalid links, A-30

loading tables, 7-7

non-Oracle, 1-9

calculations and, 6-3

creating EULs, 5-4

workbook scheduling and, 2-1

row retrieval limits, 8-12

setting data limits, 2-2

date hierarchies, 4-68

associating with items, 4-76

automating creation of, 4-74

creating

tutorial, 4-74 to 4-77

invalid date formats, A-30

moving through, 4-78

selecting items, 4-75

viewing, 3-13

Date Hierarchy

changing a Template, 14-15

items removed, 14-15

Date Hierarchy Template - applying to a Date Item, 14-15

date hierarchy template folder icon, 3-14

date hierarchy templates, 4-74

viewing, 3-14

Date Items - applying Date Hierarchy Templates, 14-15

date template icon, 3-14

date templates, 14-3

dates

invalid types, A-41, A-45

DBMS_JOB package, 2-1, 15-20

installing, 2-1, 2-5

not installed, A-38, A-41

defaults

date hierarchies, 14-4

formatting, 7-11

privileges, 8-4, 8-5, 8-9, 17-19, 17-21, 17-24

properties, 1-8

delete.cmd, D-6

deleting

End User Layers, 5-8

folders from business areas, 6-18

demonstration database, 4-1

dependencies, missing, A-21

derived items, 12-2

aggregate, 12-2, 12-3

defined, 12-2

PL/SQL functions and, 12-13

descriptions

business areas, 7-13

tutorial for adding, 4-25

folders

tutorial for adding, 4-26

item classes

changing, 10-17

items

tutorial for adding, 4-29

joins, 11-4

maximum length, A-7

detail folders

changing items, 11-6

detail items

adding to joins, 11-4

creating, 4-38

drilling to, 10-4

tutorial, 4-82

joins and, 11-2, 11-7

null values and, 11-5

reassigning, 11-6

with no master, 11-5

Detail to Master icon, 11-7

detail-to-master join icon, 3-11

detail-to-master joins, 3-11

viewing primary/foreign keys, 3-11

dialog boxes, 4-26

selecting options, 4-26

dictionary, 7-4, 7-5

options, 7-7

dis4adm.exe, D-6

Discoverer

components, 1-2 to 1-4

getting help, 1-11

internal errors, A-24

overview, 1-1 to 1-7

Discoverer 4i Plus, 1-5

Discoverer 4i Viewer, 1-5

Discoverer Plus, 1-2

described, 1-5

enabling query prediction, 2-9

selecting values in list, 4-48

viewing conditions, 4-65

displaying

default privileges, 8-4, 8-5, 8-9, 17-19, 17-21, 17-24

documentation

typographical conventions, xxi

drilling, 1-8

setting drilldown sequence, 14-6

through hierarchies, 3-12

tutorial, 4-66, 4-72, 4-74

through summary reports, 4-82

to detail items, 10-4

tutorial, 4-82

drill-to-detail item classes, 4-82, 10-4

tutorial for creating, 4-82

duplicate database links, A-7

duplicate names

conditions, A-2

formulas, A-13

joins, A-3

summary tables, A-7

duplicating items, 4-60

Edit Calculation dialog, 4-56

Edit Custom Folder dialog, 4-35, 6-14

Edit Item Class dialog, 4-83

edit items in the business area, 8-2

editing

SQL statements, 4-34 to 4-36, 6-4, 6-13

EEX file format, 7-19

equality, 11-4

equi-joins, 4-39, 11-4

equivalent values, 4-39

error messages, A-1

errors, A-1

found by database, A-37

undocumented, A-2

with no messages, A-35, A-44

EUL, 1-2, 5-1

EUL Gateway, 7-5

how to set up an EUL Gateway, 7-4

EUL Manager, 5-3

creating EULs, 5-5

installing tutorial, 5-14

opening, 5-4

uninstalling tutorial, 5-15

EUL Manager command, 5-4

EUL_DATE_TRUNC function, 14-12

example database, 4-1

Export

export

aliases in column, 6-8

circular references, A-13

creating for joins, 11-4

external application icons, 4-80

external applications, 4-79, 4-80

fan trap detection, 11-6, 11-12

fetching data, 6-8

setting retrieval limits, 8-12

with conditions, 4-63

files

fixing corrupted, A-12, A-31

inaccessible system, A-39

unable to save, A-20

unabled to open, A-20

folder icons, 3-10, 3-14

Folder Properties sheet, 4-28

folders, 1-7, 3-5

foreign keys

null values and, 11-5

viewing, 3-11

format masks

invalid, A-31, A-32

maximum length, A-21

formatting defaults, 7-11

formulas

adding to conditions, 13-2

aggregates and, 12-2

circular references, A-13

duplicate names, A-13

editing in custom folders, 6-4

invalid, A-31

invalid operators, A-33

maximum length, A-21

mismatched parentheses, A-13

uncategorized errors, A-14

unfinished, A-14

unknown functions, A-14

unqualified names, A-13

unrecognized items, A-13

functions

EUL_DATE_TRUNC, 14-12

Functions tab (PL/SQL), 12-14, 12-15

Gateway User ID, D-13

gateways, 7-4

refreshing from, 7-27

General tab

item classes, 10-17

granting rights and privileges

End User Layer, 5-2

tutorial, 4-17 to 4-24

Help Topics command, 3-20

hiding items, 4-41, 4-42

hierarchical relationships, 14-1

hierarchies, 1-8

Hierarchies tab, 3-12 to 3-13

hierarchy icon, 3-14

hierarchy templates, 3-14, 4-74

viewing, 3-12

Hierarchy Wizard

selecting items

from multiple folders, 14-6

tutorial, 4-66

hints, 6-8

HTML documents, 4-79

hyperdrilling, 1-8, 10-4

See also drill-to-detail item classes

icons, 3-5

external applications, 4-80

toolbar, 3-19

work area, 3-9

Identifiers, 7-18

using to match objects, 7-22

Impact dialog box

opening, 6-19, 7-26, 10-24, 11-12, 12-11, 13-11, 14-17, 15-51

Import Business Area dialog, 7-19

Import command, 7-19

Import PL/SQL Functions dialog, 12-16

Import Wizard

element match actions, 7-21

element match options, 7-21

importing EUL elements, 7-18

importing PL/SQL functions, 12-13, 12-15

inaccessible folders, A-40

incompatible data types, A-3

inequality, 11-4

INIT<SID>.ORA file, 2-4

job_queue_interval parameter, 2-4

optimizer_mode parameter, 2-11

timed_statistics parameter, 2-10

initialization file, 2-4

INITORCL.ORA, 2-5

Inline Views, E-6

input, 1-8

Install the Tutorial Wizard, 5-12 to 5-14

installation

DBMS_JOB package, 2-1, 2-5

tutorial, 5-6, 5-8, 5-11

errors during, 5-12

multiple copies, 5-14

integers, 7-12

internal errors, A-24

invalid argument names, A-29

invalid characters, A-12

invalid conditions, A-4

invalid data types, A-6, A-20, A-23, A-30, A-41, A-45

invalid formulas, A-31

invalid functions, A-22, A-31

item class icon, 3-17

Item Class Wizard

tutorial for creating classes, 4-45 to 4-48

tutorial for drilling, 4-82

item classes

alternative sorts and, 4-49, 10-4

creating, 3-14, 3-17, 10-2

for list of values, 10-9

tutorial, 4-45 to 4-48

defined, 10-2

display options, 3-15

displaying associated items, 3-15, 3-17

folders inaccessible, A-40

overview, 10-2 to 10-4

renaming, 10-17

selecting items, 4-46

viewing values, 3-17

Item Classes tab, 3-14 to 3-17

Item Formula property, 6-4

item group icon, 3-17

item hierarchies, 4-68

creating

complex, 4-72

tutorial, 4-66 to 4-74

selecting items, 4-68

viewing, 3-13

Item Properties sheet, 4-30

items, 1-7

adding to complex folders, 4-60, 4-63

adding to folders, 3-10

adding to hierarchies, 4-66, 4-68, 4-75

adding to joins, 11-3, 11-7

alternative sorts and, 10-4

assigning to date hierarchies, 4-76

calculations and predefined, 12-4

case storage attribute, A-16

changing content type, 4-79

creation errors, A-9

custom folders and, 6-4

customizing tutorial, 4-41 to 4-59

displaying associated class, 3-15

displaying in folders, 3-10

hiding, 4-41, 4-42

naming, 3-10

PL/SQL functions and, 12-13

placing on cross tabs, 7-12

renaming, 4-29, 6-5

reordering, 3-10

selecting

for item classes, 4-46

for summary reports, 4-88, 4-89

from list of values, 4-48

setting display axes, 4-42

setting properties, 10-2

sharing similar attributes, 10-2

style attribute, troubleshooting, A-19

job_queue_interval parameter, 2-4

job_queue_processes parameter, 2-4

Join command, 11-3

join icons, 3-11, 11-7

Join Options dialog, 11-5

joins

language setting - Oracle Applications, 17-8

launching external applications, 4-79, 4-80

links

database to user, 7-6

duplicate database, A-7

invalid database, A-30

list of values, 10-2

creating, 3-17

for item classes, 10-9

tutorial, 4-44 to 4-49

displaying attributes, 3-16

getting from EUL, 4-47

querying, 6-8

selecting, 10-15

selecting items, 4-48

list of values icon, 3-17

List of Values tab, 10-15

literals, 11-7

load options, 4-7, 4-12

Load Wizard, 3-4

tutorial, 4-7 to 4-15

loading tables, 7-7

tutorial, 4-10 to 4-11

lossless joins, 11-5

main window, 3-6, 4-16

Manage Folders dialog, 6-15, 6-16

mandatory conditions, 6-3

changing status, 13-2

optional condition vs., 13-2

manual registration (PL/SQL), 12-13

Manuals command, 3-20

many-to-many joins, 11-2

many-to-one joins, 11-7

many-to-one relationships, 3-11

mapping columns

master folders

master items

in multi-item joins, 11-7

reassigning, 11-6

selecting, 11-3

Master to Detail icon, 11-7

master-detail relationships, 11-2

master-to-detail join icon, 3-11

master-to-detail joins, 3-11

viewing primary/foreign keys, 3-11

mathematical operations, 3-11

invalid types in, A-23

measure items, 4-89

menus, 3-7

shortcuts for choosing, 3-19

metadata, 1-5, 4-79

choosing source, 7-3

Oracle Designer and, 7-14

metalayer, 1-5

mismatched data types, A-3

mismatched parentheses, A-13

missing dependencies, A-21

moving through hierarchical structures, 4-78

moving through hierarchies, 4-71

Multi-item button, 11-7

multi-item joins, 11-7 to 11-8

multi-parent hierarchies, A-41

multiple folders

creating item hierarchies, 14-6

multiple work area views, 4-61

name conflicts, A-1, A-21, A-34

names (maximum length), A-35

names with numeric suffixes, 4-60

naming

business areas, 7-13

items, 3-10

joins, 11-4

PL/SQL functions, A-22

navigating hierarchies, 4-71, 4-78

nested aggregates, 12-3

New Condition dialog box

Advanced options, 13-7

New Join dialog, 4-37, 11-3 to 11-7

opening, 11-6

New Multi-Item Join dialog, 11-7, 11-8

New Multi-item Join dialog, 11-4

New Window command, 4-61

NLS, 17-8

non-Oracle databases, 1-9

calculations and, 6-3

creating EULs, 5-4

workbook scheduling and, 2-1

non-standard sorts, 4-49

null values

detail items and, 11-5

troubleshooting, A-36, A-40

NUMBER data types, 7-12

numeric items, 4-68

comparing, 13-6, 13-8

range errors, A-37

numeric suffixes, 4-60

numeric values, 3-11

objects, 3-5, 3-10

adding to business areas, 7-5

assigning attributes, 7-11

renaming, 6-10

ODBC, 3-3

ODBC-specific SQL statements, 6-7

OK button, 4-26

one-to-many joins

displaying, 11-7

one-to-many relationships, 3-11

one-to-one joins, 11-2

creating, 11-6

on-line dictionary, 7-4, 7-5

options, 7-7

online help, 1-8, 1-11, 4-2

accessing, 3-20

Open Business Area dialog, 7-15, 7-16

opening

business areas, 3-10, 7-3, 7-14

multiple work areas, 4-61

tasklist, 3-6

operators, 4-31, 4-56, 11-4

optimizer_mode parameter, 2-11

optional conditions

changing status, 13-2

mandatory condition vs., 13-2

Oracle Applications

Applications table cannot be found, A-46

configuring the Connect dialog, 17-3

Connect dialog, 17-15

connect to Discoverer, 17-15

Profiles, 17-8

Oracle Applications User

change existing standard database user to, D-14

connect as, D-15

connection options, D-13

Oracle Designer

error when loading, A-14

inaccessible repository, A-40

loading metadata from, 7-14

tables unavailable, A-7

orphan folders

defined, 6-1

outer joins, 11-4, 11-5

owners

End User Layer, 5-2

name too long, A-37

not specified, A-38

package names, troubleshooting, A-38

page axis, 4-42

parameters

scheduled workbooks, 2-4

timed statistics, 2-10

with no associated values, A-35

Partially Restricted Tables option, 7-8

pending jobs, 2-4

percentages, 4-55, 4-59

periodic refresh intervals, 4-91

personnel records, 4-57

PL/SQL functions

creation errors, A-9

importing, 12-13, 12-15

invalid argument names, A-29

invalid package names, A-38

naming, A-22

naming arguments, A-3

registering, 12-13

automatically, 12-15

return type invalid, A-33

unknown, A-14

PL/SQL support, 15-20, A-45

pop-up menus, 3-7

predefined functions, 12-13

primary keys

viewing, 3-11

printing reports, 9-2

private EULs, 4-2

Private Tables option, 7-8

privileges

complex folders and, 6-3

creating external summaries, 15-20

creating summaries and, 2-6, 15-20

displaying default, 8-4, 8-5, 8-9, 17-19, 17-21, 17-24

End User Layer, 5-2

insufficient, A-23, A-42

tutorial, 4-17 to 4-24

Privileges dialog, 4-17

Privileges tab, 8-7

usage tutorial, 4-17 to 4-22

profiles, A-42

properties

complex folders and, 4-63

custom folders, 6-4

default, 1-8

items, 10-2

saving changes automatically, 6-10

PUBLIC responsibility, 17-24

Public role, 8-4, 8-5, 8-9, 17-19, 17-21

Public Tables option, 7-8

queries, 1-5, 5-2, 15-17

against scheduled workbooks, 8-14

aggregates and, 12-3, 12-4

analyzing usage, 15-9

canceling, 8-12

conditions and, 13-1

expressions and, 15-19

fan trap detection, 11-6

folder definitions and subqueries, 6-8

frequently run, 15-18

hierarchies and, 14-3

misleading or incorrect results returned, 11-2

optimizing, 4-85, 6-8, C-1

performance predictions, C-1

enabling, 2-9

unavailable, 2-9

summary tables and, 11-5

Query Governor tab

usage tutorial, 4-21

Query Statistics Business Area, 15-9

range errors, A-37

ratio, computing, 12-3

rdb

features not supported, F-2

software requirements, F-1

RDBMS directory, 2-2, 2-6

referenced items, 6-3, 6-5

refresh intervals

creation errors, A-30, A-37

tutorial for setting, 4-91

refresh sets, 3-18

Register PL/SQL Functions command, 12-14, 12-15

registering PL/SQL functions, 12-13

automatically, 12-15

reinstalling tutorial, 5-13, 5-14

relational databases, 1-2

relationships, 3-14

joins, 11-2

renaming

folders, 4-26 to 4-29

item classes, 10-17

items, 4-29, 6-5

objects, 6-10

reordering folder items, 3-10

reports, 1-8, 4-55, 12-4, 14-2, 14-3

creating from hierarchies, 4-71

printing, 9-2

processing requests, 2-4

running

setting start time, 2-4

repository, 2-3

inaccessible, A-40

specifying users, 2-4, 8-13

tables unavailable warning, A-7

Repository User property, 2-3

requests, 2-4

resizing columns, A-4

restricted tables, 7-8

result sets, 4-31, 9-1

complex folders and, 6-3

custom folders and, 6-3

storing, 2-2

right-click menus, 3-7

roles, 4-18

granting rights and privileges, 8-1

tutorial, 4-18

rows, 1-7

setting retrieval limits, 8-12

Rule optimizer, 2-11

running scheduled workbooks, 2-1

process described, 9-2

setting start time, 2-4

sample database, 4-1

scheduled workbooks

output, 9-1

Scheduled Workbooks tab

usage tutorial, 4-22

scheduling workbooks

process described, 9-2

setting parameters, 2-4

timed intervals for, 2-4

schemas, 6-3

defined, 7-9

owners, 7-9

workbook scheduling and, 2-2, 2-3

scripts (workbook scheduling), 2-3

Secure Views, 17-7

security, 1-9

complex folders and, 6-3

Security dialog, 4-17

usage tutorial, 4-23 to 4-24

SELECT access, 8-1

SELECT ANY TABLE access, 2-4

Select Items tab, 10-16

SELECT statements, 6-7, 6-8

selecting

data sources, 7-3, 7-14

items

for item classes, 4-46

for summary reports, 4-88, 4-89

from list of values, 4-48

in hierarchies, 4-68, 4-75

menu commands, 3-19

servers

connection errors, A-20, A-45

reducing load, C-1

testing operational parameters, 2-10

set operators, 4-31

example, 6-7

setting properties

complex folders and, 4-63

Show menu

simple folder icon, 3-10

simple folders, 6-2

adding to business areas, 3-10

sort tables, 10-3

sorting data, 1-8

changing alternate sort sequences, 10-16

defining alternate sorts, 10-3

tutorial, 4-49

viewing alternative attributes, 3-16

SQL commands

naming arguments, A-3

SQL scripts, 2-3

SQL statements, 1-5, 4-31, 5-2

aggregates and, 12-3, 12-4

conditions and, 13-1, 13-7

custom folders and, 6-4, 6-8

tutorial for editing, 4-34 to 4-36

SQL*Net, 1-5, 5-2

SQL*Plus, 10-3

starting external applications, 4-79, 4-80

static values, 12-2

statistics, 2-11

storing data, 2-2

storing result sets, 2-2

subqueries, 6-8

SUM function, 12-2, 12-4

summaries

refresh following import/export to and from pre-8.1.6/8.1.6+ databases, 15-50

Summaries tab, 3-18

summary combinations

building, 4-89, 15-18

creation errors, A-36

frequently run queries and, 15-18

mapping errors, A-4

summary folder icon, 3-18

summary folders, 15-3

creating

tutorial, 4-85 to 4-92

setting up, 15-19, 15-20

summary items, 3-18

Summary Management feature, 15-20

summary reports

creation errors, A-10

drilling through, 4-82

hierarchies and, 15-19

periodic refresh intervals, 4-91

selecting items, 4-88, 4-89

tutorial for creating, 4-85 to 4-92

summary tables, 15-17

displaying refresh sets, 3-18

duplicate names, A-7

mapping columns to

example, 15-18

tutorial, 4-89

required privileges, 2-6, 15-20

running queries against, 11-5

updating, 4-91, 15-7

Summary Wizard, 15-3

tutorial, 4-85 to 4-92

summary wizard

automated summary management(asm), 16-4

need to connect as the EUL owner, 16-4

synonyms, 4-31, 6-7

unresolved, A-44

system administrators, xxi

system files, inaccessible, A-39

System Generated command, 3-13, 3-16

system-generated hierarchies, 3-13

system-generated item classes, 3-16

tables, 1-6, 3-10

access rights and privileges, 8-1

analyzing content, 2-11

creating joins

from multiple items, 11-7 to 11-8

with calculated items, 11-7

creation errors, A-42

inaccessible, A-19, A-45

invalid, A-39

loading, 7-7

tutorial, 4-10 to 4-11

setting row retrieval limits, 8-12

tables and views

adding to business areas, 7-10

tablespaces, 5-8, 5-14

tasklist, 3-6

templates, 4-74, 14-3

text items, 3-11, 4-68

timed intervals for scheduled workbooks, 2-4

timed_statistics parameter, 2-10

tokens (unrecognized), A-44

installing, 5-6, 5-8, 5-11

errors during, 5-12

multiple copies, 5-14

installing the tutorial data, 5-10

make note of password, 5-13

reusing, 4-93

uninstalling, 5-13, 5-14 to 5-16

unavailable messages, 2-9

uncategorized errors, A-14

undocumented errors, A-2

Uninstall the Tutorial Wizard, 5-15

uninstalling tutorial, 5-13, 5-14 to 5-16

unique values, 3-17

unknown Discoverer version, A-44

unmatched data types, A-3

unrecognized tokens, A-44

unresolved synonyms, A-44

updating

summary tables, 15-7

User Defined command, 3-13, 3-16

user IDs, 4-18, 7-8

attaching to databases, 7-6

maximum length, A-37

tutorial, 5-10

user profiles, A-42

user requirements, 1-10

User/Role tab

usage tutorial, 4-20

user-defined hierarchies, 3-13

user-defined item classes, 3-16

user-defined PL/SQL functions, 12-13

users, 4-18

creating tablespaces for new, 5-8

granting rights and privileges

to multiple, 8-1

tutorial, 4-18

grouping, 4-18

insufficient privileges, A-23, A-42

problems getting current, A-15

specifying repository for, 2-4

Using Help command, 3-20

Validate SQL button, 4-33

values, 1-8

derived items and, 12-2

equivalent, 4-39

foreign keys with null, 11-5

viewing

default privileges, 8-4, 8-5, 8-9, 17-19, 17-21, 17-24

EUL objects, 3-10

hierarchy templates, 3-12

tasklist, 3-6

views, 1-6, 3-10, 4-16

creation errors, A-42

invalid, A-44

multiple work area, 4-61

invoking from tasklist, 3-6

working with multiple views, 4-61

workbooks, 1-9

adding calculated items, 12-4

creating worksheets, 4-40

invalid formats, A-31, A-32

processing requests, 2-4

scheduling

process described, 9-2

setting parameters, 2-4

timed intervals for, 2-4

storing result sets, 2-2

XML import format, 7-19

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