Glossary

A property that determines how an account's value flows over time and its sign behavior. Account type options can include expense, income, asset, liability, and equity.

Defines user access to applications and the types of activities they can perform on applications, independent of the data that will be operated on.

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.

The default reporting currency for the application.

An account type that stores values that represent a company's assets.

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.

A journal for entering adjustments that you want to reverse in the next period.

An account type that stores unsigned values that relate to a particular time.

A journal in which the total debits equal the total credits.

The currency in which daily business transactions are performed.

An entity at the bottom of the organization structure that does not own other entities.

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

User-defined time periods and their relationship to each other. Q1, Q2, Q3, and Q4 comprise a calendar or fiscal year.

(1) The data value at the intersection of dimensions in a multidimensional database; the intersection of a row and a column in a worksheet. (2) A logical group of nodes belonging to one administrative domain.

Consolidation status that indicates data for an entity has changed.

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

The process of aggregating data from dependent entities to parent entities. For example, if the dimension Year consists of the members Qtr1, Qtr2, Qtr3, and Qtr4, its consolidation is Year.

The rule that is executed during the consolidation of the node of the hierarchy. This rule can contain customer-specific formulas appropriate for the correct consolidation of parent balances. Elimination processing can be controlled within these rules.

The value added to a parent from a child entity. Each child has a contribution to its parent.

See exchange rate.

A process that converts currency values in a database from one currency into another. For example, to convert one U. S. dollar into the European euro, the exchange rate (for example, 0.923702) is multiplied by the dollar (1* 0.923702). After conversion, the European euro amount is .92.

A dimension created and defined by users. Channel, product, department, project, or region could be custom dimensions.

A grid display that enables users to enter data into the database from an interface such as a Web browser, and to view and analyze data or related text. Certain dimension member values are fixed, giving users a specific view into the data.

A feature that prevents changes to data according to specified criteria, such as a period or scenario.

An entity that is owned by another entity in the organization.

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.

The currency to which balances are converted. You enter exchange rates and convert from the source currency to the destination currency. For example, when you convert from EUR to USD, the destination currency is USD.

A data category used to organize business data for the retrieval and preservation of values. Dimensions usually contain hierarchies of related members grouped within them. For example, a Year dimension often includes members for each time period, such as quarters and months.

A currency rate that you enter in the exchange-rate table. The direct rate is used for currency conversion. For example, to convert balances from JPY to USD, in the exchange-rate table, enter a rate for the period/scenario where the source currency is JPY and the destination currency is USD.

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 system-created named member set that is based on user-defined criteria. The list is refreshed automatically whenever it is referenced in the application. As dimension members are added and deleted, the list automatically reapplies the criteria to reflect the changes.

An account type indicating that account values are calculated dynamically from the data that is displayed.

The process of zeroing out (eliminating) transactions between entities within an organization.

A dimension representing organizational units. Examples: divisions, subsidiaries, plants, regions, products, or other financial reporting units.

An identifier for an exchange rate. Different rate types are used because there may be multiple rates for a period and year. Users traditionally define rates at period end for the average rate of the period and for the end of the period. Additional rate types are historical rates, budget rates, forecast rates, and so on. A rate type applies to a specific time.

An account that stores periodic and year-to-date values that decrease net worth if they are positive.

A language comprising a set of tags used to assign attributes to data that can be interpreted between applications according to a schema.

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.

An unsigned account that stores periodic and year-to-date 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.

An entity that is part of a legal entity group, with direct or indirect investments in all entities in the group.

A status that indicates changes in child entities consolidating into parent entities.

A status that indicates entities deactivated from consolidation for the current period.

See elimination.

The process of comparing balances for pairs of intercompany accounts within an application. Intercompany receivables are compared to intercompany payables for matches. Matching accounts are used to eliminate intercompany transactions from an organization's consolidated totals.

A report that compares intercompany account balances and indicates whether the accounts are in balance.

A set of debit-credit adjustments to account balances for a scenario and period.

An account type that stores "point in time" balances of a company's liabilities. Examples: accrued expenses, accounts payable, and long-term debt.

A user-invoked process that prevents users and processes from modifying data.

A consolidation status indicating that an entity contains data that cannot be modified.

A named system- or user-defined group that references members, functions, or member lists within a dimension.

A data load option that clears values only from the accounts specified in the data load file and replaces them with values in the data load file.

A set of data that defines and describes the properties and attributes of the data stored in a database or used by an application. Examples of metadata are dimension names, member names, properties, time periods, and security.

A consolidation status indicating that this entity contains no data for the specified period and account.

Open Database Connectivity. A database access method used from any application regardless of how the database management system (DBMS) processes the information.

A consolidation status indicating that an entity has already been consolidated, and that data has not changed below it in the organization structure.

Standardized application programming interface (API) technology that allows applications to access multiple third-party databases.

An entity hierarchy that defines each entity and their relationship to others in the hierarchy.

Profit and loss accounts. P&L refers to a typical grouping of expense and income accounts that comprise a company's income statement.

The journal entries that are posted to a child in relation to its parent.

The entities that contain one or more 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.

The portion of a child's values that is consolidated to its parent.

The extent to which an entity is controlled within the context of its group.

The extent to which an entity is owned by its parent.

A process of currency conversion that applies the periodic exchange rate values over time to derive converted results.

An account in which the system stores any out-of-balance differences between intercompany account pairs during the elimination process.

See periodic value method.

A journal template for making identical adjustments in every period.

A feature for entering one-time adjustments for a period. A regular journal can be balanced, balanced by entity, or unbalanced.

A type of database that stores data in related two-dimensional tables. Contrast with multidimensional database.

A data load option that clears existing values from all accounts for periods specified in the data load file and loads values from the data load file. If an account is not specified in the load file, its values for the specified periods are cleared.

A Process Management review status indicator representing the process unit level, such as Not Started, First Pass, Submitted, Approved, and Published.

A dimension for classifying data; for example, Actuals, Budget, Forecast1, or Forecast2.

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.

The currency from which values originate and are converted through exchange rates to the destination currency.

A journal function used to post adjustments that have common adjustment information for each period. For example, you can create a standard template that contains the common account IDs, entity IDs, or amounts, and then use the template as the basis for many regular journals.

A feature that transfers data from application metadata into an ASCII file.

See currency conversion.

A means of converting balances from one currency to another through a third common currency. In Europe, this currency is the euro for member countries. For example, to convert from the French franc to the Italian lira, the common currency is defined as the European euro. Therefore, to convert balances from the French franc to the Italian lira, balances are converted from the French franc to the European euro and from the European euro to Italian lira.

A named, static set of members within a dimension defined by the user.

A dimension that is used to define input value, translated value, and consolidation detail.

A year-to-date or periodic display of data.

See Extensible Markup Language.