Glossary

A hierarchy of shared members. An alternate hierarchy is based upon an existing hierarchy in a database outline, but has alternate levels in the dimension. An alternate hierarchy allows the same data to be seen from different points of view.

A branch member that has members below it. For example, the members Qtr2 and 2006 are ancestors of the member April.

1) A software program designed to run a specific task or group of tasks such as a spreadsheet program or database management system. 2) A related set of dimensions and dimension members that are used to meet a specific set of analytical requirements, reporting requirements, or both.

A person responsible for setting up, configuring, maintaining, and controlling an application. Has all application privileges and data access permissions.

An individual application or repository item; for example, scripts, forms, rules files, Interactive Reporting documents, and financial reports. Also known as an object.

A characteristic of a dimension member. For example, Employee dimension members may have attributes of Name, Age, or Address. Product dimension members can have several attributes, such as a size and flavor.

Verification of identity as a security measure. Authentication is typically based on a user name and password. Passwords and digital signatures are forms of authentication.

1) In Financial Reporting, a container that holds a group of similar documents. Books may specify dimension sections or dimension changes. 2) In Data Relationship Management, a collection of exports that can be run together as a group. Export results can be combined together or output separately.

Logical expressions or formulas that are created within an application to produce a desired set of resulting values.

Groupings by which data is organized. For example, Month.

A member with a parent above it in the database outline.

In Data Relationship Management, a field of data associated with an import source or the results of a query, compare, validation, or export.

Information stored in the repository for any type of file.

A property of a dimension or dimension member that is created by a user.

A representation of a subset of database tables.

A file that stores definitions and properties used to connect to data sources and enables database references to be portable and widely used.

Any member below a parent in the database outline. In a dimension that includes years, quarters, and months, the members Qtr2 and April are descendants of the member Year.

Navigation through the query result set using the dimensional hierarchy. Drilling down moves the user perspective from aggregated data to detail. For example, drilling down can reveal hierarchical relationships between years and quarters or quarters and months.

A method for mapping bit combinations to characters for creating, storing, and displaying text. Each encoding has a name; for example, UTF-8. Within an encoding, each character maps to a specific bit combination; for example, in UTF-8, uppercase A maps to HEX41. See also code page, locale.

Logging on to Oracle EPM System products with user information stored outside the application. The user account is maintained by the EPM System, but password administration and user authentication are performed by an external service, using a corporate directory such as Oracle Internet Directory (OID) or Microsoft Active Directory (MSAD).

A character, such as a comma or tab, that separates fields in a data source.

A constraint on data sets that restricts values to specific criteria; for example, to exclude certain tables, metadata, or values, or to control access.

1) In Essbase, a method for transforming the way cell values are displayed. 2) In Data Relationship Management, a parameter of a Format or Formatted Date derived property that indicates the format in which a property value should be returned.

In Data Relationship Management, business logic used by a derived property to dynamically calculate a property value.

In Data Relationship Management, a syntactic element of a derived property formula that accepts parameters and returns dynamic values.

A layer in a hierarchical tree structure that defines member relationships in a database. Generations are ordered incrementally from the top member of the dimension (generation 1) down to the child members. Use the unique generation name to identify a layer in the hierarchical tree structure.

A container for assigning similar access permissions to multiple users.

A unique identification for a user or group in external authentication.

Documents with special properties that can be launched to generate output. A job can contain Interactive Reporting, SQR Production Reporting, or generic documents.

The process of migrating an application, a repository, or individual artifacts across product environments.

The process of copying applications, artifacts, or users from one environment or computer to another; for example, from a testing environment to a production environment.

A log file that captures all application migration actions and messages.

The process of authenticating a user name and password from within the server or application.

A value that is absent of data. Null values are not equal to zero.

The entities that contain dependent entities that report directly to them. Because parents are entities associated with at least one node, they have entity, node, and parent information associated with them.

A level of access granted to users and groups for managing data or other users and groups.

Number of decimal places displayed in numbers.

The process of granting users and groups specific access permissions to resources.

In a database, a group of fields making up one complete entry. For example, a customer record may contain fields for name, address, telephone number, and sales data.

Storage location for metadata, formatting, and annotation information for views and queries.

Objects or services managed by the system, such as roles, users, groups, files, and jobs.

The means by which access permissions are granted to users and groups for resources.

A framework enabling Oracle EPM System products to use external authentication and single sign-on.

Resources that enable business items to be retrieved, changed, added, or deleted. Examples: Authorization and Authentication.

The part of the Shared Services repository that manages EPM System deployment information for most EPM System products, including installation directories, database settings, computer names, ports, servers, URLs, and dependent service data.

A child member at the same generation as another child member and having the same immediate parent. For example, the members Florida and New York are children of East and each other's siblings.