Index

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

---

Symbols

% wildcard, 5.4.1

< > operator, 25

< operator, 25, 25

<= operator, 25, 25

= operator, 25

---

A

access privileges

how to grant to VIDEO5 database user, 27.9

adding

objects to business areas, 5.4.1, 5.4.2

aggregate calculated items

about, 11.3

and analytic functions, 11.5

restrictions, 11.4

aggregate derived items

about, 11.6

examples, 11.7

AggregationBehavior registry setting

specifying the default behavior for Discoverer Desktop, 21.5

alternative sort item class

creating, 9.17

alternative sorts, 9.5

examples, 9.6

analytic functions

Discoverer and database support for, 11.5

apps_fndnam

command modifier, 22.17.2, 22.19.2

apps_gwyuid

command modifier, 22.17.3, 22.19.3

ASM, 14.12

after bulk load using Load Wizard, 14.13

command-line interface, 14.14

how does it work?, 14.6

operating system scheduler, 14.15

policy, 14.9

using a batch file, 14.15

ways to run, 14.8

what is ASM?, 14.5

ASO encryption certification, 7.3

assigning user IDs to databases, 5.4.1

auto generate name property

about, 9.14

AutogenNameOnCreate

registry setting, 21.5

Automated Summary Management, 14.5

axis items, 25

---

B

base folder items

reaching through to, 6.12

business areas, 3.3.2

about, 5.1

building, 5.2

components, 5.4.4

copying between EULs, 5.7

creating

prerequisites, 5.2

creating and maintaining, 5

creating with the Load Wizard, 5.4

deleting, 5.9

designing, 5.2

exporting, 4.15

loading objects, 5.4.1, 5.4.2

opening, 5.5, 5.6

properties, 5.8

refresh objects, 5.10

synchronizing with the DB, 5.10

business intelligence

about, 1.6.1

---

C

calculated items

about, 11.1

creating, 11.8

deleting, 11.11

drill to pre-defined worksheet, 11.12

editing, 11.10

editing properties, 11.9

calculations

concatenate items, 11.1

removing carriage returns, 11.1

carriage returns in calculations, 11.1

cartesian products, 25

choosing

data sources, 5.4.5

columns

mapping to summary tables

example, 15.4

command-line interface, 22

'?' command, 22.17.1

about, 22.2

about command modifiers, 22.5

about commands, 22.4

apps_fndnam, 22.17.2, 22.19.2

apps_gwyuid, 22.17.3, 22.19.3

apps_user, 22.17.4, 22.19.4

asm, 22.17.5

cmdfile, 22.17.6, 22.19.6

command file examples, 22.15

command files, 22.12

command reference, 22.17

command syntax, 22.10

connect, 22.17.7

create_eul, 22.17.8

create_eul /apps_mode, 22.17.9

creating command files, 22.13

delete, 22.17.10

delete_bus_area, 22.17.11

delete_eul, 22.17.12

example commands, 22.11

export, 22.17.13

import, 22.17.14, 22.17.15

load, 22.17.16

notes on using, 22.8

quick guide, 22.16

refresh_bus_area, 22.17.17

refresh_folder, 22.17.18

refresh_summary, 22.17.19

required privileges, 22.7

running command files, 22.14

syntax conventions, 22.9

using, 22.6

command-line interface modifiers

aggregate, 22.18.1

all, 22.18.2, 22.20.1

apps_grant_details, 22.18.3

apps_responsibility, 22.18.4, 22.20.2

apps_security_group, 22.18.5

asm_space, 22.18.6

asm_tablespace, 22.18.6

audit_info, 22.18.7

auto_gen_name, 22.18.8

ba_link, 22.18.9

business_area, 22.18.10

capitalize, 22.18.11

condition, 22.18.12

date_hierarchy, 22.18.13

db_link, 22.18.14

description, 22.18.15

eul, 22.18.16, 22.20.3

external_element, 22.18.18

folder, 22.18.19

function, 22.18.20

hier_node, 22.18.21

hierarchy, 22.18.22

identifier, 22.18.23

insert_blanks, 22.18.24

item_class, 22.18.26

items, 22.18.25

join, 22.18.27

keep_folder, 22.18.28

keep_format_properties, 22.18.29

log, 22.18.30

log_only, 22.18.31

lov, 22.18.32

object, 22.18.33

overwrite, 22.18.34

parameter, 22.18.35

password, 22.18.36

private, 22.18.37

refresh, 22.18.38

remove_prefix, 22.18.39

rename, 22.18.40

schema, 22.18.41

show_progress, 22.18.42

sort_folders, 22.18.43

sort_items, 22.18.44

source, 22.18.45

summary, 22.18.46

user, 22.18.47

workbook, 22.18.48

xmlworkbook, 22.18.49

complex folder reach through

the constraints and rules that apply, 6.14

what is it?, 6.12

composite join key

multi-item joins, 10.3

concatenate items, 11.1

conditions

about, 12.1

and outer joins, 12.9

categories, 12.1.1

creating complex, 12.4

creating row level security, 12.10

creating simple, 12.3

deleting, 12.7

editing, 12.5

editing properties, 12.6

examples, 12.8

how they work, 12.1.2

types described, 12.2

CONNECT BY clause

in hierarchies, 13.12

using in custom folder to create hierarchy, 13.13

CONNECT BY clauses (SQL), 6.4.2

connect for the first time

what conditions apply?, 27.4

content types

item content types, 9.13

count(distinct)

expression in summary folders, 15.6

cross tab worksheets

placing items, 25

custom folder

use in a Discoverer worksheet to display your Oracle Applications user name and responsibility, 17.14

custom folders

queries and, 6.4.2

updating when based on a view, 25

using a synonym in, 6.4.2, 6.4.2

using the CONNECT BY clause to create a hierarchy, 13.12

---

D

d51wkdmp

notes on using the workbook dump utility, 4.22.4

data

retrieving, 6.4.2

data point items, 25

data types

axis items and, 25

DECIMAL, 25

data warehouses, 3.1

database links, 25

database parameters

used with Discoverer, 3.8

database prerequisites for tutorial users, 27.1

database roles

sharing workbooks using, 7.11

database security

ASO encryption certification, 7.3

datatype mismatch

in joins, 10.17

date format 'RR', 13.11

date format masks, 9.10

date hierarchies, 13.3

date items

applying conditions, 9.12

applying date hierarchy templates, 13.8

truncating with EUL_DATE_TRUNC, 9.11

DBMS_JOB, 14.16.1

DBMS_JOB package, 8.6

DECIMAL data type, 25

default date hierarchies

changing 'RR' date format after Oracle9i upgrade, 13.11

derived items

about, 11.2

descriptions

joins, 25

Desktop

registry settings that affect performance, 21.4

de-supported characters

in identifiers, 4.22.1

detail items

adding to joins, 25

Discoverer

access permissions, 7.2

data access requirements, 3.7.2

how does it work?, 1.6.2

implementation, 3.5

implementing, 3.5

maintenance, 3.6

security, 7.3

system requirements, 3.7

task privileges, 7.4

workflow, 1.7

Discoverer 10.1.2

upgrading to, 24.2.4, 24.2.5, 24.2.6

Discoverer Administrator

about, 1, 2, 3.2

about new features, 3.11

about the Tasklist, 3.10.3

about the workarea, 3.10

basic concepts, 3.3

context sensitive menus, 3.10.2

getting started, 3

online help, 3.12

starting, 3.9

workarea window, 3.10.1

Discoverer manager

about the role, 2.5, 2.5.1

basic concepts, 1.6

Discoverer Plus

unique features, 1.5

Discoverer registry settings, 21, 21.5

about, 21.1

drill to detail item class, 9.7

creating, 9.18

drill to pre-defined worksheet, 11.12

drilling

to other applications, 9.13

drills, 3.3.5

---

E

EnableTriggers

registry setting, 21.5

End User Layer

about, 4.1

and analytic functions, 24.2.7.2

changing, 4.11

copy objects between databases

export using command-line interface, 4.17

import using command-line interface, 4.18

copying objects between databases, 4.12

creating, 4.8

creating and maintaining, 4

creating for a new DB user, 4.9

deleting, 4.10

exporting EUL objects, 4.16

exporting to a file, 4.12

how to export, 4.14

importing EUL objects, 4.12

importing objects, 4.21

in Oracle database, 4.4

owners, 4.3

privileges needed, 4.4

privileges needed in a non-Oracle DB, 4.5

privileges to maintain, 4.6

upgrading, 24.2.7.2

viewing, 4.11

why use?, 4.2

End User Layer (EUL), 3.3.1

equality, 25

equi-joins, 25

error messages

Discoverer, 3.12

EUL

installing tutorial, 27.3

why must you create one?, 27.4, 27.5

EUL Access workbook, 19.9

EUL Data Definition workbook, 19.7

EUL Gateway

about, 4.7

EUL Query Statistics workbook, 19.8

EUL status workbooks, 19

about, 19.1

Discoverer EUL V.5 business area, 19.2

installing, 19.3

installing APPs, 19.4

running, 19.5

uninstalling, 19.6

EUL tables

about not editing them, 4.2

EUL trigger

what is it?, B.1

EUL triggers

list of, B.2

EUL upgrade

scheduled workbooks, 24.2.8

EUL Workbook Management workbook, 19.10

EUL_DATE_TRUNC, 9.11

Export

EUL objects using command-line interface, 4.17

export file

adding XML code to, 22.18.18

Export Wizard, 4.15, 4.16

exporting EULs, 4.12

external summary

materialized view already exists error, workaround, 16.12

---

F

fan trap detection, 25

fan traps, 10.14

inside complex folders, 10.16

fetching data, 6.4.2

folders, 3.3.3, 14.1

about, 6.1

assigning to business areas, 6.16

assigning to multiple business areas, 6.17

complex, 6.3

creating complex, 6.8

creating custom, 6.9

creating simple, 6.7

custom, 6.4

custom folder examples, 6.4.2

custom versus simple, 6.4.1

deleting, 6.15

dependencies, 6.5

editing custom folder SQL, 6.11

editing properties, 6.10

re-ordering, 6.22

sharing across business areas, 6.6

simple, 6.2

sorting in a business area, 6.20

sorting items, 6.21

SQL, 6.11

using complex instead of DB views, 6.3.1

validating, 6.23

viewing or deleting orphaned folders, 6.19

---

G

gateway

loading from, 5.4.2

generic connectivity

connecting to non-Oracle databases, 23.2

---

H

help system

about, 3.12

Heterogeneous Services, 22.2

heterogeneous sevices, 22.2

heterogenous services

generic connectivity, 23.1

transparent gateway, 23.1

hierarchies, 3.3.5, 13

about, 13.1

and performance, 13.3.2

applying templates to, 13.8

creating date, 13.5

creating item, 13.4

creating using CONNECT BY clause in custom folder, 13.13

date, 13.3

date hierarchy templates, 13.3.1

date templates, 13.5, 13.7

default date hierarchy template, 13.9

deleting templates, 13.10

editing item, 13.6

editing templates, 13.7

item, 13.2

modifying, 13.11

recursive, 13.12

using the CONNECT BY clause, 13.12

hints

optimizer, 6.4.2

---

I

identifiers

containing de-supported characters, 4.22.1

locating for workbooks/worksheets in Discoverer Plus, 4.22.1

using to match objects, 25

import EUL objects, 4.21

Import Wizard, 4.21

error messages, 25

importing End User Layer objects, 4.12

indentifiers

about, 4.22.1

Indexed item

associate with current item to improve parameter performance, 25

indexed item

how to assign to an item, 9.28

indexed items

assigning to items in folders and complex folders to improve performance, 9.27

to improve query performance using parameters, 25

inequality, 25

inline view SQL

what is executed in the database, 16.4

inline views

removing them from the SQL that is sent to the RDMBS, 16.5

install tutorial

how to, 27.8

what happens?, 27.2

what privileges do you need?, 27.3

what steps do you follow?, 27.6

installation

tutorial, 27.3

integers, 25

item

how to assign an indexed item to, 9.28

item class, 9.2

adding items, 9.21, 9.21.1, 9.21.2, 9.21.3

editing, 9.20

removing items, 9.22, 9.22.2

viewing items, 9.23

viewing list of values, 9.25

Item Class Properties dialog

General tab, 25

item classes

deleting, 9.26

item content types, 9.13

item hierarchies, 13.2

item properties

indexed item, 25

items, 3.3.3

about, 9.1

alternative sorts, 9.5

content types, 9.13

creating alternative sort item class, 9.17

creating LOV item class, 9.16

date, 9.9

date format masks, 9.10

deleting, 9.26

drill to detail item class, 9.18

drill to detail item classes, 9.7

editing properties, 9.15

item classes, 9.2

lists of values, 9.3

placing on cross tabs, 25

viewing list of values, 9.24

---

J

join condition, 10.2

joins

about, 10.1

adding detail items, 25

cartesian products, 25

composite join key, 10.3

creating single and multi-item joins, 10.11

datatype mismatch in, 10.17

deleting, 10.13

editing a join, 10.12

editing join properties, 10.12

fan traps, 10.14

many-to-many, 10.6

naming, 25

one-to-many, 10.6

one-to-one, 10.6

outer joins, 10.10

single item, 10.2

what are multi-item joins?, 10.3

---

L

lineage workbook

installing for use with Oracle Warehouse Builder, 18.4

links

database to user, 25

list of values

querying, 6.4.2

using custom folders, 9.19

Load Wizard, 5.3

logical standby databases

about creating EULs, 4.22.5

LOV item class

creating, 9.16

---

M

maintaining an Oracle Applications EUL

with which user?, 17.8

maintaining Discoverer, 3.6

mandatory conditions

optional condition vs., 12.2

mapping columns

example, 15.4

materialized view

only one materialized view can be registered against a single external summary table, 16.12

materialized views

about, 14.4

migrate EUL metadata to Oracle Business Intelligence Enterprise Edition, 4.2

multi item join

creating, 10.11

multiple connections to an EUL, and conflicting changes to EUL objects, for more information, see notes, 3.9

---

N

naming

joins, 25

non-Oracle database support

using transparent gateway, 23.3

non-Oracle database support using generic connectivity, 23.2

about the advantages of generic connectivity, 23.2.2

how to set up generic connectivity, 23.2.3

non-Oracle databases

connecting to, 23.1

NUMBER data types, 25

---

O

object names, 5.4.5

objects

adding to business areas, 5.4.1, 5.4.2

object/schema name

checking, 14.16.4

OLTP systems, 3.1

one-to-one joins

creating, 25

online dictionary

loading from, 5.4.1

operators

set, 6.4.2

optimizer, 20.1

optimizer hints, 6.4.2

optional conditions

mandatory condition vs., 12.2

ORA-3113 error

when using heterogeneous data services with Discoverer Administrator, 23.2.5

Oracle Applications, 17

configuring the Connect dialog, 17.6

creating an EUL, 17.7

Discoverer differences, 17.5

display your user name and responsibility in a Discoverer worksheet, 17.14

prerequisites, 17.4

responsibilities, 17.2, 17.10

specify users/responsibilities, 17.13

specifying business areas, 17.11

specifying tasks, 17.12

supported features, 17.3

Oracle Applications EUL

which user should maintain, 17.8

Oracle Enterprise Manager, 18.1

Oracle Portal, 18.6

Oracle Reports, 18.2

Oracle Warehouse Builder

using Discoverer with, 18.4

Oracle Web Cache, 18.3

orphaned folders

viewing or deleting from EUL, 6.19

outer joins

what are outer joins?, 10.10

---

P

parameters

specify indexed item property to improve performance with, 25

using indexed items to improve query performance of, 25

Partially Restricted Tables option, 25

patchsets

Discoverer Administrator, 23.2.5

PL/SQL functions

custom, 11.14

note about arguments with boolean datatypes, 25

privilege required to register, 11.15

registering, 11.15

registering automatically, 11.16

registering manually, 11.17

why use?, 11.13

primary element

auto generate name property, 9.14

private EUL

how to create, 27.7

Private Tables option, 25

privileges

granted to PUBLIC by Discoverer scripts, A.1

granted to the Discoverer manager by Discoverer scripts, A.2

required to register PL/SQL functions, 11.15

Public Tables option, 25

---

Q

queries

fan trap detection, 25

folder definitions and subqueries, 6.4.2

optimizing, 6.4.2, 20.1

performance predictions, 20.1

query prediction, 20

about, 20.1

analyzing data tables, 20.7

and secure views, 20.10

deleting old statistics, 20.11

improving speed and accuracy, 20.4

in Discoverer Plus, 20.2

making views available, 20.5

reducing long times, 20.9

verifying optimizer_mode parameter, 20.8

verifying timed_statistics parameter, 20.6

when not available, 20.3

query retrieval limits

setting, 7.9

query rewrite

about, 16.2

example, 16.8

---

R

Rdb and non-Oracle database support, 23

reach through to base folder items

from complex folders, 6.12

read-only databases

about creating EULs, 4.22.5

reference dialogs

list of, 25

refresh options

about, 16.13

registry settings, 21, 21.5

about, 21.1

reinstall tutorial data, 27.12

relational databases, 3.1

restricted tables, 25

result sets

complex folders and, 6.3.1

roles

granting rights and privileges, 7.1

row level security

creating using conditions, 12.10

---

S

scheduled workbook limits

setting, 7.10

scheduled workbooks

about, 8.1, 8.3

backward compatibility, 24.2.8

DBMS_JOB package, 8.6

prerequisites, 8.5

results storage, 8.4

specifying owner, 8.7

viewing and managing, 8.9

why use?, 8.2

scheduling workbooks

granting necessary privileges, 8.8

scripts that grant privileges to the Discoverer manager, A.2

scripts that grant privileges to the PUBLIC user, A.1

search fillter

how to enable for users and roles, 21.5

secondary element

auto generate name property, 9.14

security

business area access, 7.5

user/role business area access, 7.6

user/role privileges, 7.7

user/role to perform task, 7.8

SELECT statements, 6.4.2, 6.4.2, 6.4.2

selecting

data sources, 5.4.5

selecting tables and views, 5.4.3

set operators

example, 6.4.2

sharing workbooks

using database roles, 7.11

sorting options, 5.4.5

SQL

flattened SQL, 16.5

in SQL Inspector, 16.5

reformatted (flattened), 16.5

removing inline views, 16.5

SQL and execution plan

examples, 16.6

viewing, 16.4

SQL commands

CONNECT BY, 6.4.2

SELECT, 6.4.2, 6.4.2, 6.4.2

SQL Inspector

SQL format, 16.5

SQL scripts

list of Discoverer files, 26.1

SQL statements

joins and, 25

optimizing, 20.1

subqueries, 6.4.2

summary combinations

setting up, 15.5

summary data

why refresh?, 14.10

summary folders, 3.3.6

about, 14.2

and external summary tables, 16.10

and folders, 14.1

configuring the database, 14.16

creating, 15.7

creating based on external summary tables, 15.9

creating based on users queries, 15.8

deleting, 15.14

differences between Oracle Standard Edition and Oracle9i (or later) Enterprise Edition databases, 16.9

editing, 15.12

editing database storage properties, 15.13

editing properties, 15.11

expressions

using, 15.6

granting necessary privileges, 14.16.2

how to display them quickly, 21.5

manual creation, 15

manual fresh, 15.10

mapping external summary tables and views, 16.11

prerequisites, 14.7

prerequisites for creating with ASM, 14.7

refresh after import, 16.14

refresh following import between Oracle databases, 16.14

status, 15.15

validating, 15.12

what happens one is refreshed, 14.11

summary management, 14.16.1

summary redirection

about, 16.2

when it happens?, 16.3

summary tables

mapping columns to

example, 15.4

what are Discoverer summary tables?, 14.3

Summary Wizard

using, 14.12

synonymns

using in custom folders, 6.4.2, 6.4.2

synonyms, 6.4.2, 6.4.2

---

T

tables

selecting for BA, 5.4.3

tablespace quotas

determining, 14.16.3

resetting, 14.16.3

TAF

Transparent Application Failover, about, 7.12

templates

date hierarchies, 13.3.1

text, exporting results as, 4.12

trace files

how to create, 26.3

transparent gateway

connecting to non-Oracle databases, 23.3

transparent gatewayn, 23.3

tutorial

installing, 27.3

tutorial business area

how to install in another EUL, 27.10

how to uninstall, 27.11

tutorial data

how to reinstall it, 27.12

---

U

upgrading

analytic functions in an EUL, 24.2.7.2

Discoverer versions and EUL versions, 24.1

from Discoverer Release 3.1 to Version 10.1.2, 24.2.4

from Discoverer Release 4.1 to Version 10.1.2, 24.2.5

from Discoverer Release 9.0.x to Version 10.1.2, 24.2.6

prerequisites, 24.2.2

user IDs, 25

attaching to databases, 5.4.1

user/role search filter, 21.5

UserRoleFilter registry key, 21.5

users

granting rights and privileges

to multiple, 7.1

---

V

v_$parameter view

granting privileges for summary folders, 14.16.2

granting privileges to run scheduled workbooks, 8.8

validate

summary folders, 15.12

value hierarchy

create using the CONNECT BY clause, 13.12

views

selecting for BA, 5.4.3

updating in custom folders, 25

---

W

wildcards, 5.4.1

WITH clause

cannot use in the custom folder SQL, 25

workarea

context sensitive menus, 3.10.2

workbook dump utility

notes on using, 4.22.4

workbook export

XML format, 22.18.49

workbooks, 3.3.4

about, 8.1

worksheets, 3.3.4

---

X

XML

adding to export file, 22.18.18

format for workbook export, 22.18.49

import format, 4.12