Index

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  Z 

Numerics

503 Service Not Available errors, avoiding, 6.3.1.1

A

ABS math function, about, C.4.1
ACOS math function, about, C.4.2
Actions menu, about, 2.1.4.6
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
propagating labels and tooltips, 5.7
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, 2.1.4.6
Edit menu, 2.1.4.2
File menu, 2.1.4.1
Help menu, 2.1.4.8
icons, 2.1.9
keyboard shortcuts, G
main window, 2.1.2
Manage menu, 2.1.4.4
opening, 2.1.1
setting preferences, 2.1.3
toolbar, 2.1.2
Tools menu, 2.1.4.5
version, 2.1.4.8
View menu, 2.1.4.3
Window menu, 2.1.4.7
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
AGGREGATE AT, C.2.1.1
alternative syntax, C.1.3.4
AVG, C.2.1.2
AVGDISTINCT, C.2.1.3
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
COUNTDISTINCT, C.2.1.6
display function reset behavior, C.1.3.3
FIRST, C.2.1.8
GROUPBYCOLUMN, C.2.1.9
GROUPBYLEVEL, C.2.1.10
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
PERCENTILE, C.2.1.16
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
SUMDISTINCT, C.2.1.21
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, 10.6.3.4
creating SQL virtual table content, 10.6.3.3
defining Physical layer tables with a SELECT Statement, 10.6.3.2
specifying aggregate table content, 10.6.3.1
AGGREGATE_PREFIX configuration option, 12.1
Aggregation content, group-by list, 10.3.1
aggregation rules
default rules for measure columns, 8.5.5
dimension-specific, 8.5.5.1
Evaluate_Aggr, 8.5.5
for multidimensional data sources, 8.5.5.2
for Oracle OLAP, 7.7.1
AGO time series function, about, C.2.3.1
alias tables
about, 7.3.2
creating, 7.3.3.2
for Essbase, 7.5.2
aliases
Alias tab, using, 11.6
merging, D.2.5
Allow direct database requests by default
about, 6.1.2
recommendations for enabling, 6.1.2.1
Allow first Connection Pool for Init Blocks option, 2.1.3
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.5.5
Analytic Workspace objects, working with, 7.7.2
Ancestor Reference column type, 7.5.1
annotations, enabling for Oracle Scorecard and Strategy Management, 14.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.5, 15.6
architecture
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.5.1
auditing, for data access security, 13
authentication
cache, 2.1.3
managing, 13.1.1
Auto Layout option, for Diagrams, 2.1.5
AVG aggregate function, about, C.2.1.2
AVGDISTINCT aggregate function, about, C.2.1.3

B

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, 2.6.3, 3.4.1.3, 4.2.5.2, 14.3, 16.2.3, 16.3.2.3.1, A.2.1, E.2.2
biserverxmlcli, 2.2
biserverxmlexec, 2.2
biserverxmlgen, 2.2
BISystem user, 2.1.3
BIT_LENGTH string function, about, C.3.2
blank repository, creating, 16.3.1.3
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.8
querying for an object, 2.1.8
selecting an object in, 2.1.8
synchronizing an object in the query results list with the tree control list, 2.1.8
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, 2.1.5
about using to create joins, 8.4
displaying, 8.2
displaying qualified names in, 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

C

Cache Manager
about, 2.1.4.4
column order, 2.1.3
Cache menu option, 2.1.4.4
Cache refresh interval option (authentication cache), 2.1.3
caching
authentication cache, 2.1.3
managing, 1.5
settings for physical tables, 7.3.3.1
calculated items, creating, 10.2, 10.2
CALCULATEDMEMBER
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, 9.1.2.3
calendar date/time functions
about, C.5
CURRENT_DATE, C.5.1
CURRENT_TIME, C.5.2
CURRENT_TIMESTAMP, C.5.3
DAY_OF_QUARTER, C.5.4
DAYNAME, C.5.5
DAYOFMONTH, C.5.6
DAYOFWEEK, C.5.7
DAYOFYEAR, C.5.8
HOUR, C.5.9
MINUTE, C.5.10
MONTH, C.5.11
MONTH_OF_QUARTER, C.5.12
MONTHNAME, C.5.13
NOW, C.5.14
QUARTER_OF_YEAR, C.5.15
SECOND, C.5.16
TIMESTAMPADD, C.5.17
TIMESTAMPDIFF, C.5.18
WEEK_OF_QUARTER, C.5.19
WEEK_OF_YEAR, C.5.20
YEAR, C.5.21
call interface, for connection pools, 6.3.1.1
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, 7.2.1.1
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, 9.1.2.5
setting for each level, 9.3.2.2
circular joins, about and eliminating, 1.4.2
client applications, enabling connectivity for, 14.5
Cluster Manager, 2.1.4.4
Cluster menu option, 2.1.4.4
Collapse All option, for Diagrams, 2.1.5
column mapping, logical to physical, 10.2
column types, for Essbase, 7.5.1
command-line utilities, 2.2
Common Enterprise Information Model, about, 1.1.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, 1.2.2.2
connection pools
about, 1.4.2, 6.2
automating changes for, 6.3
call interface, 6.3.1.1
creating connection scripts, 6.3.2
creating or changing, 6.3
data source name, 6.3.1.1
for initialization blocks, 6.2.1
for standby database configuration, 4.6.3
maximum number of connections, 6.3.1.1
permissions for, 6.3.1.1
persist connection pool property, 6.4
properties for ADF Business Components, 6.3.5
require fully qualified table names, 6.3.1.1
shared logon, 6.3.1.1
Unicode database type option, 6.3.4
URL, 6.3.1.2
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, 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
CHOOSE, C.6.2
IFNULL, C.6.3
INDEXCOL, C.6.4
TO_DATETIME, C.6.5
VALUEOF, C.6.6
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, 7.9.2.1
create/prepare aggregates syntax, 12.4.3.1
creating calculated items, 10.2, 10.2
credential store, managing system credentials in, 13.1.1
cube variables, working with, 7.4.4
cubes
about, 1.3.2, 7.4.1
viewing members, 7.4.5
working with, 7
current repository, about, 16.3.1.1
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

D

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, 1.2.2.3
identifying logical dimension tables, 1.2.2.2
identifying logical fact tables, 1.2.2.1
identifying lookup tables, 1.2.2.4
objectives of, 1.2.1
planning the business model, 1.2
data source name, in connection pool, 6.3.1.1
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.5, 15.6
Hyperion Financial Management setup, 4.2.6
Microsoft Analysis Services, 4.4
ODBC DSN setup, 4.2.1
Oracle Database setup, 4.2.2
Oracle OLAP setup, 4.2.3
Oracle RPAS setup, 4.2.8, 15.5
preconfiguration tasks, 4.2
SAP/BW setup, 4.2.7
setup on Linux and UNIX, 15.1
supported by Oracle Business Intelligence, 1.6
Teradata setup, 4.2.1, 15.4
TimesTen setup, 4.2.4
using native gateways, 15.2
XML, 4.5
data types, transforming, 10.2
database
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
EVALUATE, C.7.1
EVALUATE_AGGR, C.7.3
EVALUATE_ANALYTIC, C.7.2
EVALUATE_PREDICATE, C.7.4
database hints
about, 7.10
about entering SQL comment markers, 7.10.3
creating, 7.10.3
index hint, about, 7.10.1.1
Leading hint, about, 7.10.1.2
performance considerations, 7.10.2
Physical layer objects that accept hints, 7.10
usage examples, 7.10.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
DB2 Cube Views
deploying cube metadata, F.4.2
guidelines for materialized query tables (MQTs), F.4.2.3
DB2 Cube Views Generator
about, F.1, F.4.1
about input file for, F.2.2
about output files for, F.2.3
conversion rules, F.2.5
exporting metadata into DB2 Cube Views, F.4
generating import file, F.2
optional parameters and defaults, F.2.1
troubleshooting, F.2.4
DBFeatures.INI file, 6.1.3
decimal literal, about, C.1.6.3.2
Default logging level option, 2.1.3
default prefix, for aggregate persistence, 12.1
DEFAULT_PRIVILEGES configuration option, 1.4.4, 2.3
deferring execution of initialization blocks, 18.5.2.1
DEGREES math function, about, C.4.9
delegated administration in multiuser development, A.3.3.3
deleting objects, 2.1.6
Density option, for Oracle OLAP, 7.7.4
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
Diagrams
about using, 2.1.5
dimensions
about, 1.2.2.3
about hierarchies in, 9
automatically creating, 9.1.3
automatically creating level counts, 9.1.4
identifying, 1.2.2.3
with multiple hierarchies, 1.2.2.3.1
dimension-specific aggregation rules, setting up, 8.5.5.1
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
Disallow RPD Updates configuration option, 2.5.5
Discard Local Changes menu option, 3.4.3
Display Column, for Essbase cubes, 7.5.2.1
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, 7.3.3.1
dynamic repository variables
about, 18.1.2
initializing, 18.5.1.1

E

Edit menu, about, 2.1.4.2
editing objects, 2.1.6
Entity Objects, 5.1
equalizerpds utility, 16.2.3
equalizing objects, 16.2
equalStringSet parameter, for equalizing objects, 16.2.3
Essbase
alternate hierarchies, 7.5.5
associating member attributes, 7.5.4
client libraries, 4.2.5, 15.6
column types, 7.5.1
defining aggregation rules for, 8.5.5.2
flattening metadata, 7.5.1
Gen 1 levels, 7.5.1
Generations, 7.5.1
importing from, 4.4
importing UDAs, 4.4
incremental import, 7.5.1.1
measure hierarchies, 7.5.6
modeling UDAs, 7.5.3
setting up, 4.2.5, 15.6
SSO using CSS Token, 6.3.1.2
substitution variables, 7.5.1
using unqualified member names, 7.5.7
working with alias tables, 7.5.2
working with in the Physical layer, 7.5
ESSBASEPATH, setting, 4.2.5, 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
about, F.1
generating import file, F.2, F.2
with IBM DB2 using DB2 Cube Views, F.4
with Oracle Database using SQL Access Advisor, F.3
execution precedence, establishing for initialization blocks, 18.5.4
EXP math function, about, C.4.10
Expand All option, for Diagrams, 2.1.5
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, 17.1.4.2
categories, about, 17.1.3
example expression, 17.1.4
navigating, 17.1.4.1
toolbar, 17.1.2
expression literals
character literals, about and expressing, C.1.6
decimal, about and expressing, C.1.6.3.2
integers, about and expressing, C.1.6.3.1
external aggregation, 7.4.2.1
External Expression, for ADF Business Components, 5.2
Externalize Strings utility, using, 17.2.3
EXTRACTBIT math function, about, C.4.11
extractprojects utility, 3.4.1.3

F

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, 2.1.4.1
filters, setting up, 13.2.1
FIRST aggregate function, about, C.2.1.8
Fit option, for Diagrams, 2.1.5
floating point literal, about, C.1.6.3.3
FLOOR math function, about, C.4.12
foreign keys
relationship with primary keys, 7.8.1.1
fragmentation content
about, 10.6
specifying, 10.3.1
specifying multicolumn content descriptions, 10.6.2.1
specifying parallel content descriptions, 10.6.2.2
specifying single column range-based predicates, 10.6.2
specifying single column value-based predicates, 10.6.1
specifying unbalanced parallel content descriptions, 10.6.2.3
fragmented data, about, 7.8.1.4
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

G

Gen 1 levels
about, 7.5.1
skipping, 2.1.3
Generate ADF Label option, 5.7.3
Generate ADF Tooltip option, 5.7.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, 9.1.2.3
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

H

hardware requirements, 1.6
Help menu, about, 2.1.4.8
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
hierarchies
about, 1.2.2.3, 9
about level-based, 9.1.1
about multiple, 1.2.2.3.1
determining type, 1.2.2.3
example of grand total hierarchy, 9.1.2.3
grand total levels, 9.1.1
level attributes, about, 9.1.1
level keys, about, 9.1.1
level-based measure calculations, about, 9.1.2.3
levels and distances in parent-child hierarchies, 9.2.1.1
levels, creating, 9.1.1
parent-child, about, 9.2.1
setting up level-based measure calculations, 9.1.2.3
skip-level, 9.1.1
time dimensions, about, 9.1.1
unbalanced, 9.1.1
hierarchy navigation functions
about, C.8
ISANCESTOR, C.8.1
ISCHILD, C.8.2
ISDESCENDANT, C.8.3
ISLEAF, C.8.4
ISPARENT, C.8.5
ISROOT, C.8.6
hints
about, 7.10
creating, 7.10.3
support for, 7.10
history for multiuser development, 3.7.1
HOUR calendar date/time function, about, C.5.9
HTML tables
XML Gateway, accessing by, 4.5.2.2
Hyperion Financial Management
Application Builder, 4.2.6
importing from, 4.4
POV value, 7.6
query support, 7.6.1
setting up, 4.2.6
SSO using CSS Token, 6.3.1.2
working with, 7.6

I

IBM DB2 Connect, configuring queries for UNIX, 15.7
IBM DB2 Cube Views, 2.2
about, F.1
using to create DB2 materialized query tables, F.4
icons, changing, 2.1.9
IDENTIFIER_QUOTE_CHAR parameter, 15.3.1
Identity Manager, 2.1.4.4
Identity menu option, 2.1.4.4
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
importing
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 Oracle OLAP, 4.4
from Oracle RPAS, 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, 7.5.1.1
INDEXCOL conversion function, about, 17.1.4.3, C.6.4
indexing, about index hint instructions, 7.10.1.1
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, 18.5.2.1
associating with variables, 18.5.3
creating, 18.5.2
deferring execution, 18.5.1.2
enabling and disabling, 18.5.6
execution order, setting, 18.5.4
initializing dynamic repository variables, 18.5.1.1
initializing session variables, 18.5.1.2, 18.5.1.2
Required for authentication option, 18.5.2.1
row-wize initialization, 18.5.1.3
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.1.6.3.1
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

J

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

K

keyboard shortcuts in Administration Tool, G
KPIs, 1.4.3

L

labels, for ADF data sources, 5.7.1
LAST aggregate function, about, C.2.1.11
Leading hint, about, 7.10.1.2
Leaf column type, 7.5.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
about, 9.1.2.3
calculations, 9.1.2.3
query results, 9.1.2.3
lexicographical sorting for logical columns, 8.5.2
lifecycle management, for repository, A
Like SQL logical operator, about, C.1.4.1
limits
limiting maximum run time, 13.4.3
limiting rows received, 13.4.2
restricting queries to time periods, 13.4.3
Linux
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, 16.3.1.2
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 for BISystem user, 2.1.3
logging, managing, 1.5
logical columns
assigning descriptor ID, 8.5.3
associating with logical levels, 9.1.2.3
changing sort order for, 8.5.2
configuring for multicurrency support, 8.5.4.1
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
about, 1.2.2.2
identifying, 1.2.2.2
logical dimensions
about, 9
about including key column, 9.1.2.3
associating logical columns and tables with, 9.1.2.3
automatically populating level counts, 9.1.4
creating, 9.1.2.1
creating automatically, 9.1.3
creating logical levels, 9.1.2.2
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
about, 1.2.2.1
identifying, 1.2.2.1
in a single business model, 1.4.3
joins, 1.2.2.1
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, 8.4.2.1
creating with Joins Manager, 8.4.2.1
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, 9.1.2.3
automatically populating level counts, 9.1.4
creating, 9.1.2.2
designating chronological keys, 9.3.2.2
grand total levels, example, 9.1.2.3
hierarchy, about, 9.1.1
populating level counts, 9.1.4
primary key, adding, 9.1.2.4
specifying preferred drill path, 9.1.2.6
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, 11.1.1.1
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, 9.1.2.3
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, 1.2.2.4, 2.6.1, 8.3.1
LOWER string function, about, C.3.11

M

main window, Administration Tool, 2.1.2
Manage menu, about, 2.1.4.4
ManageRepositories permission, 2.5.2
managing authentication, 13.1.1
mappings, creating between Physical layer and Business Model and Mapping layer, 10.1
Marketing menu option, 2.1.4.4
Marquee Zoom option, for Diagrams, 2.1.5
master repository
about, 3.1
log, 3.5.3
tracking changes in, 3.5.3
Materialization option, for Oracle OLAP, 7.7.4
materialized query tables (MQTs), about, F.4.1
materialized views
creating, F.3.2.4
using, F.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
CEILING, C.4.6
COS, C.4.7
COT, C.4.8
DEGREES, C.4.9
EXTRACTBIT, C.4.11
FLOOR, C.4.12
LOG, C.4.13
LOG10, C.4.14
MOD, C.4.15
PI, C.4.16
POWER, C.4.17
RADIANS, C.4.18
RAND, C.4.19
RANDFROMSEED, C.4.20
ROUND, C.4.21
SIGN, C.4.22
SIN, C.4.23
SQRT, C.4.24
TAN, C.4.25
TRUNCATE, C.4.26
mathematical operators, about, C.1.4.2
MAVG running aggregate function, about, C.2.2.1
MAX aggregate function, about, C.2.1.12
MAX_PARAMETERS_PER_DRIVE_JOIN parameter, 8.4.3
MAX_QUERIES_PER_DRIVE_JOIN parameter, 8.4.3
maximum number of connections, 4.2.4.1, 6.3.1.1
MaxThreadsPerClient setting, for Microsoft Analysis Services, 6.3.1.1
measures
about calculations for level-based measures, 9.1.2.3
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, 7.4.2.1
specifying default aggregation rule for, 8.5.5
MEDIAN aggregate function, about, C.2.1.13
Member Alias column type, 7.5.1
member counts, viewing, 7.4.5
Member Key column type, 7.5.1
memnor columns, 7.5.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, 16.3.1.2, 16.3.1.3, 16.3.2.3, 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, 16.3.1.2
without a common parent, 16.3.1.3
metadata
querying and managing, 16.4
metadata dictionary, generating, 17.2.7
Microsoft Analysis Services
avoiding connection errors for, 6.3.1.1
importing from, 4.4
MaxThreadsPerClient setting, 6.3.1.1
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
modeling
alternate hierarchies, 7.5.5
best practices for presentation tables, 11.4.1
bridge tables, 8.8
Essbase data in the Physical layer, 7.5.1
Hyperion Financial Management data, 7.6
Oracle OLAP data, 7.7.1
parent-child relationship tables, 9.2.3.1
time series data, 9.3
UDAs, 7.5.3
modes, offline and online, 2.5.1
modified repository, about, 16.3.1.1
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
MUD
history, 3.7.1
merge, 3.5.1
shared network directory, 3.3
multicurrency support, configuring, 8.5.4.1
multi-database joins, about, 7.8.1.3, 7.8.1.3
multidimensional data sources
about, 1.3.2
importing, 4.4
multilingual schemas, 1.2.2.4
multiple hierarchies
about, 1.2.2.3.1
in the Presentation layer, 11.4.1.1
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

N

naming restrictions for repository objects, 2.1.7
NATURAL_JOIN keyword, using in SELECT_PHYSICAL statements, C.1.2.4
nesting presentation tables, 11.3.1.1
net service name, using for Oracle Database connections, Preface
New Join option, for Diagrams, 2.1.5
New Table option, for Diagrams, 2.1.5
nonsystem session variables, 18.3.2
normalized schemas, about, 1.3.1
NOW calendar date/time function, about, C.5.14
nqcmd utility
disallowing access, 6.1.2.1
running for cache seeding, 6.1.2.1
using, 14.3
NQSConfig.INI
AGGREGATE_PREFIX, 12.1
DATE_DISPLAY_FORMAT, 2.3
DATE_TIME_DISPLAY_FORMAT, 2.3
DEFAULT_PRIVILEGES, 1.4.4, 2.3
LOCALE, 2.3
NULL_VALUES_SORT_FIRST, 4.4.1
options for repository builders, 2.3
PREVENT_DIVIDE_BY_ZERO, 8.5.4
TIME_DISPLAY_FORMAT, 2.3
using, 1.5
NTILE aggregate function, about, C.2.1.15
NULL_VALUES_SORT_FIRST configuration option, 4.4.1
nullable, physical columns, 7.3.4.1
Number of Cache Entries option (authentication cache), 2.1.3
Number of elements at this level option, 9.1.2.2
numeric literals, about, C.1.6.3

O

OBIEEBroker
deploying as a shared library, 5.4.2
URL for, 5.5, 6.3.5
object permissions, setting up, 13.3
objects
checking in, 2.5.4
checking out, 2.5.3
deleting, 2.1.6
editing, 2.1.6
naming requirements for, 2.1.7
reordering, 2.1.6
selecting, 2.1.8
sorting, 2.1.10
OCI 10g/11g connection protocol, 4.3
OCI connections, troubleshooting, 15.2.1
OCTET_LENGTH string function, about, C.3.12
ODBC
2.0 and 3.5 connection protocol, 4.3
about query failures, 4.2.4.1
data sources, importing metadata from, 4
DataDirect Connect drivers on Linux and UNIX, 15.3
native drivers, 15.4
ODBC DSN
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.9
deleting, guidelines for, 7.9.4
deploying, 7.9.2
redeploying, guidelines for, 7.9.5
undeploying, 7.9.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 Web services, using, 1.5
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, 2.1.4.8
localizing, 1.5
logging, 1.5
new features, Preface
starting and stopping, 1.5
Oracle Database
about exchanging metadata with, F.1
deploying metadata in, F.3.2
importing from, 4.3
setting up, 4.2.2
Table or view not found error, 6.3.1.1
using net service name, Preface
using stored procedures with, 7.3.1
Oracle Database Metadata Generator
about, F.1
about input file for, F.2.2
about output files for, F.2.3
conversion rules, F.2.5
exporting metadata into SQL Access Advisor, F.3
generating import file, F.2
optional parameters and defaults, F.2.1
troubleshooting, F.2.4
Oracle Database SQL Access Advisor, 2.2
Oracle instance, initializing shell window for, 2.2.1
Oracle Marketing Segmentation, 2.1.4.4, 2.1.11
Oracle OLAP
about, 7.7
about cubes and columns, 7.7.4
about dimensions, hierarchies, and levels, 7.7.3
default aggregation rule, 7.7.1
Density option, 7.7.4
importing from, 4.4
Materialization option, 7.7.4
setting up, 4.2.3
working with, 7.7
Oracle RPAS
about, 4.4.1
importing from, 4.4
recommended metadata types for import, 4.4
setting SQLExtendedFetch option, 4.2.8
setting up, 4.2.8, 15.5
Oracle Scorecard and Strategy Management
enabling comments and status overrides for, 14.1
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, 16.3.1.1
orphan locks, about, A.5
Other column type, 7.5.1
outer joins, modeling, 1.4.3.1
Outline Sort column type, 7.5.1

P

paint.rpd, 2.4
Pan option, for Diagrams, 2.1.5
parallel content descriptions, examples, 10.6.2.2.1
Parent Reference column type, 7.5.1
parent-child hierarchies
about, 9.2.1
about levels and distances, 9.2.1.1
creating dimensions for, 9.2.2
logical table source settings, 10.4
maintaining, 9.2.3.2
parent-child relationship tables
about, 9.2.1.2
defining, 9.2.3
modeling, 9.2.3.1
patch repository merges
about, 16.3.2
applying patches, 16.3.2.3
generating patches, 16.3.2.2
patchrpd utility, about, 16.3.2.3.1
PERCENTILE aggregate function, about, C.2.1.16
performance
accelerating by exchanging metadata with databases, F.1
avoiding extra physical join conditions, 7.8.1.4
avoiding multi-database joins for, 7.8.1.3
best physical joins for, 7.8.1.2
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.10.2
improving using query caching, 1.5
improving using unqualified member names, 7.5.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, 7.4.2
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
permissions
default, 13.1.1
for connection pools, 6.3.1.1
for Presentation layer objects, 11.5
limiting queries by setting up data filters, 13.2.1
report for Presentation layer objects, 11.5.1
required for online mode, 2.5.2
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
creating, 7.2.1.1
specifying dynamic name, 7.2.2
physical columns
creating or editing, 7.3.4
nullable, 7.3.4.1
row counts for, 7.11
type, 7.3.4.1
viewing data, 7.3.5
physical connection settings, updating, 3.4.2
physical cube tables, about, 7.4.1
Physical Diagram
about using, 2.1.5
about using to specify multi-database joins, 7.8.1.3
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.8.2
physical joins, about defining, 7.8.2
working with, 7.1
physical dimensions, about, 7.4.3.1
physical display folders, setting up, 7.2.3
physical hierarchies
about, 7.4.3.2
adding or removing cube columns, 7.4.3.2.1
setting the hierarchy type, 7.4.3.2
physical joins
about, 7.8.1
about complex joins, 7.8.1.2
about imported key and foreign key joins, 7.8.1
about primary key and foreign key relationships, 7.8.1.1
avoiding unnecessary joins, 7.8.1.4
creating with Joins Manager, 7.8.3
defining in the Physical Diagram, 7.8.2
fragmented data, about, 7.8.1.4
multi-database joins, about, 7.8.1.3
working with, 7
Physical layer
about, 1.1.2
creating and maintaining, 4
creating manually, 6.1.2
hints, about, 7.10
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.8.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.4
working with Essbase data sources, 7.5
working with Hyperion Financial Management data, 7.6
working with multidimensional sources, 7.4
working with Oracle OLAP data, 7.7.1
working with physical tables, 7.3
physical schemas
about importing, 4
creating, 7.2.1.2
specifying dynamic name, 7.2.2
physical tables
about, 7.3.1
cache settings, 7.3.3.1
creating or editing, 7.3.3
row counts for, 7.11
setting XML properties for, 7.3.3.3
specifying columns and keys for, 7.3.4
table types, 7.3.1
viewing data, 7.3.5
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.6
policies, managing, 13.1.1
Populate privilege, allowing or disallowing, 13.4.5
POPULATE SQL, 6.1.2
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, 9.1.2.6
PREFERRED_CURRENCY session variable, 8.5.4.1
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, 11.4.1.1
creating and managing, 11.4.1
editing properties for, 11.4.1.2
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, 11.3.1.1
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
nesting, 11.3.1.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, 7.8.1.1
specifying, 7.3.4.2
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, 2.1.4.4
Project menu option, 2.1.4.4
projects
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

Q

qualified names, displaying, 2.1.3
QUARTER_OF_YEAR calendar date/time function, about, C.5.15
queries
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, 7.3.3.1
cache persistence time, 7.3.3.1
including tables for, 7.3.3.1
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, 2.1.4.5
Query Repository tool, 16.4.1
query workload, creating, F.3.2.3
querying repository metadata
about, 16.4
filtering results, 16.4.1.1
using Query Related Objects, 16.4.2
using Query Repository tool, 16.4.1

R

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, 2.1.4.3
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.6
REPEAT string function, about, C.3.14
Replace Column or Table Wizard, using, 17.2.1
REPLACE string function, about, C.3.15
repository
applying patches, 16.3.2.3
architecture, 1.1.2
checking consistency, 14.2
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, 16.3.2.2
layers, 1.1.2
making available for queries, 14.4
managing lifecycle for, A
merging with another repository, 16.3
migration, A.2.1
object naming restrictions, 2.1.7
object permissions, 13.3
offline mode, 2.5.1
online mode, 2.5.2
opening, 2.1.4.1
original, modified, and current, 16.3.1.1
pruning unwanted objects, E.1
query limits, 13.4
querying, 16.4
read-only mode, 2.5.5
refreshing, 2.1.4.3
rolling back, A.5
row-level security, 13.2.1
saving, 14.2
testing, 14.3
upgrading, Preface
uploading, 14.4
using variables in, 18
repository builders
prerequisite knowledge, 1
tips for, 1.4
Repository Documentation utility, using, 17.2.6
repository file
blank, 16.3.1.3
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, 18.5.1.1
static, 18.1.1
using in Expression Builder, 18.2.1
REQUESTKEY system session variable, 18.3.1
require fully qualified table names, 6.3.1.1
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.5.1
ROUND math function, about, C.4.21
row counts
displaying, 2.1.3, 7.11
native database, about updating in, 15.2.2
updating, 2.1.4.5, 7.11
row-level security, setting up, 13.2
row-wise initialization, 18.5.1.3
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

S

SA System subject area, about, 1.5
sametaexport, 2.2
sametaexport utility
about, F.1
parameters, F.2.1
running, F.2.1
SampleAppLite.rpd
about, 2.4
changing password for, 16.5
default password for, 2.4
Sampleapp.rpd, about, 2.4
sandboxes, for multiuser development, A.2.1
SAP/BW
connection pool properties, 6.3.1.2
importing from, 4.4
setting up, 4.2.7
SAP/BW data sources
working with cube variables for, 7.4.4
Save Decisions to File option, 16.3.1.2
saving, the repository, 14.2
schema objects, creating in Physical layer, 7.2.1.2
schemas
about types of, 1.3.1
multilingual, 1.2.2.4
physical schemas, about importing, 4
relational, 1.3.1
scrolling speed, 2.1.3
SECOND calendar date/time function, about, C.5.16
security
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 sensitive session variables, 18.4
Select option, for Diagrams, 2.1.5
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
SELECT_PHYSICAL statement
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.8
semantic models, independent, A.2.2, B.1
Session Manager, 2.1.4.4
session variables
about, 18.3
associating with initialization blocks, 18.5.3
creating, 18.4
initializing, about, 18.5.1.2
naming scheme for ADF data source UI hints, 5.7.2
nonsystem, 18.3.2
PREFERRED_CURRENCY, 8.5.4.1
REVERSE_LTS_PRIORITY, 10.1.1
REVERSED_LTS_PRIORITY_SA_VEC, 10.1.1
REVERSIBLE_LTS_PRIORITY_SA_VEC, 10.1.1
row-wise initialization, 18.5.1.3
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, 2.1.4.4
shared login, for connection pools, 6.3.1.1
shared network directory, for MUD, 3.3
Show Calculation Wizard introduction page option, 2.1.3
Show Consistency Checker menu option, 2.1.4.5
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 Access Advisor
about, F.1
using to create materialized views, F.3
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.8
SQRT math function, about, C.4.24
SSL, enabling, 13.1.1
SSO authentication, setting up, 13.1.1
SSO using CSS Token, for Essbase and Hyperion Financial Management, 6.3.1.2
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
status, enabling overrides for Oracle Scorecard and Strategy Management, 14.1
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
BIT_LENGTH, C.3.2
CHAR, C.3.3
CHAR_LENGTH, C.3.4
CONCAT, C.3.5
EXP, C.4.10
INSERT, C.3.6
LEFT, C.3.7
LENGTH, C.3.8
LOCATE, C.3.9
LOCATEN, C.3.10
LOWER, C.3.11
OCTET_LENGTH, C.3.12
POSITION, C.3.13
REPEAT, C.3.14
REPLACE, C.3.15
RIGHT, C.3.16
SPACE, C.3.17
SUBSTRING, C.3.18
TRIMBOTH, C.3.19
TRIMLEADING, C.3.20
TRIMTRAILING, C.3.21
UPPER, C.3.22
subject areas
Alias tab, using, 11.6
automatically creating based on logical stars and snowflakes, 11.1.1.1
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, 3.4.1.2
substitution variables, for Essbase, 7.5.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, 1.2.2.2
Sybase ASE Database, connecting using DataDirect Connect driver, 15.3.2
system credentials, managing, 13.1.1
system functions
about, C.9
DATABASE, C.9.2
USER, C.9.1
system requirements, 1.6
system session variables, 18.3.1

T

Table or view not found, 6.3.1.1
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.3
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, 9.1.2.5
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
TimesTen
avoiding query failures with, 4.2.4.1
setting up, 4.2.4
TIMEZONE system session variable, 18.3.1
tips, for repository builders, 1.4
title bar, about, 2.1.2
tnsnames.ora
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
options for Diagrams, 2.1.5
Tools menu, about, 2.1.4.5
tooltips, for ADF data sources, 5.7.1
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
troubleshooting
DB2 Cube Views Generator, F.2.4
Oracle Database Metadata Generator, F.2.4
TRUNCATE math function, about, C.4.26
Turn off Compare Mode option, 2.1.4.1, 16.1.1

U

UDA column type, 7.5.1
UDAs
importing, 4.4
modeling, 7.5.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
UNIX
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.5.7
Update All Row Counts menu option, 2.1.4.5
Update Physical Layer Wizard, using, 17.2.5
upgrade
considerations, Preface, Preface
IDs, 16.2.1
repositories, Preface
UPPER string function, about, C.3.22
URL
for ADF Business Components, 5.5, 6.3.5
for connection pools, 6.3.1.2
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 authentication, setting up, 13.1.1
user interface hints, for ADF data sources, 5.7
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
user.sh file, 15.2, 15.3.1, 15.3.2, 15.3.3, 15.4
utilities
Aggregate Persistence, 17.2.9
command-line, 2.2
equalizerpds, 16.2.3
Externalize Strings, 17.2.3
extractprojects, 3.4.1.3
Generate Metadata Dictionary, 17.2.7
nqcmd, 14.3
Oracle BI Event Tables, 17.2.2
patchrpd, 16.3.2.3.1
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
validaterpd, 2.6.3
Utilities menu option, 2.1.4.5

V

validaterpd utility, 2.6.3
Value measure, for Hyperion Financial Management data sources, 7.6
VALUEOF conversion function, about, C.6.6
Variable Manager, 2.1.4.4
variables
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, 2.1.4.4
View Data, 7.3.5
view links, 5.1
View menu, about, 2.1.4.3
View Objects, 5.1
virtual physical tables, creating using Table Type, 7.3.1
Virtual Private Database, 6.1.2, 13.2.2

W

Web services, for Oracle BI Server, 1.5
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, 2.1.4.7
wizards
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, 16.3.1.2, 16.3.1.3, 16.3.2.3, 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

X

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.3.3
URL refresh interval, 6.3.3
XML Gateway
about using, 4.5.2
examples, 4.5.2.1
HTML tables, accessing, 4.5.2.2
refresh interval, 4.5.2
supported security modes, 4.5.2
XML ODBC
about using, 4.5.3
example, 4.5.3.1
importing XML data, 4.5.3
XML utilities, 2.2
XMLA, importing from, 4.4

Y

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

Z

Zoom In option, for Diagrams, 2.1.5
Zoom Out option, for Diagrams, 2.1.5