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