Subqueries that are evaluated once for
every row in the parent query; created by joining a topic item
in the subquery with a topic in the parent query.
critical business area (CBA)
An individual or a group
organized into a division, region, plant, cost center, profit
center, project team, or process; also called accountability
team or business area.
critical success factor (CSF)
A capability that must be
established and sustained to achieve a strategic objective;
owned by a strategic objective or a critical process and is a
parent to one or more actions.
Reporting that categorizes and
summarizes data in table format. The table cells contain
summaries of the data that fit within the intersecting
categories. For example, a crosstab report of product sales
information could show size attributes, such as Small and
Large, as column headings and color attributes, such as Blue
and Yellow, as row headings. The cell in the table where
Large and Blue intersect could contain the total sales of all
Blue products that are sized Large.
A block of data that contains three or more
dimensions. An Essbase database is a cube.
In Essbase Studio, the process of setting load
options for a model to build an outline and load data into
an Essbase application and database.
In Essbase Studio, the metadata elements, such
as measures and hierarchies, representing the logical model
of a cube.
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 feature allowing the selected input
method for any input period to be overridden to enable
input of that period's value as Default Currency/Items. To
override the input method, enter a pound sign (#) before or
after the number.
A dimension type that separates local
currency members from a base currency, as defined in an
application. Identifies currency types, such as Actual,
Budget, and Forecast.
Any calendar created by an administrator.
A dimension created and defined by users.
Channel, product, department, project, or region could be
A property of a dimension or dimension
member that is created by a user.
A complex report from the Design Report
module, composed of any combination of components.
custom-defined function (CDF)
Essbase calculation functions
developed in Java and added to the standard Essbase
calculation scripting language using MaxL. See also custom-
custom-defined macro (CDM)
Essbase macros written with
Essbase calculator functions and special macro functions.
Custom-defined macros use an internal Essbase macro
language that enables the combination of calculation
functions and they operate on multiple input parameters.
See also custom-defined function.
Perform multiple passes through a database
while calculating it.
A collection of metrics and indicators that
provide an interactive summary of your business.
Dashboards enable you to build and deploy analytic
A buffer in memory that holds uncompressed
data file cache
A buffer in memory that holds compressed
data (PAG) files.
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
Function that computes aggregate values,
including averages, maximums, counts, and other statistics
that summarize groupings of data.
data load location
In FDM, a reporting unit responsible for
submitting source data into the target system. Typically, one
FDM data load location exists for each source file loaded to
the target system.