The central table in a star join schema,
characterized by a foreign key and elements drawn from a
dimension table. This table typically contains numeric data
that can be related to all other tables in the schema.
The ability to switch automatically to a redundant
standby database, server, or network if the primary
database, server, or network fails or is shut down. A system
that is clustered for failover provides high availability and
fault tolerance through server redundancy and fault-
tolerant hardware, such as shared disks.
A gadget that contains links to Reporting
and Analysis documents and URLs. See also gadget.
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.
An unsigned account that stores periodic and
Text or images at the bottom of report pages,
containing dynamic functions or static text such as page
numbers, dates, logos, titles or file names, and author
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
An area on the desktop. Two main areas: the
navigation and workspace frames.
An object for presenting, entering, and
integrating data from different sources for dynamic
Creating reports by entering dimension
members or report script commands in worksheets.
In Data Relationship Management, a syntactic
element of a derived property formula that accepts
parameters and returns dynamic values.
A simple, specialized, lightweight application that
provides easy viewing of EPM content and enables access to
core Reporting and Analysis functionality.
Additional data that is optionally generated
after allocation calculations. This data enables reporting on
all cost or revenue flows from start to finish through all
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.
Non-SQR Production Reporting or non-
Interactive Reporting jobs.
global report command
A command in a running report script
that is effective until it is replaced by another global
command or the file ends.
A means for specifying dimension members on a
grid without placing dimensions in rows, columns, or page
intersections. A report designer can set POV values at the
grid level, preventing user POVs from affecting the grid. If
a dimension has one grid value, you put the dimension into
the grid POV instead of the row, column, or page.
A container for assigning similar access permissions
to multiple users.
Graphical user interface
a collection of computers that provides a
single view of network services (for example, an IP address)
or application services (such as databases and web servers)
to clients of these services. Each node in a hardware cluster
is a standalone server that runs its own processes. These
processes can communicate with one another to form what
looks like a single system that cooperatively provides
applications, system resources, and data to users.
A system attribute that enables an
application to continue to provide services in the presence
of failures. This is achieved through removal of single points
of failure, with fault-tolerant hardware, as well as server
clusters; if one server fails, processing requests are routed to
An average for an account over a number
of historical periods.
An entity that is part of a legal entity group,
with direct or indirect investments in all entities in the
horizontal application server cluster
A cluster with application
server instances on different machines.
A server on which applications and services are
Properties pertaining to a host, or if the host
has multiple Oracle EPM homes, to an Oracle EPM home.
An analysis mapping low-level data stored in
a relational database to summary-level data stored in
Essbase, combining the mass scalability of relational systems
with multidimensional data.
A link to a file, a web page, or an intranet HTML
Hypertext Markup Language (HTML)
A programming language
specifying how web browsers display data.
A unique identification for a user or group in
Graphic links to web pages or repository
A status that indicates changes in child
entities consolidating into parent entities.
A member with one or more children but only
one that is consolidated, so the parent and child share a
In FDM, the definition of the structure of the
source file that enables the loading of a source data file to
an FDM data-load location.
A group for which an administrator has
deactivated system access.
A status that indicates entities deactivated
from consolidation for the current period.
A user whose account was deactivated by an
An account storing periodic and year-to-
date values that, if positive, increase net worth.
1) A method where Essbase uses sparse-data
combinations to retrieve data in block storage databases. 2)
The index file.
A buffer containing index pages.
A pointer to an intersection of sparse dimensions.
Index entries point to data blocks on disk and use offsets to
An Essbase file storing block storage data retrieval
information, residing on disk, and containing index pages.
A subdivision in an index file. An index page
contains pointers to data blocks.
Data loaded from a source rather than calculated.
Product installation files that plug in
to EPM System Installer.
A process that is run to move data between
Oracle's Hyperion applications using Shared Services. Data
integration definitions specify the data moving between a
source application and a destination application, and they
enable the data movements to be grouped, ordered, and
A calculation method tracking updated
data blocks since the last calculation.
Interactive Reporting connection file (.oce)
database connection information, including the database
API (ODBC, SQL*Net, and so on), database software, the
database server network address, and database user name.
Administrators create and publish Interactive Reporting
connection (.oce) files.
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.
intercompany matching report
A report that compares
intercompany account balances and indicates whether the
accounts are in balance.
A situation in which a dimension
does not intersect with other dimensions. Because the data
in the dimension cannot be accessed from the
nonintersecting dimensions, the nonintersecting
dimensions are not relevant to that dimension.
A unit of data representing the intersection of
dimensions in a multidimensional database; also, a
An assignment in the financial flow to
an object within the same stage.
A deep inspection of a data source to discover
hierarchies based on the inherent relationships in the
database. Contrast with scraping.
An Essbase Kernel setting that determines the
lock and commit behavior of database operations. Choices
are: committed access and uncommitted access.
A pass of the budget or planning cycle in which the
same version of data is revised and promoted.
Java application server cluster
An active-active application
server cluster of Java Virtual Machines (JVMs).
Java Database Connectivity (JDBC)
communication protocol used by Java-based clients and
relational databases. The JDBC interface provides a call-
level API for SQL-based database access.
Files or reports produced from running a job.
Documents with special properties that can be
launched to generate output. A job can contain Interactive
Reporting, SQR Production Reporting, or generic
A link between two relational database tables or topics
based on common content in a column or row. A join
typically occurs between identical or similar items within
different tables or topics. For example, a record in the
Customer table is joined to a record in the Orders table
because the Customer ID value is the same in each table.
journal entry (JE)
A set of debit-credit adjustments to account
balances for a scenario and period.
Java Server Page.
A gadget that contains a group of Smart
Space users and provides access to Smart Space
Collaborator. For example, you can have a KeyContacts
gadget for your marketing team and another for your
development team. See also gadget.
A spreadsheet keyword used to extract data values
from the member defined as the latest time period.
1) The horizontal location of members in a
hierarchical structure, specified by generation (top down)
or level (bottom up); 2) Position of objects relative to other
objects. For example, in the Sample Basic database, Qtr1 and
Qtr4 are in the same layer, so they are also in the same
generation, but in a database with a ragged hierarchy, Qtr1
and Qtr4 might not be in same layer, though they are in the
An area on a Workspace Page where content can
A box containing labels that identify the data
categories of a dimension.
A layer in a hierarchical tree structure that defines
database member relationships. Levels are ordered from the
bottom dimension member (level 0) up to the parent
level 0 block
A data block for combinations of sparse, level 0
level 0 member
A member that has no children.
An account type that stores "point in time"
balances of a company's liabilities. Examples: accrued
expenses, accounts payable, and long-term debt.
The process of migrating an
application, a repository, or individual artifacts across
line item detail
The lowest level of detail in an account.
The relationship between different metadata
elements showing how one metadata element is derived
from one or more other metadata elements, ultimately
tracing the metadata element to its physical source. In
Essbase Studio, a lineage viewer displays the relationships
graphically. See also traceability.
1) A reference to a repository object. Links can reference
folders, files, shortcuts, and other links; 2) In a taskflow, the
point where the activity in one stage ends and another
A logical expression evaluated by the taskflow
engine to determine the sequence of launching taskflow
linked data model
Documents that are linked to a master copy
in a repository
A shared partition that enables you to use a
data cell to link two databases. When a user clicks a linked
cell in a worksheet, Essbase opens a new sheet displaying the
dimensions in the linked database. The user can then drill
down those dimensions.
linked reporting object (LRO)
A cell-based link to an external
file such as cell notes, URLs, or files with text, audio, video,
or pictures. (Only cell notes are supported for Essbase LROs
in Financial Reporting.) Contrast with local report object.
Hardware or software that directs the requests
to individual application servers in a cluster and is the only
point of entry into the system.
Distribution of requests across a group of
servers, which helps to ensure optimal end user
An input currency type. When an input
currency type is not specified, the local currency matches
the entity's base currency.
local report object
A report object that is not linked to a
Financial Reporting report object in Explorer. Contrast with
linked reporting object.
A data model's query results. Results can be used
in local joins by dragging them into the data model. Local
results are displayed in the catalog when requested.
A computer setting that specifies a location's
language, currency and date formatting, data sort order, and
the character set encoding used on the computer. Essbase
uses only the encoding portion. See also encoding,
locale header record
A text record at the beginning of some
non-Unicode-encoded text files, such as scripts, that
identifies the encoding locale.
A descriptor that identifies a data source. The
location alias specifies a server, application, database, user
name, and password. Location aliases are set by DBAs at the
database level using Administration Services Console,
ESSCMD, or the API.
A user-invoked process that prevents users and
processes from modifying data.
locked data model
A data model that cannot be modified by
A consolidation status indicating that an
entity contains data that cannot be modified.
An Administration Services feature that enables
filtering, searching, and analysis of Essbase logs.
In FDM, one or more logic accounts generated
after a source file is loaded into FDM. Logic accounts are
calculated accounts derived from the source data.
logical web application
An aliased reference used to identify
the internal host name, port, and context of a web
application. In a clustered or high-availability environment,
this is the alias name that establishes a single internal
reference for the distributed components. In EPM System,
a nonclustered logical web application defaults to the
physical host running the web application.
See linked reporting object.
An application server process running in its
own Java Virtual Machine (JVM).
A stage that requires human intervention.
A file that stores the definition for sending data to
or retrieving data from an external database. Map files have
different extensions (.mps to send data; .mpr to retrieve
A feature that displays your current position
on a Strategy, Accountability, or Cause and Effect map,
indicated by a red outline.
Marginal Tax Rate
The rate used to calculate the after-tax cost
of debt; represents the tax rate applied to the last earned
income dollar (the rate from the highest tax bracket into
which income falls) and includes federal, state, and local
taxes. Based on current level of taxable income and tax
bracket, you can predict marginal tax rate.
Market Risk Premium
The additional rate of return paid over
the risk-free rate to persuade investors to hold "riskier"
investments than government securities. Calculated by
subtracting the risk-free rate from the expected market
return. These figures should closely model future market
master data model
An independent data model that is
referenced as a source by multiple queries. When used,
"Locked Data Model" is displayed in the Query section's
Content pane; the data model is linked to the master data
model displayed in the Data Model section, which an
administrator may hide.
A symbol that defines how data is
calculated in formulas and outlines. Can be any of the
standard mathematical or Boolean operators; for example,
+, -, *, /, and %.
The multidimensional database access language for
Essbase, consisting of a data definition language (MaxL
DDL) and a data manipulation language (MaxL DML). See
also MaxL DDL, MaxL DML, and MaxL Shell
The data definition language used by Essbase for
batch or interactive system-administration tasks.
The data manipulation language used in Essbase
for data query and extraction.
MaxL Perl Module
A Perl module (essbase.pm) that is part of
Essbase MaxL DDL. This module can be added to the Perl
package to provide access to Essbase databases from Perl
MaxL Script Editor
A script-development environment in
Administration Services Console. MaxL Script Editor is an
alternative to using a text editor and the MaxL Shell for
administering Essbase with MaxL scripts.
An interface for passing MaxL statements to
Essbase Server. The MaxL Shell executable file is located in
the Essbase bin directory (UNIX: essmsh; Windows:
MDX (multidimensional expression)
A language used for
querying and calculation in multidimensional-compliant
Numeric values in an OLAP database cube that are
available for analysis. Measures are margin, cost of goods
sold, unit sales, budget amount, and so on. See also fact
A discrete component within a dimension. A
member identifies and differentiates the organization of
similar units. For example, a time dimension might include
members Jan, Feb, and Qtr1.
A named system- or user-defined group that
references members, functions, or member lists within a
In Essbase Integration Services, the process of
adding dimensions and members (without data) to Essbase
member selection report command
A type of Report Writer
command that selects member ranges based on outline
relationships, such as sibling, generation, and level.
member-specific report command
A type of Report Writer
formatting command that is executed as it is encountered
in a report script. The command affects only its associated
member and executes the format command before
processing the member.
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.
Metadata derived from data sources and
other metadata that is stored and cataloged for Essbase
The process of retrieving a sample of
members in a dimension in a drill-down operation.
Security set at the member level to restrict
users from accessing certain outline members.
In Essbase Integration Services, a template
containing the structure and rules for creating an Essbase
outline from an OLAP model.
A directory that includes the Oracle
WebLogic Server home and can also include the EPM Oracle
home and other Oracle homes. A Middleware home can
reside on a local file system or on a remote shared disk that
is accessible through NFS.
migration audit report
A report generated from the migration
log that provides tracking information for an application
migration definition file (.mdf)
A file that contains migration
parameters for an application migration, enabling batch
A log file that captures all application migration
actions and messages.
A snapshot of an application migration
that is captured in the migration log.
An attribute that describes the data format of an
item, so that the system knows which application should
open the object. A file's MIME (Multipurpose Internet Mail
Extension) type is determined by the file extension or HTTP
header. Plug-ins tell browsers which MIME types they
support and which file extensions correspond to each
In data mining, a class of values used as a
factor in analysis of a set of data.
A report component that includes layout,
content, hyperlinks, and the query or queries to load the
report. Each report can include one or more minireports.
A graphical representation of a subset of tables
from a data source that represents a data modeling context.
missing data (#MISSING)
A marker indicating that data in the
labeled location does not exist, contains no value, or was
never entered or loaded. For example, missing data exists
when an account contains data for a previous or future
period but not for the current period.
1) In data mining, a collection of an algorithm's
findings about examined data. A model can be applied
against a wider data set to generate useful information about
that data; 2) A file or content string containing an
application-specific representation of data. Models are the
basic data managed by Shared Services, of two major types:
dimensional and nondimensional application objects; 3) In
Business Modeling, a network of boxes connected to
represent and calculate the operational and financial flow
through the area being examined.
A method of organizing, storing,
and referencing data through three or more dimensions. An
individual value is the intersection point for a set of
dimensions. Contrast with relational database.
An FDM feature that allows the simultaneous
loading of multiple periods, categories, and locations.
My Workspace Page
Customizable Workspace Pages created
by users. They are marked specially so that they can be easily
accessed from one single place without having to navigate
In MaxL DML, a set with its logic defined in the
optional WITH section of a MaxL DML query. The named
set can be referenced multiple times in the query.
The process of authenticating a user
name and password from within the server or application.
nested column headings
A report column heading format that
displays data from multiple dimensions. For example, a
column heading that contains Year and Scenario members
is a nested column. The nested column heading shows Q1
(from the Year dimension) in the top line of the heading,
qualified by Actual and Budget (from the Scenario
dimension) in the bottom line of the heading.
NO DATA status
A consolidation status indicating that this
entity contains no data for the specified period and account.
A Shared Services model type that
includes application objects such as security files, member
lists, calculation scripts, and web forms.
non-unique member name
See duplicate member name.
A value that is absent of data. Null values are not
equal to zero.
numeric attribute range
A feature used to associate a base
dimension member that has a discrete numeric value with
an attribute that represents a value range. For example, to
classify customers by age, an Age Group attribute dimension
can contain members for the following age ranges: 0-20,
21-40, 41-60, and 61-80. Each Customer dimension
member can be associated with an Age Group range. Data
can be retrieved based on the age ranges rather than on
individual age values.
Open Database Connectivity. A database access
method used from any application regardless of how the
database management system (DBMS) processes the
A consolidation status indicating that an entity has
already been consolidated, and that data has not changed
below it in the organization structure.
OLAP Metadata Catalog
In Essbase Integration Services, a
relational database containing metadata describing the
nature, source, location, and type of data that is pulled from
the relational data source.
In Essbase Integration Services, a logical model
(star schema) that is created from tables and columns in a
relational database. The OLAP model is then used to
generate the structure of a multidimensional database. See
also online analytical processing (OLAP).
online analytical processing (OLAP)
multiuser, client-server computing environment for users
who analyze consolidated enterprise data in real time. OLAP
systems feature drill-down, data pivoting, complex
calculations, trend analysis, and modeling.
Open Database Connectivity (ODBC)
programming interface (API) technology that allows
applications to access multiple third-party databases.
A directory containing the installed files
required by a specific product, and residing within the
directory structure of Middleware home. See also
An entity hierarchy that defines each entity and
their relationship to others in the hierarchy.
The intersection of two axes.
The database structure of a multidimensional
database, including all dimensions, members, tags, types,
consolidations, and mathematical relationships. Data is
stored in the database according to the structure defined in
For partitioned databases, the process
of propagating outline changes from one database to
A display of information in a grid or table often
represented by the Z-axis. A page can contain data from one
field, derived data from a calculation, or text.
An Essbase data file.
A report heading type that lists members
represented on the current page of the report. All data values
on the page have the members in the page heading as a
A member that determines the page axis.
A JASC-compliant file with a .PAL extension. Each
palette contains 16 colors that complement each other and
can be used to set the dashboard color elements.
A calculation option. Essbase divides a
calculation into tasks and calculates some tasks
parallel data load
In Essbase, the concurrent execution of
data load stages by multiple process threads.
The ability to export Essbase data to multiple
files. This may be faster than exporting to a single file, and
it may resolve problems caused by a single data file
becoming too large for the operating system to handle.
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.
Documents you may be interested
Documents you may be interested