Skip Headers

Oracle Discoverer Administrator Administration Guide 10g (9.0.4) Part Number B10270-01 |
Home | Contents

# 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, 1
  < > operator, 1
  < operator, 1
  <= operator, 1
  = operator, 1
  > operator, 1
  >= operator, 1

## A

  adding
    objects to business areas, 1, 2
  aggregate calculated items
    about, 1
    and analytic functions, 1
    restrictions, 1
  aggregate derived items
    about, 1
    examples, 1
  alternative sort item class
    creating, 1
  alternative sorts, 1
    examples, 1
  ASM, 1
    after bulk load using Load Wizard, 1
    command line interface, 1
    how does it work?, 1
    operating system scheduler, 1
    policy, 1
    using a batch file, 1
    ways to run, 1
    what is ASM?, 1
  assigning user IDs to databases, 1
  Automated Summary Management, 1
  axis items, 1

## B

  business areas, 1
    about, 1
    building, 1
    components, 1
    copying between EULs, 1
    creating
      prerequisites, 1
    creating and maintaining, 1
    creating with the Load Wizard, 1
    deleting, 1
    designing, 1
    exporting, 1
    loading objects, 1, 2
    opening, 1
    properties, 1
    refresh objects, 1
    synchronizing with the DB, 1
  business intelligence
    about, 1

## C

  calculated items
    about, 1
    creating, 1
    deleting, 1
    drill to pre-defined worksheet, 1
    editing, 1
    editing properties, 1
  calculations
    concatenate items, 1
    removing carriage returns, 1
  carriage returns in calculations, 1
  cartesian products, 1
  choosing
    data sources, 1
  columns
    mapping to summary tables
      example, 1
  command line interface, 1
    '?' command, 1
    about, 1
    about command modifiers, 1
    about commands, 1
    apps_fndnam, 1
    apps_user, 1
    asm, 1
    cmdfile, 1
    command file examples, 1
    command files, 1
    command reference, 1
    command syntax, 1
    connect, 1
    create_eul, 1
    create_eul /apps_mode, 1
    creating command files, 1
    delete, 1
    delete_bus_area, 1
    delete_eul, 1
    example commands, 1
    export, 1
    import, 1, 2
    load, 1
    notes on using, 1
    quick guide, 1
    refresh_bus_area, 1
    refresh_folder, 1
    refresh_summary, 1
    required privileges, 1
    running command files, 1
    syntax conventions, 1
    using, 1
  command line interface modifiers
    aggregate, 1
    all, 1
    apps_grant_details, 1
    apps_responsibility, 1
    apps_security_group, 1
    asm_space, 1
    asm_tablespace, 1
    audit_info, 1
    ba_link, 1
    business_area, 1
    capitalize, 1
    condition, 1
    date_hierarchy, 1
    db_link, 1
    description, 1
    eul, 1
    external_element, 1
    folder, 1
    function, 1
    hier_node, 1
    hierarchy, 1
    identifier, 1
    insert_blanks, 1
    item_class, 1
    items, 1
    join, 1
    keep_folder, 1
    keep_format_properties, 1
    log, 1
    log_only, 1
    lov, 1
    object, 1
    overwrite, 1
    parameter, 1
    password, 1
    private, 1
    refresh, 1
    remove_prefix, 1
    rename, 1
    schema, 1
    show_progress, 1
    sort_folders, 1
    sort_items, 1
    source, 1
    summary, 1
    user, 1
    workbook, 1
    xmlworkbook, 1
  composite join key
    multi-item joins, 1
  concatenate items, 1
  conditions
    about, 1
    and outer joins, 1
    categories, 1
    creating complex, 1
    creating row level security, 1
    creating simple, 1
    deleting, 1
    editing, 1
    editing properties, 1
    examples, 1
    how they work, 1
    types described, 1
  CONNECT BY clause
    in hierarchies, 1
    using in custom folder to create hierarchy, 1
  CONNECT BY clauses (SQL), 1
  content types
    item content types, 1
  cross tab worksheets
    placing items, 1
  custom folder
    use in a Discoverer worksheet to display your Oracle Applications user name and responsibility, 1
  custom folders
    queries and, 1
    using a synonym in, 1
    using the CONNECT BY clause to create a hierarchy, 1

## D

  data
    retrieving, 1
  data point items, 1
  data sources
    Oracle Designer and, 1
  data types
    axis items and, 1
    DECIMAL, 1
  data warehouses, 1
  database links, 1
  database roles
    sharing workbooks using, 1
  datatype mismatch
    in joins, 1
  date format 'RR', 1
  date format masks, 1
  date hierarchies, 1
  date items
    applying conditions, 1
    applying date hierarchy templates, 1
    truncating with EUL_DATE_TRUNC, 1
  DBMS_JOB, 1
  DBMS_JOB package, 1
  DECIMAL data type, 1
  default date hierarchies
    changing 'RR' date format after Oracle9i upgrade, 1
  derived items
    about, 1
  descriptions
    joins, 1
  Desktop
    registry settings that affect performance, 1
  detail items
    adding to joins, 1
  Discoverer
    about, 1
    access permissions, 1
    components, 1
    data access requirements, 1
    how does it work?, 1
    implementation, 1
    implementing, 1
    maintenance, 1
    security, 1
    system requirements, 1
    task privileges, 1
  Discoverer 9.0.4
    upgrading to, 1
  Discoverer Administrator
    about, 1, 2
    about new features, 1
    about the Tasklist, 1
    about the workarea, 1
    basic concepts, 1
    context sensitive menus, 1
    getting started, 1
    online help, 1
    starting, 1
    workarea window, 1
  Discoverer manager
    about the role, 1
    basic concepts, 1
  Discoverer registry settings, 1, 2
    about, 1
  drill to detail item class, 1
    creating, 1
  drill to pre-defined worksheet, 1
  drilling
    to other applications, 1
  drills, 1

## E

  End User Layer
    about, 1
    and analytic functions, 1, 2
    changing, 1
    copy objects between databases
      export using command line interface, 1
      import using command line interface, 1
    copying objects between databases, 1
    creating, 1
    creating and maintaining, 1
    creating for a new DB user, 1
    deleting, 1
    exporting EUL objects, 1
    exporting to a file, 1
    how to export, 1
    importing EUL objects, 1
    importing objects, 1
    in Oracle database, 1
    migration, 1
    owners, 1
    privileges needed, 1
    privileges needed in a non-Oracle DB, 1
    privileges to maintain, 1
    upgrading, 1
    viewing, 1
    why use?, 1
  End User Layer (EUL), 1
  equality, 1
  equi-joins, 1
  error messages
    Discoverer, 1
    Oracle database, 1
    ORA-xxxxxx messages, 1
  EUL Data Definition workbook, 1
  EUL Gateway
    about, 1
  EUL status workbooks, 1
    about, 1
    Discoverer EUL V.5 business area, 1
    installing, 1
    installing APPs, 1
    running, 1
    uninstalling, 1
  EUL upgrade
    scheduled workbooks, 1
  EUL_DATE_TRUNC, 1
  Export
    EUL objects using command line interface, 1
  export file
    adding XML code to, 1
  Export Wizard, 1, 2
  exporting EULs, 1

## F

  fan trap detection, 1
  fan traps, 1
    inside complex folders, 1
  fetching data, 1
  folders, 1, 2
    about, 1
    assigning to business areas, 1
    assigning to multiple business areas, 1
    complex, 1
    creating complex, 1
    creating custom, 1
    creating simple, 1
    custom, 1
    custom folder examples, 1
    custom versus simple, 1
    deleting, 1
    dependencies, 1
    editing custom folder SQL, 1
    editing properties, 1
    re-ordering, 1
    sharing across business areas, 1
    simple, 1
    sorting in a business area, 1
    sorting items, 1
    SQL, 1
    using complex instead of DB views, 1
    validating, 1
    viewing or deleting orphaned folders, 1

## G

  gateway
    loading from, 1
  generic connectivity
    connecting to non-Oracle databases, 1

## H

  help system
    about, 1
  Heterogeneous Services, 1
  heterogeneous sevices, 1
  heterogenous services
    generic connectivity, 1
    transparent gateway, 1
  hierarchies, 1, 2
    about, 1
    and performance, 1
    applying templates to, 1
    creating date, 1
    creating item, 1
    creating using CONNECT BY clause in custom folder, 1
    date, 1
    date hierarchy templates, 1
    date templates, 1, 2
    default date hierarchy template, 1
    deleting templates, 1
    editing item, 1
    editing templates, 1
    item, 1
    modifying, 1
    recursive, 1
    using the CONNECT BY clause, 1
  hints
    optimizer, 1

## I

  identifiers
    locating for workbooks/worksheets in Discoverer Plus, 1
    using to match objects, 1
  import EUL objects, 1
  Import Wizard, 1
    error messages, 1
  importing End User Layer objects, 1
  indentifiers
    about, 1
  inequality, 1
  inline views
    removing from SQL, 1
  integers, 1
  item class, 1
    adding items, 1, 2
    editing, 1
    removing items, 1, 2
    viewing items, 1
    viewing list of values, 1
  item classes
    deleting, 1
  item content types, 1
  item hierarchies, 1
  items, 1
    about, 1
    alternative sorts, 1
    content types, 1
    creating alternative sort item class, 1
    creating LOV item class, 1
    date, 1
    date format masks, 1
    deleting, 1
    drill to detail item class, 1
    drill to detail item classes, 1
    editing properties, 1
    item classes, 1
    lists of values, 1
    placing on cross tabs, 1
    viewing list of values, 1

## J

  join condition, 1
  joins
    about, 1
    adding detail items, 1
    cartesian products, 1
    composite join key, 1
    creating single and multi-item joins, 1
    datatype mismatch in, 1
    deleting, 1
    editing a join, 1
    editing join properties, 1
    fan traps, 1
    many-to-many, 1
    naming, 1
    one-to-many, 1
    one-to-one, 1
    outer joins, 1
    single item, 1
    what are multi-item joins?, 1

## L

  links
    database to user, 1
  list of values
    querying, 1
    using custom folders, 1
  Load Wizard, 1
  LOV item class
    creating, 1

## M

  maintaining Discoverer, 1
  mandatory conditions
    optional condition vs., 1
  mapping columns
    example, 1
  materialized views
    about, 1
  metadata
    Oracle Designer and, 1
  multi item join
    creating, 1
  multiple connections to an EUL, and conflicting changes to EUL objects, for more information, see notes, 1

## N

  naming
    joins, 1
  non-Oracle database support
    using transparent gateway, 1
  non-Oracle database support using generic connectivity, 1
    about the advantages of generic connectivity, 1
    how to set up generic connectivity, 1
  non-Oracle databases
    connecting to, 1
  NUMBER data types, 1

## O

  object names, 1
  objects
    adding to business areas, 1, 2
  object/schema name
    checking, 1
  OLTP systems, 1
  one-to-one joins
    creating, 1
  online dictionary
    loading from, 1
  operators
    set, 1
  optimizer, 1
  optimizer hints, 1
  optional conditions
    mandatory condition vs., 1
  Oracle Applications, 1
    configuring the Connect dialog, 1
    creating an EUL, 1
    Discoverer differences, 1
    display your user name and responsibility in a Discoverer worksheet, 1
    granting task privileges, 1
    prerequisites, 1
    responsibilities, 1, 2
    specify users/responsibilities, 1
    specifying business areas, 1
    specifying tasks, 1
    supported features, 1
  Oracle Designer
    loading metadata from, 1
  Oracle Enterprise Manager, 1
  Oracle Portal, 1
  Oracle Reports, 1
  Oracle Warehouse Builder, 1
  Oracle WebCache, 1
  orphaned folders
    viewing or deleting from EUL, 1
  outer joins
    what are outer joins?, 1

## P

  Partially Restricted Tables option, 1
  PL/SQL functions
    custom, 1
    registering, 1
    registering automatically, 1
    registering manually, 1
    why use?, 1
  Private Tables option, 1
  Public Tables option, 1
  PUBLIC user, 1

## Q

  queries
    fan trap detection, 1
    folder definitions and subqueries, 1
    optimizing, 1, 2
    performance predictions, 1
  query prediction, 1
    about, 1
    analyzing data tables, 1
    and secure views, 1
    deleting old statistics, 1
    improving speed and accuracy, 1
    in Discoverer Plus, 1
    making views available, 1
    reducing long times, 1
    verifying optimizer_mode parameter, 1
    verifying timed_statistics parameter, 1
    when not available, 1
  query retrieval limits
    setting, 1
  query rewrite
    about, 1
    example, 1
  Query Statistics workbook, 1

## R

  Rdb
    about the software requirements, 1
    Discoverer support for, 1
    features not supported, 1
    partially supported features, 1
    software requirements, 1
  Rdb and non-Oracle database support, 1
  reference dialogs
    list of, 1
  refresh options
    about, 1
  registry settings, 1, 2
    about, 1
  relational databases, 1
  restricted tables, 1
  result sets
    complex folders and, 1
  roles
    granting rights and privileges, 1
  row level security
    creating using conditions, 1

## S

  scheduled workbook limits
    setting, 1
  scheduled workbooks
    about, 1, 2
    and Oracle database features, 1
    backwards compatibility, 1
    DBMS_JOB package, 1
    prerequisites, 1
    results storage, 1
    server frequency check, 1
    specifying owner, 1
    viewing and managing, 1
    why use?, 1
  security
    business area access, 1
    user/role business area access, 1
    user/role privileges, 1
    user/role to perform task, 1
  SELECT statements, 1
  selecting
    data sources, 1
  selecting tables and views, 1
  set operators
    example, 1
  sharing workbooks
    using database roles, 1
  sorting options, 1
  SQL
    flattened SQL, 1
    in SQL Inspector, 1
    reformatted (flattened), 1
    removing inline views, 1
  SQL and execution plan
    examples, 1
    viewing, 1
  SQL commands
    CONNECT BY, 1
    SELECT, 1
  SQL Inspector
    SQL format, 1
  SQL scripts
    list of Discoverer files, 1
  SQL statements
    joins and, 1
    optimizing, 1
  start time
    setting for summary processing, 1
  subqueries, 1
  summary combinations
    setting up, 1
  summary data
    why refresh?, 1
  summary folders, 1
    about, 1
    and external summary tables, 1
    and folders, 1
    configuring the database, 1
    creating, 1
    creating based on external summary tables, 1
    creating based on users queries, 1
    creating with ASM, 1
    deleting, 1
    differences between Oracle Standard Edition and Oracle 8.1.7 (or later) Enterprise Edition databases, 1
    editing, 1
    editing database storage properties, 1
    editing properties, 1
    expressions
      using, 1
    granting necessary privileges, 1
    how to display them quickly, 1
    manual creation, 1
    manual fresh, 1
    mapping external summary tables and views, 1
    prerequisites, 1
    refresh after import, 1
    refresh following import between Oracle databases, 1
    status, 1
    validating, 1
    what happens one is refreshed, 1
  summary management, 1
  summary processing
    setting start time, 1
  summary redirection
    about, 1
    when it happens?, 1
  summary tables
    mapping columns to
      example, 1
    what are Discoverer summary tables?, 1
  Summary Wizard
    using, 1
  synonymns
    using in custom folders, 1
  synonyms, 1

## T

  tables
    selecting for BA, 1
  tablespace quotas
    determining, 1
    resetting, 1
  templates
    date hierarchies, 1
  transparent gateway
    connecting to non-Oracle databases, 1
  transparent gatewayn, 1

## U

  upgrading
    about, 1
    analytic functions in an EUL, 1
    prerequisites, 1
    step 1
      back up release 4.1, 1, 2
    step 2
      upgrade release 4.1 EUL, 1
    step 3
      refresh summary folders, 1
    step 4
      migrate users to 9.0.4, 1
    step 5
      remove release 4.1 EULs, 1
    step 6
      remove release 4.1 products from client machines, 1, 2
    to Discoverer version 9.0.4, 1
  user IDs, 1
    attaching to, 1
  users
    granting rights and privileges
      to multiple, 1

## V

  validate
    summary folders, 1
  value hierarchy
    create using the CONNECT BY clause, 1
  views
    selecting for BA, 1

## W

  wildcards, 1
  workarea
    context sensitive menus, 1
  workbook export
    XML format, 1
  workbooks, 1
    about, 1
  worksheets, 1

## X

  XML
    adding to export file, 1
    format for workbook export, 1
    import format, 1

| Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
Home | Contents