Skip Headers
Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E10540-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
View PDF


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


ABS math function, about, C.4.1
ACOS math function, about, C.4.2
Actions menu, about,
ADF Business Components
about, 5.1
application EAR file, deploying, 5.4.3
AppModule Config, 5.5, 6.3.5
AppModuleDefinition, 5.5, 6.3.5
enabling custom parameters, 5.6
importing metadata from, 5.5
JDBC data source for, 5.4.4
properties in connection pool, 6.3.5
setting up, 5.4
URL, 5.5, 6.3.5
working with, 5
Administration Tool
about, 2.1
Actions menu,
Edit menu,
File menu,
Help menu,
icons, 2.1.7
keyboard shortcuts, F
main window, 2.1.2
Manage menu,
opening, 2.1.1
setting preferences, 2.1.3
toolbar, 2.1.2
Tools menu,
View menu,
Window menu,
Administration Tool utilities
Aggregate Persistence, 17.2.9
Externalize Strings, 17.2.3
Generate Metadata Dictionary, 17.2.7
Oracle BI Event Tables, 17.2.2
Remove Unused Physical Objects, 17.2.8
Rename Wizard, 17.2.4
Replace Column or Table in Logical Table Sources, 17.2.1
Repository Documentation, 17.2.6
Update Physical Layer, 17.2.5
AGGREGATE AT aggregate function, about, C.2.1.1
aggregate functions
about, C.2.1, C.2.1, C.2.2
alternative syntax, C.1.3.4
AVG, C.2.1.2
BOTTOMN, C.2.1.4
computing aggregates of baseline columns, C.1.3.1
computing aggregates of measure columns, C.1.3.2
COUNT, C.2.1.5
COUNT (*), C.2.1.7
display function reset behavior, C.1.3.3
FIRST, C.2.1.8
LAST, C.2.1.11
MAX, C.2.1.12
MEDIAN, C.2.1.13
MIN, C.2.1.14
NTILE, C.2.1.15
RANK, C.2.1.17
rules for, C.1.3
STDDEV, C.2.1.18
STDDEV_POP, C.2.1.19
SUM, C.2.1.20
TOPN, C.2.1.22
using FILTER to compute conditional aggregates, C.1.3.5
aggregate navigation
about aggregate table fragments, 10.6.3
about WHERE clause filters, 10.3.2
creating sources for each level of aggregated fact data, 10.5
specifying aggregate levels for each source, 10.5
specifying fragmentation content, 10.6
aggregate persistence
about, 12.1
default prefix, 12.1
identifying query candidates, 12.2
running the specification, 12.5
troubleshooting, 12.6
using the Aggregate Persistence Wizard, 12.3
writing script manually, 12.4
Aggregate Persistence Wizard, about, 12.3
aggregate queries, about, C.1.3
aggregate table fragments
about, 10.6.3
about configuring a repository to use fragments, 10.6.3
constructing physical joins for virtual table,
creating SQL virtual table content,
defining Physical layer tables with a SELECT Statement,
specifying aggregate table content,
AGGREGATE_PREFIX configuration option, 12.1
Aggregation content, group-by list, 10.3.1
aggregation rules
default rules for measure columns, 8.5.5
Evaluate_Aggr, 8.5.5
for multidimensional data sources,
AGO time series function, about, C.2.3.1
alias tables
about, 7.3.2
for Essbase, 7.4.2
Alias tab, using, 11.6
merging, D.2.5
Allow direct database requests by default
about, 6.1.2
recommendations for enabling,
Allow import from repository option, 2.1.3
Allow logical foreign key join creation option, 2.1.3
Allow populate queries by default, 6.1.2
alternate hierarchies, about, 7.4.5
Ancestor Reference column type, 7.4.1
application EAR file, for ADF Business Components, 5.4.3
application module, 5.1
application roles
about granting privileges for, 13.3.1
managing, 1.5
managing in the default policy store, 13.1.1
permission inheritance, 13.3.1
setting up placeholder roles, 13.5.1
AppModule Config, for ADF Business Components, 5.5, 6.3.5
AppModule Definition, for ADF Business Components, 5.5, 6.3.5
ARBORPATH, setting, 4.2.3, 15.6
multiuser development, A.2
Oracle BI Server, 1.1.1
repository, 1.1.2
ASCII string function, about, C.3.1
ASIN math function, about, C.4.3
ATAN math function, about, C.4.4
ATAN2 math function, about, C.4.5
Attribute column type, 7.4.1
auditing, for data access security, 13
cache, 2.1.3
managing, 13.1.1
AVG aggregate function, about, C.2.1.2
AVGDISTINCT aggregate function, about, C.2.1.3


Based on dimensions option for measures, 8.5.5
baseline column
behavior with aggregate functions, C.1.3.1
example, C.1.3.1
Between SQL logical operator, about, C.1.4.1
bi-init, 2.1.1, 2.2.1,,, 14.2.1, 16.2.3,, A.2.1, E.2.2
biserverxmlcli, 2.2
biserverxmlexec, 2.2
biserverxmlgen, 2.2
BIT_LENGTH string function, about, C.3.2
blank repository, creating,
BOTTOMN aggregate function, about, C.2.1.4
branching, in multiuser development, 3.6, A.3.3
bridge tables
about, 8.8
modeling in a single dimension, 8.8.2
modeling in separate dimensions, 8.8.3
modeling in the Physical layer, 8.8.1
weight factor for, 8.8
Browse dialog
about using, 2.1.6
querying for an object, 2.1.6
selecting an object in, 2.1.6
synchronizing an object in the query results list with the tree control list, 2.1.6
buffer size, setting up, 6.4.1
bulk creation of metrics, 17.3
Business Model and Mapping layer
about, 1.1.2, 8
associating measures with levels in a dimension, 8.5.6
automatically creating objects for, 8.1.2
creating logical columns, 8.5
creating logical table source content definitions, 10.3.1
defining physical to logical mapping, 10.2
managing logical table sources, 10
setting up display folders in, 8.7
tips for, 1.4.3
working with logical tables, 8.3
Business Model Diagram
about using to create joins, 8.4
displaying, 8.2
displaying qualified names in, 2.1.3
setting default window size, 2.1.3
working with, 8.2
business models
creating, 8.1.1
disabling, 8.1.1
duplicating with subject area, 8.1.3
planning, 1.2
understanding, 1.2


Cache Manager
column order, 2.1.3
Cache menu option,
Cache refresh interval option (authentication cache), 2.1.3
authentication cache, 2.1.3
managing, 1.5
settings for physical tables,
calculated items, creating, 10.2, 10.2
examples, C.1.7.4
rules, C.1.7.2
syntax, C.1.7.1
Calculation Wizard
about, 17.3
setting up, 2.1.3
using, 17.3
calculations, for level-based measures,
calendar date/time functions
about, C.5
HOUR, C.5.9
MINUTE, C.5.10
MONTH, C.5.11
NOW, C.5.14
SECOND, C.5.16
YEAR, C.5.21
call interface, for connection pools,
CASE (If) conditional expression, about, C.1.5.2
CASE (Switch) conditional expression, about, C.1.5.1
CAST conversion function, about, C.6.1, C.6.2
catalogs, creating,
CEILING math function, about, C.4.6
certification information, 1.6
CHAR string function, about, C.3.3
CHAR_LENGTH string function, about, C.3.4
character literals, about, C.1.6.1
Check out objects automatically option, 2.1.3
checking global consistency, 2.6.1
checking in changes, 2.5.4
checking out objects, 2.5.3
chronological keys
about, 9.1.1
selecting and sorting,
setting for each level,
client applications, enabling connectivity for, 14.4
Cluster Manager,
Cluster menu option,
column mapping, logical to physical, 10.2
column types, for Essbase, 7.4.1
command-line utilities, 2.2
Compare Mode, turning off, 16.1.1
Compare with Original menu option, 3.4.3
comparing repositories, 16.1
complex joins
See physical complex joins
CONCAT string function, about, C.3.5
conditional expressions
about, C.1.5
CASE (If), about and syntax, C.1.5.2
CASE (Switch), about and syntax, C.1.5, C.1.5.1
conformed dimensions,
connection pools
about, 1.4.2, 6.2
automating changes for, 6.3
call interface,
creating connection scripts, 6.3.2
creating or changing, 6.3
data source name,
for initialization blocks, 6.2.1
for standby database configuration, 4.6.3
maximum number of connections,
permissions for,
persist connection pool property, 6.4
properties for ADF Business Components, 6.3.5
require fully qualified table names,
shared logon,
Unicode database type option, 6.3.4
using net service name, Preface
write-back properties, 6.3.4
XML properties, 6.3.3
connection scripts, in connection pool, 6.3.2
consistency check
checking repository for consistency, 2.6.2
checking single object for consistency, 2.6.2
new validation rules, Preface
Consistency Check Manager
about checking repository or objects for consistency, 2.6
about messages, 2.6.1
about passing consistency check, 2.6
checking repository for consistency, 2.6.2
checking single object for consistency, 2.6.2
copying inconsistency messages, 2.6.2
correcting inconsistencies, 2.6.2
context for dimension-only queries, specifying, 11.1.5, 11.2
conversion functions
about, C.6
CAST, C.6.1
COS math function, about, C.4.7
COT math function, about, C.4.8
COUNT aggregate function, about, C.2.1.5
COUNT(*) aggregate function, about, C.2.1.7
COUNTDISTINCT aggregate function, about, C.2.1.6
create aggregates specification, writing manually, 12.4
Create New Repository Wizard, 4.1
create view function, about,
create/prepare aggregates syntax,
creating calculated items, 10.2, 10.2
credential store, managing system credentials in, 13.1.1
cube variables, working with, 7.3.6
about, 1.3.2,
viewing members, 7.6.3
working with, 7
current repository, about,
CURRENT_DATE calendar date/time function, about, C.5.1
CURRENT_TIME calendar date/time function, about, C.5.2
CURRENT_TIMESTAMP calendar date/time function, about, C.5.3
custom authenticators, managing, 13.1.1
custom properties, enabling for ADF Business Components, 5.6


data access security
about, 13.1
about applying in offline mode, 13.5
auditing, 13
data filters, setting up, 13.2.1
Data is dense option, 8.5.5
data modeling
identifying data source content, 1.3
identifying dimensions,
identifying logical dimension tables,
identifying logical fact tables,
identifying lookup tables,
objectives of, 1.2.1
planning the business model, 1.2
data source name, in connection pool,
data sources
connecting on Linux and UNIX using native ODBC drivers, 15.4
DataDirect Connect drivers, 15.3
DB2 Connect, 15.7
Essbase setup, 4.2.3, 15.6
Hyperion Financial Management setup, 4.2.4
Microsoft Analysis Services, 4.4
ODBC DSN setup, 4.2.1
Oracle Database setup, 4.2.2
Oracle RPAS setup, 4.2.5, 15.5
preconfiguration tasks, 4.2
SAP/BW, 4.4
setup on Linux and UNIX, 15.1
supported by Oracle Business Intelligence, 1.6
Teradata setup, 4.2.1, 15.4
using native gateways, 15.2
XML, 4.5
data types, transforming, 10.2
allowing or disallowing execution privileges, 13.4.4
features, about, 6.1.3
features, for driving tables, 8.4.3
row-level security in, 13.2.2
database functions
about, C.7
database hints
about, 7.9
about entering SQL comment markers, 7.9.3
creating, 7.9.3
index hint, about,
Leading hint, about,
performance considerations, 7.9.2
Physical layer objects that accept hints, 7.9
usage examples, 7.9.1
database objects
about database types, 6.1.1
assigning ODBC type, 6.1.2
automatically assigning type, 6.1.1
creating for standby database configuration, 4.6.2
creating manually, 6.1.2
setting up, 6.1
specifying features for, 6.1.3
Virtual Private Database option, 6.1.2
DATABASE system function, about, C.9.2
databases, supported, 1.6
DataDirect Connect ODBC drivers, using, 15.3
DATE data type, changing to, C.6.1
DATE_DISPLAY_FORMAT configuration option, 2.3
DATE_TIME_DISPLAY_FORMAT configuration option, 2.3
datetime literals, about, C.1.6.2
DAY_OF_QUARTER calendar date/time function, about, C.5.4
DAYNAME calendar date/time function, about, C.5.5
DAYOFMONTH calendar date/time function, about, C.5.6
DAYOFWEEK calendar date/time function, about, C.5.7
DAYOFYEAR calendar date/time function, about, C.5.8
DB2 CLI (Unicode) connection protocol, 4.3
DB2 Connect, on IBM z/OS and s/390 platforms, 15.7
DBFeatures.INI file, 6.1.3
decimal literal, about, C.
Default logging level option, 2.1.3
Default member type ALL option, for physical hierarchies, 7.6.2
default prefix, for aggregate persistence, 12.1
default window size, 2.1.3
DEFAULT_PRIVILEGES configuration option, 1.4.4, 2.3
deferring execution of initialization blocks,
DEGREES math function, about, C.4.9
delegated administration in multiuser development, A.3.3.3
deleting objects, 2.1.5
derived columns, creating, 8.5.4
Derived from existing columns using an expression option, 8.5.4
DESCRIPTION system session variable, 18.3.1
descriptor ID column, assigning to logical column, 8.5.3
design guidelines for a repository, 1.4
about hierarchies in, 9
automatically creating, 9.1.3
automatically creating level counts, 9.1.4
with multiple hierarchies,
dimension-specific aggregation rules, setting up,
direct database requests, allowing or disallowing, 13.4.4
DISABLE_CACHE_HIT system session variable, 18.3.1
DISABLE_CACHE_SEED system session variable, 18.3.1
DISABLE_PLAN_CACHE_HIT system session variable, 18.3.1
DISABLE_PLAN_CACHE_SEED system session variable, 18.3.1
DISABLE_SUBREQUEST_CACHE system session variable, 18.3.1
Disallow Online RPD Updates configuration option, 2.3, 2.5.5
Discard Local Changes menu option, 3.4.3
Display Column, for Essbase cubes,
display functions
example, C.1.3.3
reset behavior, C.1.3.3
Display original names for alias in diagrams option, 2.1.3
Display qualified names in diagrams option, 2.1.3
DISPLAYNAME system session variable, 18.3.1
documentation of repository mappings, generating, 17.2.6
double column support, enabling, 8.5.3
dragging and dropping
business models, 11.1.1
physical tables and columns, 8
driving tables
about, 8.4.3
tuning performance, 8.4.3
DSNs, setting up for the Oracle BI Server, 1.5
duplicating business model and subject area, 8.1.3
dynamic name
for physical catalog or physical schema, 7.2.2
for physical tables,
dynamic repository variables
about, 18.1.2


Edit menu, about,
editing objects, 2.1.5
Entity Objects, 5.1
equalizerpds utility, 16.2.3
equalizing objects, 16.2
equalStringSet parameter, for equalizing objects, 16.2.3
alternate hierarchies, 7.4.5
associating member attributes, 7.4.4
client libraries, 4.2.3, 15.6
column types, 7.4.1
defining aggregation rules for,
flattening metadata, 7.4.1
Gen 1 levels, 7.4.1
Generations, 7.4.1
importing from, 4.4
importing UDAs, 4.4
incremental import,
measure hierarchies, 7.4.6
modeling UDAs, 7.4.3
setting up, 4.2.3, 15.6
substitution variables, 7.4.1
using unqualified member names, 7.4.7
working with alias tables, 7.4.2
working with in the Physical layer, 7.4
ESSBASEPATH, setting, 4.2.3, 15.6
Estimate Levels, using, 9.1.4
EVALUATE database function, about, C.7.1
Evaluate_Aggr aggregation rule, 8.5.5
EVALUATE_AGGR database function, about, C.7.3
EVALUATE_ANALYTIC database function, about, C.7.2
EVALUATE_PREDICATE database function, about, C.7.4
event polling
setting up for standby database configuration, 4.6.6
using the Oracle BI Event Tables utility, 17.2.2
exchanging metadata, 1.5
execution precedence, establishing for initialization blocks, 18.5.4
EXP math function, about, C.4.10
Export logical keys option, about using with parameterized SQL queries, 11.2
Expression Builder
about using, 17.1
accessing, 17.1.1
building an expression,
categories, about, 17.1.3
example expression, 17.1.4
toolbar, 17.1.2
expression literals
character literals, about and expressing, C.1.6
decimal, about and expressing, C.
integers, about and expressing, C.
external aggregation,
External Expression, for ADF Business Components, 5.2
Externalize Strings utility, using, 17.2.3
EXTRACTBIT math function, about, C.4.11
extractprojects utility,


feature table
changing entries using Query DBMS, 6.1.3
restoring default entries for, 6.1.3
viewing in Features tab of Database dialog, 6.1.3
file compression, 3.1
File menu, about,
filters, setting up, 13.2.1
FIRST aggregate function, about, C.2.1.8
floating point literal, about, C.
FLOOR math function, about, C.4.12
foreign keys
relationship with primary keys,
fragmentation content
about, 10.6
specifying, 10.3.1
specifying multicolumn content descriptions,
specifying parallel content descriptions,
specifying single column range-based predicates, 10.6.2
specifying single column value-based predicates, 10.6.1
specifying unbalanced parallel content descriptions,
fragmented data, about,
FROM clause syntax, about, C.1.1.5
full repository merges, about, 16.3.1
fully denormalized schemas, about, 1.3.1
fully qualified names, displaying, 2.1.3
Fusion Middleware Control
Disallow Online RPD Updates, 2.3
Repository File, 2.3
settings for repository builders, 2.3


Gen 1 levels
about, 7.4.1
skipping, 2.1.3
Generate Metadata Dictionary utility, using, 17.2.7
Generate target DDL in a separate file option, 12.3
governors, setting up, 13.4
grains, for time queries, 9.3.1
grand total dimension hierarchy, example of,
grand total levels, about, 9.1.1
GROUP BY clause
query behavior with and without, C.1.3.3
syntax, about, C.1.1.7
GROUP system session variable, 18.3.1
GROUPBYCOLUMN aggregate function, about, C.2.1.9
GROUPBYLEVEL aggregate function, about, C.2.1.10
groups, managing, 1.5, 13.1.1


hardware requirements, 1.6
Help menu, about,
help, accessing, 1.4.1
Hide level based measure option, 2.1.3
Hide unusable logical table sources in Replace wizard option, 2.1.3, 17.2.1
about,, 9
about level-based, 9.1.1
about multiple,
determining type,
example of grand total hierarchy,
grand total levels, 9.1.1
level attributes, about, 9.1.1
level keys, about, 9.1.1
level-based measure calculations, about,
levels and distances in parent-child hierarchies,
levels, creating, 9.1.1
parent-child, about, 9.2.1
setting up level-based measure calculations,
skip-level, 9.1.1
time dimensions, about, 9.1.1
unbalanced, 9.1.1
hierarchy navigation functions
about, C.8
about, 7.9
creating, 7.9.3
support for, 7.9
history for multiuser development, 3.7.1
HOUR calendar date/time function, about, C.5.9
HTML tables
XML Gateway, accessing by,
Hyperion Financial Management
Application Builder, 4.2.4
importing from, 4.4
POV value, 7.5
query support, 7.5.1
setting up, 4.2.4
working with, 7.5


IBM DB2 Connect, configuring queries for UNIX, 15.7
IBM DB2 Cube Views, 2.2
icons, changing, 2.1.7
IDENTIFIER_QUOTE_CHAR parameter, 15.3.1
Identity menu option,
IFNULL conversion function, about, C.6.3
implicit fact column, setting, 11.1.5
Import Metadata Wizard, 4.3, 4.4, 4.5.2, 5.5
ADF Business Components, 5.2, 5.5
data source preconfiguration tasks, 4.2
from Essbase, 4.4
from Hyperion Financial Management, 4.4
from multidimensional data sources, 4.4
from relational data sources, 4.3
from SAP/BW, 4.4
from XML data sources, 4.5
from XMLA, 4.4
locally, 4.3
metadata, 4
through the Oracle BI Server, 4.3
XML data using ODBC, 4.5.3
In SQL logical operator, about, C.1.4.1
incremental import, for Essbase,
INDEXCOL conversion function, about,, C.6.4
indexing, about index hint instructions,
Informix Database, connecting using DataDirect Connect driver, 15.3.3
initialization blocks
about connection pools for, 6.2.1
about using with variables, 18.5.1
allowing deferred execution of,
associating with variables, 18.5.3
creating, 18.5.2
deferring execution,
enabling and disabling, 18.5.6
execution order, setting, 18.5.4
initializing dynamic repository variables,
initializing session variables,,
Required for authentication option,
row-wize initialization,
rules for deferring execution, 18.5.5
working with, 18.5
INSERT string function, about, C.3.6
installation types, supported, 1.6
integers literals, about, C.
INTERRUPT_ENABLED parameter, 15.7
Is Null SQL logical operator, about, C.1.4.1
ISANCESTOR hierarchy navigation function, about, C.8.1
ISCHILD hierarchy navigation function, about, C.8.2
ISDESCENDANT hierarchy navigation function, about, C.8.3
ISLEAF hierarchy navigation function, about, C.8.4
ISPARENT hierarchy navigation function, about, C.8.5
ISROOT hierarchy navigation function, about, C.8.6


JDBC data source, for Oracle ADF application, 5.4.4
JDKs, supported, 1.6
Job Manager,
Jobs menu option,
Joins Manager
creating logical joins,
creating physical joins, 7.7.3
using to create joins, 8.4
Joins menu option,


keyboard shortcuts in Administration Tool, F
KPIs, 1.4.3


LAST aggregate function, about, C.2.1.11
Leading hint, about,
Leaf column type, 7.4.1
LEFT string function, about, C.3.7
LENGTH string function, about, C.3.8
level attributes, about, 9.1.1
level keys, about, 9.1.1
level-based hierarchies, about, 9.1.1
level-based measures
query results,
lexicographical sorting for logical columns, 8.5.2
lifecycle management, for repository, A
Like SQL logical operator, about, C.1.4.1
limiting maximum run time, 13.4.3
limiting rows received, 13.4.2
restricting queries to time periods, 13.4.3
about data source setup, 15.1
connecting to data sources using native ODBC drivers, 15.4
database setup script, locating, 15.2
DataDirect Connect ODBC drivers, 15.3
literals, in SQL, C.1.6
Load all objects on startup option, about selecting, 2.5.2
Load Decision File option,
LOCALE configuration option, 2.3
localization, about, 1.5
localizing Presentation layer object names and descriptions, 17.2.3
LOCATE string function, about, C.3.9
LOCATEN string function, about, C.3.10
LOG math function, about, C.4.13
LOG10 math function, about, C.4.14
logging level, setting default, 2.1.3
logging, managing, 1.5
logical columns
assigning descriptor ID, 8.5.3
associating with logical levels,
changing sort order for, 8.5.2
configuring for multicurrency support,
creating, 8.5
creating derived columns, 8.5.4
enabling write back on, 8.6
lexicographical sorting, 8.5.2
mapping to physical columns, 10.2
moving or copying, 8.5.7
unmapping from source, 10.2.1
logical dimension tables
logical dimensions
about, 9
about including key column,
associating logical columns and tables with,
automatically populating level counts, 9.1.4
creating automatically, 9.1.3
creating logical levels,
creating time dimensions, 9.3.2
creating with parent-child hierarchies, 9.2.2
for multidimensional data sources, 9
modeling time dimensions, 9.3
with level-based hierarchies, 9.1
with parent-child hierarchies, 9.2
logical display folders, setting up, 8.7
logical fact tables
in a single business model, 1.4.3
logical foreign key joins, 8.4, 8.4.2
logical joins
about, 8.4
about creating, 8.4
about driving tables, 8.4.3
cardinality, 8.4.1
creating with Joins Manager,
displaying physical tables for, 8.4.4
displaying with Business Model Diagram, 8.4.1
tuning performance for driving table, 8.4.3
logical keys, exporting in Presentation layer, 11.1.4
logical levels
about keys, 9.1.1
associating logical columns for,
automatically populating level counts, 9.1.4
designating chronological keys,
grand total levels, example,
hierarchy, about, 9.1.1
populating level counts, 9.1.4
primary key, adding,
specifying preferred drill path,
logical objects, displaying mapped physical objects for, 8.4.4
logical operators, C.1.4.1
Logical SQL, about, C
logical stars and snowflakes, creating corresponding subject areas for,
logical table sources
about setting up, 10.1
creating, 10.1
defining aggregate table content definitions, 10.3
defining content of, 10.3
limiting number of rows returned, 10.3.1
managing, 10
mapping columns in, 10.2
merge algorithms for, D.2
setting priority group numbers, 10.1.1
settings for parent-child hierarchies, 10.4
using the Replace Column or Table Wizard, 17.2.1
Where clause filter, using to constrain physical tables, 10.3.2
logical tables
adding new logical table source, 10.1
associating with logical dimension,
creating and managing, 8.3
creating by dragging and dropping, 8.3.1
creating manually, 8.3.1
designating as lookup tables, 8.3.1
key, specifying, 8.3.2
working with, 8.3
LOGLEVEL system session variable, 18.3.1
logs for master repository, 3.5.3
lookup tables,, 2.6.1, 8.3.1
LOWER string function, about, C.3.11


main window, Administration Tool, 2.1.2
Manage menu, about,
managing authentication, 13.1.1
mappings, creating between Physical layer and Business Model and Mapping layer, 10.1
Marketing menu option,
master repository
about, 3.1
log, 3.5.3
tracking changes in, 3.5.3
math functions
about, C.4
ABS, C.4.1
ACOS, C.4.2
ASIN, C.4.3
ATAN, C.4.4
ATAN2, C.4.5
COS, C.4.7
COT, C.4.8
FLOOR, C.4.12
LOG, C.4.13
LOG10, C.4.14
MOD, C.4.15
PI, C.4.16
POWER, C.4.17
RAND, C.4.19
ROUND, C.4.21
SIGN, C.4.22
SIN, C.4.23
SQRT, C.4.24
TAN, C.4.25
mathematical operators, about, C.1.4.2
MAVG running aggregate function, about, C.2.2.1
MAX aggregate function, about, C.2.1.12
maximum number of connections,
about calculations for level-based measures,
associating with levels in a dimension, 8.5.6
Based on dimensions option, 8.5.5
behavior with aggregate functions, C.1.3.2
creating time series measures, 9.3.3
externally aggregated,
specifying default aggregation rule for, 8.5.5
MEDIAN aggregate function, about, C.2.1.13
Member Alias column type, 7.4.1
member counts, viewing, 7.6.3
Member Key column type, 7.4.1
memnor columns, 7.4.1
memory requirements, 1.6
menus, about, 2.1.4
Merge Local Changes menu option, 3.4.3
Merge Repository Wizard
rules for, D
using,,,, D.1
merging repositories
about, 16.3
about full merge, 16.3.1
about patch merge, 16.3.2
best practices, A.4.3
choosing merge method, A.3.4
equalizing objects, 16.2
merge rules, D
with a common parent,
without a common parent,
exchanging, 1.5
importing into IBM DB2 or Oracle Database, 1.5
querying and managing, 16.4
metadata dictionary, generating, 17.2.7
Microsoft Analysis Services, importing from, 4.4
Microsoft SQL Server, connecting using DataDirect Connect driver, 15.3.1
migrating the repository, A.2.1
MIN aggregate function, about, C.2.1.14
minimum disk space requirements, 1.6
MINUTE calendar date/time function, about, C.5.10
Miscellaneous tab, in Connection Pool dialog, 6.3.5
MOD math function, about, C.4.15
alternate hierarchies, 7.4.5
best practices for presentation tables, 11.4.1
bridge tables, 8.8
Essbase data in the Physical layer, 7.4.1
Hyperion Financial Management data, 7.5
parent-child relationship tables,
time series data, 9.3
UDAs, 7.4.3
modes, offline and online, 2.5.1
modified repository, about,
MONTH calendar date/time function, about, C.5.11
MONTH_OF_QUARTER calendar date/time function, about, C.5.12
MONTHNAME calendar date/time function, about, C.5.13
MSUM running aggregate function, about, C.2.2.2
history, 3.7.1
merge, 3.5.1
shared network directory, 3.3
multicurrency support, configuring,
multi-database joins, about,,
multidimensional data sources
about, 1.3.2
importing, 4.4
multilingual schemas,
multiple hierarchies
in the Presentation layer,
multiuser development
about, 3.1
architecture, A.2
best practices, A.4
branching, 3.6, A.3.3
case study, B
concepts, A.2.1
delegated administration, A.3.3.3
governance best practices, A.1.1
history, about viewing and deleting, 3.7.1
local changes, merging, 3.5
making changes, 3.4
merge, about, 3.5.1
metadata, changing and testing, 3.4.2
options, 3.8
planning for deployment, A.1
platforms, A.2.3
projects, 3.2, 3.4.1, 3.5, A.3.2
rolling back, A.5
sandboxes, A.2.1
setting directory, 2.1.3
setting up environment, about, 3.3
shared network directory, 3.3
styles, A.2.2
troubleshooting, A.5
understanding, A.3
Multiuser development directory option, 3.3.3


NATURAL_JOIN keyword, using in SELECT_PHYSICAL statements, C.1.2.4
nesting presentation tables,
net service name, using for Oracle Database connections, Preface
nonsystem session variables, 18.3.2
normalized schemas, about, 1.3.1
NOW calendar date/time function, about, C.5.14
NQClient utility, using, 14.2.2
nqcmd utility
disallowing access,
running for cache seeding,
using, 14.2.1
options for repository builders, 2.3
using, 1.5
NTILE aggregate function, about, C.2.1.15
NULL_VALUES_SORT_FIRST configuration option, 4.3.1
nullable, physical columns,
Number of Cache Entries option (authentication cache), 2.1.3
Number of elements at this level option,
numeric literals, about, C.1.6.3


deploying as a shared library, 5.4.2
URL for, 5.5, 6.3.5
object permissions, setting up, 13.3
checking in, 2.5.4
checking out, 2.5.3
deleting, 2.1.5
editing, 2.1.5
reordering, 2.1.5
selecting, 2.1.6
sorting, 2.1.8
OCI 10g/11g connection protocol, 4.3
OCI connections, troubleshooting, 15.2.1
OCTET_LENGTH string function, about, C.3.12
2.0 and 3.5 connection protocol, 4.3
data sources, importing metadata from, 4
DataDirect Connect drivers on Linux and UNIX, 15.3
native drivers, 15.4
for the Oracle BI Server, 1.5
setting up for data sources, 4.2.1
odbc.ini file, 15.3.1, 15.3.2, 15.3.3, 15.4, 15.5
offline mode, 2.5.1
online help, accessing, 1.4.1
online mode, 2.5.2
opaque views
about, 7.8
deleting, guidelines for, 7.8.4
deploying, 7.8.2
redeploying, guidelines for, 7.8.5
undeploying, 7.8.3
when to use, 1.4.2
operating systems, supported, 1.6
operators, in SQL, C.1.4
Options dialog, using, 2.1.3
Oracle Application Development Framework, about, 5.1
Oracle BI Event Tables utility, using, 17.2.2
Oracle BI Scheduler setup, for standby database configuration, 4.6.7
Oracle BI Server
architecture, 1.1.1
nonlocal files, about accessing, 4.5.1
ODBC DSN configuration, 1.5
starting and stopping, 1.5
utilities, 2.2
Oracle BI Server XML API
using, 1.5, 2.2
using to update connection pool settings, 6.3
Oracle BI Server XML Gateway
See XML Gateway
Oracle Business Intelligence
home page on OTN,
localizing, 1.5
logging, 1.5
new features, Preface
starting and stopping, 1.5
Oracle Database
importing from, 4.3
setting up, 4.2.2
Table or view not found error,
using net service name, Preface
using stored procedures with, 7.3.1
Oracle Database SQL Access Advisor, 2.2
Oracle instance, initializing shell window for, 2.2.1
Oracle Marketing Segmentation,, 2.1.9
Oracle RPAS
about, 4.3.1
importing from, 4.4
recommended metadata types for import, 4.3
setting SQLExtendedFetch option, 4.2.5
setting up, 4.2.5, 15.5
Oracle Scorecard and Strategy Management, modeling requirements for, 1.4.3
Oracle WebLogic Server, managing, 1.5
OracleADF_HTTP connection type, 5.5
ORDER BY clause syntax, C.1.1.8
original repository, about,
orphan locks, about, A.5
Other column type, 7.4.1
outer joins, modeling,
Outline Sort column type, 7.4.1


paint.rpd, 2.4
parallel content descriptions, examples,
Parent Reference column type, 7.4.1
parent-child hierarchies
about, 9.2.1
about levels and distances,
creating dimensions for, 9.2.2
logical table source settings, 10.4
parent-child relationship tables
defining, 9.2.3
patch repository merges
about, 16.3.2
applying patches,
generating patches,
patchrpd utility, about,
PERCENTILE aggregate function, about, C.2.1.16
avoiding extra physical join conditions,
avoiding multi-database joins for,
best physical joins for,
considerations for driving tables, 8.4.3
defining aggregations correctly, 8.5.4
defining chronological key at query grain, 9.3.1
improving using aggregate tables, 12
improving using database hints, 7.9.2
improving using query caching, 1.5
improving using unqualified member names, 7.4.7
improving with standby database configuration, 4.6
indexing relational tables when persisting aggregates, Preface
removing unnecessary objects from Physical layer, 4.4
setting correct aggregation rules,
using OCI to connect to Oracle Database, 4.3
PERIODROLLING time series function, about, C.2.3.2
permission inheritance in the repository, 13.3.1
for connection pools,
for Presentation layer objects, 11.5
limiting queries by setting up data filters, 13.2.1
report for Presentation layer objects, 11.5.1
sorting columns, 11.5.2
PERMISSIONS system session variable, 18.3.1
persist connection pool
in Database dialog, 6.1.2
setting up, 6.4
physical catalogs
specifying dynamic name, 7.2.2
physical columns
creating or editing, 7.3.4
row counts for, 7.10
viewing data, 7.3.7
physical connection settings, updating, 3.4.2
physical cube tables, about,
Physical Diagram
about using to specify multi-database joins,
accessing from Business Model and Mapping layer, 8.4.4
displaying, 7.1
displaying qualified names in, 2.1.3
foreign key join or complex join, defining, 7.7.2
physical joins, about defining, 7.7.2
setting default window size, 2.1.3
working with, 7.1
physical dimensions, about, 7.6.1
physical display folders, setting up, 7.2.3
physical hierarchies
about, 7.6.2
adding or removing cube columns, 7.6.4
Default member type ALL option, 7.6.2
physical joins
about, 7.7.1
about complex joins,
about imported key and foreign key joins, 7.7.1
about primary key and foreign key relationships,
avoiding unnecessary joins,
creating with Joins Manager, 7.7.3
defining in the Physical Diagram, 7.7.2
fragmented data, about,
multi-database joins, about,
working with, 7
Physical layer
about, 1.1.2
creating and maintaining, 4
creating manually, 6.1.2
hints, about, 7.9
identifying source content, 1.3
mapping logical columns to physical columns, 10.2
modeling bridge tables, 8.8.1
physical joins, defining with the Joins Manager, 7.7.3
queries, specifying types sent to a database, 6.1.3
removing unused objects, 17.2.8
setting up display folders, 7.2.3
tips for, 1.4.2
updating objects in, 17.2.5
working with dimensions and hierarchies, 7.6
working with Essbase data sources, 7.4
working with Hyperion Financial Management data, 7.5
working with physical tables, 7.3
physical schemas
about importing, 4
specifying dynamic name, 7.2.2
physical tables
about, 7.3.1
cache settings,
creating or editing, 7.3.3
row counts for, 7.10
setting XML properties for, 7.3.5
specifying columns and keys for, 7.3.4
table types, 7.3.1
viewing data, 7.3.7
virtual physical tables, creating, 7.3.1
working with, 7, 7.3
PI math function, about, C.4.16
platforms, supported, 1.6
Point of View (POV) value, for Hyperion Financial Management data sources, 7.5
policies, managing, 13.1.1
Populate privilege, allowing or disallowing, 13.4.5
PORTALPATH system session variable, 18.3.1
POSITION string function, about, C.3.13
POWER math function, about, C.4.17
preferences, setting, 2.1.3
preferred drill path, identifying,
PREFERRED_CURRENCY session variable,
presentation columns
about working with, 11.3.2
Alias tab, using, 11.6
creating, 11.3.2
removing, 11.1.2
renaming, 11.1.3
reordering, 11.3.2
presentation hierarchies
about, 11.4
based on logical dimensions with multiple hierarchies,
creating and managing, 11.4.1
editing properties for,
Presentation layer
about, 1.1.2, 11
Alias tab, using, 11.6
creating, 11.1
localizing names, 17.2.3
logical keys, about exporting in the subject area, 11.1.4
maintaining, 11.1.6
nested folders in Oracle BI Answers, 1.4.4,
permission report, 11.5.1
presentation columns, working with, 11.3.2
removing unnecessary columns, 11.1.2
renaming presentation columns, 11.1.3
setting permissions in, 11.5
tips for, 1.4.4
presentation levels
about, 11.4
creating and managing, 11.4.2
specifying columns for display, 11.4.2
presentation tables
Alias tab, using, 11.6
best practices for modeling, 11.4.1
creating and managing, 11.3.1
reordering columns in, 11.3.2
reordering in subject area, 11.3.1
PREVENT_DIVIDE_BY_ZERO configuration option, 8.5.4
primary key
foreign key, relationship with,
priority group numbers
about, 10.1.1
example, 10.1.1
processes, starting and stopping, 1.5
production environments, moving to, 1.5
Project Manager,
Project menu option,
about, 3.2.1, A.3.2
best practices, A.4.2
checking in, 3.5.2
checking out, 3.4.1
creating, 3.2.2
tracking checkouts and checkins, 3.5.3
upgrading, 3.2.3
Prompt when moving logical columns option, 2.1.3, 8.5.7
PROXY system session variable, 18.3.1
prunerpd utility, using, E.2
pruning repository objects, E.1
Publish to Network menu option, 3.4.3


qualified names, displaying, 2.1.3
QUARTER_OF_YEAR calendar date/time function, about, C.5.15
aggregate functions, rules for, C.1.3.3
database, specifying types sent to, 6.1.3
limiting by maximum run time, 13.4.3
limiting by number of rows, 13.4.2
restricting to time periods, 13.4.3
query caching
cache expiration time,
cache persistence time,
including tables for,
managing, 1.5
query candidates, identifying for aggregation, 12.2
Query DBMS button, using to change Feature table entries, 6.1.3
query limits, setting, 13.4
Query Related Objects feature, 16.4.2
Query Repository menu option,
Query Repository tool, 16.4.1
querying repository metadata
about, 16.4
filtering results,
using Query Related Objects, 16.4.2
using Query Repository tool, 16.4.1


RADIANS math function, about, C.4.18
ragged hierarchies
See unbalanced hierarchies
RAND math function, about, C.4.19
RANDFROMSEED math function, about, C.4.20
RANK aggregate function, about, C.2.1.17
RCOUNT running aggregate function, about, C.2.2.4
rdaadmin client tool, 15.5
read-only mode, about, 2.5.5
refresh repository view,
relational data sources
importing, 4.3
schema types, 1.3.1
Remove Unused Physical Objects utility, using, 17.2.8
Remove unused physical tables after Merge option, 2.1.3
rename map, for equalizing objects, 16.2.3
Rename Wizard, using, 17.2.4
reordering objects, 2.1.5
REPEAT string function, about, C.3.14
Replace Column or Table Wizard, using, 17.2.1
REPLACE string function, about, C.3.15
applying patches,
architecture, 1.1.2
checking consistency, 14.1
comparing with another repository, 16.1
compressed format, 3.1
design guidelines, 1.4
documentation for mappings, 17.2.6
equalizing objects, 16.2
generating patches,
layers, 1.1.2
making available for queries, 14.3
managing lifecycle for, A
merging with another repository, 16.3
migration, A.2.1
object permissions, 13.3
offline mode, 2.5.1
online mode, 2.5.2
original, modified, and current,
pruning unwanted objects, E.1
query limits, 13.4
querying, 16.4
read-only mode, 2.5.5
rolling back, A.5
row-level security, 13.2.1
saving, 14.1
testing, 14.2
upgrading, Preface
uploading, 14.3
using variables in, 18
repository builders
prerequisite knowledge, 1
tips for, 1.4
Repository Documentation utility, using, 17.2.6
repository file
create new, 4.1
options when saving, 2.6.1
Repository File configuration option, 2.3
repository objects
equalizing, 16.2
permissions, setting, 11.5
renaming, 17.2.4
repository password, changing, 16.5
repository variables
about, 18.1
associating with initialization blocks, 18.5.3
cache purging considerations, 18.1.2
creating, 18.2
dynamic, 18.1.2
initializing dynamic repository variables,
static, 18.1.1
using in Expression Builder, 18.2.1
REQUESTKEY system session variable, 18.3.1
require fully qualified table names,
Retail Predictive Application Server
See Oracle RPAS
REVERSE_LTS_PRIORITY session variable, 10.1.1
REVERSED_LTS_PRIORITY_SA_VEC session variable, 10.1.1
REVERSIBLE_LTS_PRIORITY_SA_VEC session variable, 10.1.1
RIGHT string function, about, C.3.16
RMAX running aggregate function, about, C.2.2.5
RMIN running aggregate function, about, C.2.2.6
ROLEGUIDS system session variable, 18.3.1
ROLES system session variable, 18.3.1
roles, for physical tables, 7.3.2
rolling back repository to previous versions, A.5
Root column type, 7.4.1
ROUND math function, about, C.4.21
row counts
displaying, 2.1.3, 7.10
native database, about updating in, 15.2.2
updating,, 7.10
row-level security, setting up, 13.2
row-wise initialization,
RSUM running aggregate function, about, C.2.2.3
running aggregate functions
about, C.2.2
MAVG, C.2.2.1
MSUM, C.2.2.2
RCOUNT, C.2.2.4
RMAX, C.2.2.5
RMIN, C.2.2.6
RSUM, C.2.2.3


SA System subject area, about, 1.5
sametaexport, 2.2
Sampleapp.rpd, about, 2.4
sandboxes, for multiuser development, A.2.1
SAP/BW data sources
importing from, 4.4
working with cube variables for, 7.3.6
Save Decisions to File option,
saving, the repository, 14.1
schema objects, creating in Physical layer,
about types of, 1.3.1
physical schemas, about importing, 4
relational, 1.3.1
scrolling speed, 2.1.3
SECOND calendar date/time function, about, C.5.16
data access, 13
data filters, 13.2.1
managing, 1.5
object permissions, 13.3
permission inheritance, 13.3.1
query limits, 13.4
row-level, 13.2
summary of tasks, 13.1.1
Security Manager,
security sensitive session variables, 18.4
SELECT statement
about and basic syntax, C.1.1
conditional expressions, C.1.5
GROUP BY clause syntax, C.1.1.7
mathematical operators, C.1.4.2
ORDER BY clause syntax, C.1.1.8
rules for queries and aggregate functions, C.1.3
select list syntax, C.1.1.4
SQL logical operators, C.1.4.1
subquery support, C.1.1.3
usage notes, C.1.1.2
WHERE clause syntax, C.1.1.6
about and basic syntax, C.1.2
aggregate functions not supported in, C.1.2.2
queries supported by, C.1.2.3
usage notes, C.1.2.5
using the NATURAL_JOIN keyword, C.1.2.4
SELECT_PHYSICAL system session variable, 18.3.1
selecting objects, 2.1.6
semantic models, independent, A.2.2, B.1
Session Manager,
session variables
about, 18.3
associating with initialization blocks, 18.5.3
creating, 18.4
initializing, about,
nonsystem, 18.3.2
row-wise initialization,
security sensitive, 18.4
system, 18.3.1
using for authenticating users, 18.3
using in Dynamic Name field, 7.2.2
virtual private databases, 18.4
Sessions menu option,
shared login, for connection pools,
shared network directory, for MUD, 3.3
Show Calculation Wizard introduction page option, 2.1.3
Show Consistency Checker menu option,
Show row count in physical view option, 2.1.3
Show statusbar option, 2.1.3
Show tables and dimensions only under display folders option, 2.1.3
Show toolbar option, 2.1.3
SIGN math function, about, C.4.22
SIN math function, about, C.4.23
size, of a repository file, 3.1
SKIN system session variable, 18.3.1
Skip Gen 1 levels in Essbase drag and drop actions option, 2.1.3
skip-level hierarchies, about, 9.1.1
snowflake schemas, about, 1.3.1
software requirements, 1.6
sort objects options, 2.1.3
sorting logical columns, 8.5.2
SPACE string function, about, C.3.17
SQL Bypass database
about specifying, 5.3
setting up, 5.5, 6.3.5
SQL features, specifying, 6.1.3
SQL functions
aggregate functions, about, C.2.1
calendar date/time functions, about, C.5
conversion functions, about, C.6
database functions, about, C.7
expressing literals, C.1.6
hierarchy navigation functions, about, C.8
math functions, about, C.4
running aggregate functions, about, C.2.2
string functions, about, C.3
system functions, about, C.9
time series functions, about, C.2.3
SQL operators, C.1.4
SQL syntax and semantics
conditional expressions, C.1.5
FROM clause syntax, about, C.1.1.5
GROUP BY clause syntax, about, C.1.1.7
including and setting variables, C.1.8
ORDER BY clause syntax, about, C.1.1.8
queries and aggregate functions, rules for, C.1.3
Select list syntax, C.1.1.4
Select statement, about and basic syntax, C.1.1
Select usage notes, C.1.1.2, C.1.1.3
SQL logical operators, C.1.4.1, C.1.4.2
WHERE clause syntax, about, C.1.1.6
SQLExtendedFetch option, setting for Oracle RPAS, 4.2.5
SQRT math function, about, C.4.24
SSL, enabling, 13.1.1
SSO authentication, setting up, 13.1.1
standby database configuration
about, 4.6
creating connection pools for, 4.6.3
creating database object for, 4.6.2
Oracle BI Scheduler configuration for, 4.6.7
setting up event polling with, 4.6.6
setting up usage tracking with, 4.6.5
updating write-back scripts, 4.6.4
using with Oracle Business Intelligence, 4.6.1
write operations for primary source, 4.6.1
star schemas, about, 1.3.1
starting Oracle Business Intelligence processes, 1.5
static repository variables, 18.1.1
status bar, about, 2.1.2
STDDEV aggregate function, about, C.2.1.18
STDDEV_POP aggregate function, about, C.2.1.19
stopping Oracle Business Intelligence processes, 1.5
string functions
about, C.3
ASCII, C.3.1
CHAR, C.3.3
EXP, C.4.10
LEFT, C.3.7
LOWER, C.3.11
REPEAT, C.3.14
RIGHT, C.3.16
SPACE, C.3.17
UPPER, C.3.22
subject areas
Alias tab, using, 11.6
automatically creating based on logical stars and snowflakes,
creating, 11.1.1
creating multiple for a single business model, 11.1.1
duplicating with business model, 8.1.3
exporting logical keys, 11.1.4
reordering and sorting tables in, 11.3.1
setting implicit fact column for, 11.1.5
working with, 11.2
subset repository, creating,
substitution variables, for Essbase, 7.4.1
SUBSTRING string function, about, C.3.18
SUM aggregate function, about, C.2.1.20
SUMDISTINCT aggregate function, about, C.2.1.21
surrogate keys,
Sybase ASE Database, connecting using DataDirect Connect driver, 15.3.2
system credentials, managing, 13.1.1
system functions
about, C.9
USER, C.9.1
system requirements, 1.6
system session variables, 18.3.1


Table or view not found,
table types, for physical tables, 7.3.1
TAN math function, about, C.4.25
Teradata, setting up, 4.2.1, 15.4
test to production, 1.5
testing the repository, 14.2
text strings, using the Externalize Strings utility to translate, 17.2.3
third-party products, supported, 1.6
Tile when resizing option, 2.1.3
time dimensions
about, 9.1.1
creating, 9.3.2
for Oracle Scorecard and Strategy Management, 1.4.3
modeling, 9.3
selecting and sorting chronological keys,
time series functions
about, 9.3.1, C.2.3
AGO, 9.3.1, C.2.3.1
creating measures for, 9.3.3
grains, 9.3.1
PERIODROLLING, 9.3.1, C.2.3.2
TODATE, 9.3.1, C.2.3.3
using in Expression Builder, 9.3.1
TIME_DISPLAY_FORMAT configuration option, 2.3
TIMESTAMPADD calendar date/time function, about, C.5.17
TIMESTAMPDIFF calendar date/time function, about, C.5.18
TIMEZONE system session variable, 18.3.1
tips, for repository builders, 1.4
title bar, about, 2.1.2
for Oracle Database setup on UNIX, 15.2
for the Oracle BI Server, 4.2.2
locating with Oracle Business Intelligence environment, Preface
TO_DATETIME conversion function, about, C.6.5
TODATE time series function, about, C.2.3.3
toolbar, about, 2.1.2
Tools menu, about,
TOPN aggregate function, about, C.2.1.22
transaction boundary, setting up, 6.4.1
TRIMBOTH string function, about, C.3.19
TRIMLEADING string function, about, C.3.20
TRIMTRAILING string function, about, C.3.21
TRUNCATE math function, about, C.4.26
Turn off Compare Mode option,, 16.1.1


UDA column type, 7.4.1
importing, 4.4
modeling, 7.4.3
UI hints, propagating for ADF data sources, 11.3.2
unbalanced hierarchies, about, 9.1.1
Undo Merge Local Changes menu option, 3.4.3
Unicode databases, 6.3.4
about data source setup, 15.1
connecting to data sources using native ODBC drivers, 15.4
DataDirect Connect ODBC drivers, 15.3
IBM DB2 Connect for queries, configuring, 15.7
native databases, about updating row counts, 15.2.2
unmapping logical columns, 10.2.1
unqualified member names, using for Essbase, 7.4.7
Update All Row Counts menu option,
Update Physical Layer Wizard, using, 17.2.5
considerations, Preface
IDs, 16.2.1
repositories, Preface
UPPER string function, about, C.3.22
for ADF Business Components, 5.5, 6.3.5
for connection pools,
refresh interval, for XML data sources, 6.3.3
usage tracking
managing, 1.5
setting up for standby database configuration, 4.6.5
Use Logical Column Name property, 11.1.3
user attributes, managing, 13.1.1
user authentication, setting up, 13.1.1
USER system function, about, C.9.1
USER system session variable, 18.3.1
USERGUID system session variable, 18.3.1
USERLOCALE system session variable, 18.3.1
users, managing, 1.5, 13.1.1 file, 15.2, 15.3.1, 15.3.2, 15.3.3, 15.4
Aggregate Persistence, 17.2.9
command-line, 2.2
equalizerpds, 16.2.3
Externalize Strings, 17.2.3
Generate Metadata Dictionary, 17.2.7
NQClient, 14.2.2
nqcmd, 14.2.1
Oracle BI Event Tables, 17.2.2
prunerpd, E.2
Remove Unused Physical Objects, 17.2.8
Rename Wizard, 17.2.4
Replace Column or Table in Logical Table Sources, 17.2.1
Repository Documentation, 17.2.6
Update Physical Layer, 17.2.5
Utilities menu option,


Value measure, for Hyperion Financial Management data sources, 7.5
VALUEOF conversion function, about, C.6.6
Variable Manager,
about repository variables, 18.1
about session variables, 18.3
associating with initialization blocks, 18.5.3
creating repository variables, 18.2
creating session variables, 18.4
including and setting in SQL, C.1.8
using repository variables in Expression Builder, 18.2.1
Variables menu option,
View Data, 7.3.7
view links, 5.1
View menu, about,
View Objects, 5.1
virtual physical tables, creating using Table Type, 7.3.1
Virtual Private Database, 6.1.2, 13.2.2


WEBGROUPS system session variable, 18.3.1
WebLogic Domain, for ADF Business Components, 5.4.1
WEEK_OF_QUARTER calendar date/time function, about, C.5.19
WEEK_OF_YEAR calendar date/time function, about, C.5.20
Weight Factor, for bridge tables, 8.8
WHERE clause filters, in aggregate navigation, 10.3.2
WHERE clause syntax, about, C.1.1.6
Window menu, about,
Aggregate Persistence Wizard, 12.3, 17.2.9
Calculation Wizard, 2.1.3, 17.3
Create New Repository Wizard, 4.1
Import Metadata Wizard, 4.3, 4.4, 4.5.2, 5.5
Merge Repository Wizard,,,, D.1
Rename Wizard, 17.2.4
Replace Column or Table Wizard, 17.2.1
Update Physical Layer Wizard, 17.2.5
write back, enabling on logical columns, 8.6
write-back properties, for connection pool, 6.3.4
write-back scripts, updating for standby database configuration, 4.6.4


XML data sources
about URL for, 4.5.1
importing from, 4.5
setting connection pool properties for, 6.3.3
setting physical table properties for, 7.3.5
URL refresh interval, 6.3.3
XML Gateway
about using, 4.5.2
HTML tables, accessing,
refresh interval, 4.5.2
supported security modes, 4.5.2
about using, 4.5.3
importing XML data, 4.5.3
XML utilities, 2.2
XMLA, importing from, 4.4


YEAR calendar date/time function, about, C.5.21