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
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
- 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.7
- keyboard shortcuts, F
- 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
- AGO time series function, about, C.2.3.1
- alias tables
-
- about, 7.3.2
- creating, 7.3.3.2
- for Essbase, 7.4.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 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
- 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.4.1
- auditing, for data access security, 13
- authentication
-
- cache, 2.1.3
- managing, 13.1.1
- 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, 3.4.1.3, 4.2.3.2, 14.2.1, 16.2.3, 16.3.2.3.1, 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, 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.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
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
- client applications, enabling connectivity for, 14.4
- Cluster Manager, 2.1.4.4
- Cluster menu option, 2.1.4.4
- 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, 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
- 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.8.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.3.6
- cubes
-
- about, 1.3.2, 7.3.1.1
- viewing members, 7.6.3
- 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.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
- 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.9
- about entering SQL comment markers, 7.9.3
- creating, 7.9.3
- index hint, about, 7.9.1.1
- Leading hint, about, 7.9.1.2
- 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.1.6.3.2
- 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, 18.5.2.1
- 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
- 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, 2.5.5
- Discard Local Changes menu option, 3.4.3
- Display Column, for Essbase cubes, 7.4.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.5
- 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.4.5
- associating member attributes, 7.4.4
- client libraries, 4.2.3, 15.6
- column types, 7.4.1
- defining aggregation rules for, 8.5.5.2
- 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, 7.4.1.1
- 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, 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.3.4.1.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
- floating point literal, about, C.1.6.3.3
- FLOOR math function, about, C.4.12
- foreign keys
-
- relationship with primary keys, 7.7.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.7.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.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, 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.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, 4.5.2.2
- 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
I
- 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, 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 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.4.1.1
- INDEXCOL conversion function, about, 17.1.4.3, C.6.4
- indexing, about index hint instructions, 7.9.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.7.3
- using to create joins, 8.4
- Joins menu option, 2.1.4.4
K
- keyboard shortcuts in Administration Tool, F
- KPIs, 1.4.3
L
- LAST aggregate function, about, C.2.1.11
- Leading hint, about, 7.9.1.2
- 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
-
- 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 default, 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
- 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
- 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
- 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, 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.3.4.1.1
- 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, 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
-
- 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
- modeling
-
- 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, 9.2.3.1
- time series data, 9.3
- UDAs, 7.4.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.7.1.3, 7.7.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
- 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
- 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, 6.1.2.1
- running for cache seeding, 6.1.2.1
- using, 14.2.1
- 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.3.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.3.1
- nullable, physical columns, 7.3.4.2
- 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.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
- ODBC
-
- 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
- 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.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, 2.1.4.8
- 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, 6.3.1.1
- 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.4.4, 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, 16.3.1.1
- orphan locks, about, A.5
- Other column type, 7.4.1
- outer joins, modeling, 1.4.3.1
- Outline Sort column type, 7.4.1
P
- paint.rpd, 2.4
- parallel content descriptions, examples, 10.6.2.2.1
- Parent Reference column type, 7.4.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
-
- avoiding extra physical join conditions, 7.7.1.4
- avoiding multi-database joins for, 7.7.1.3
- best physical joins for, 7.7.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.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, 7.3.4.1
- 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
-
- 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
- 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.2
- row counts for, 7.10
- type, 7.3.4.2
- viewing data, 7.3.7
- physical connection settings, updating, 3.4.2
- physical cube tables, about, 7.3.1.1
- Physical Diagram
-
- about using to specify multi-database joins, 7.7.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.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, 7.7.1.2
- about imported key and foreign key joins, 7.7.1
- about primary key and foreign key relationships, 7.7.1.1
- avoiding unnecessary joins, 7.7.1.4
- creating with Joins Manager, 7.7.3
- defining in the Physical Diagram, 7.7.2
- fragmented data, about, 7.7.1.4
- multi-database joins, about, 7.7.1.3
- 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
- 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.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
- 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.7.1.1
- specifying, 7.3.4.3
- 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
- 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.5
- 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.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, 16.3.2.2
- 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
- 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.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
-
- 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.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, 2.1.4.5, 7.10
- 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
- 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, 16.3.1.2
- saving, the repository, 14.1
- 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 Manager, 2.1.4.4
- 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
- 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.6
- 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
- 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 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
- 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.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, 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.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, 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
- 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
- Tools menu, about, 2.1.4.5
- 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, 2.1.4.1, 16.1.1
U
- UDA column type, 7.4.1
- UDAs
-
- 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
- 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.4.7
- Update All Row Counts menu option, 2.1.4.5
- Update Physical Layer Wizard, using, 17.2.5
- upgrade
-
- considerations, 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 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
- 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
- NQClient, 14.2.2
- nqcmd, 14.2.1
- 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
- Utilities menu option, 2.1.4.5
V
- Value measure, for Hyperion Financial Management data sources, 7.5
- 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.7
- 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
- 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.5
- 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