A dimension type that makes accounting intelligence available. You can tag only one dimension as Accounts; you do not have to have an accounts dimension.
An individual who installs and maintains the Essbase system, including setting up user accounts and security. See also database administrator (DBA) and system administrator.
An option in Essbase Spreadsheet Add-in that you use to define a layout through drill through or Essbase Query Designer or by typing data into the sheet. When you construct a free-form report in Advanced Interpretation mode, Essbase interprets the member names and creates a default view that is based on the location of the labels.
A process on the server that starts and stops applications and databases, manages connections from users, and handles user-access security. The agent is referred to as ESSBASE.EXE.
See consolidate.
An alternative name for a dimension, member, or description.
A database table that stores aliases for the dimensions or members.
A branch member that has members below it. For example, in a dimension that includes years, quarters, and months, the members Qtr2 and 2001 are ancestors of the member April.
A management structure containing one or more Essbase databases and the related files that control many system variables, such as memory allocation and autoload parameters.
An individual who designs, creates, and maintains Essbase applications and databases.
A record of user actions performed on an application.
Essbase software that you use to create and maintain Essbase applications.
Application Programming Interface (API)
A library of functions that you can use in a custom program. Provides programmatic access to an application's data or services. Hyperion Application Builder provides a Java API that you can use to develop client programs.
A predefined set of members and values that makes up a partition.
A data load that performs operations on values in the database, such as adding 10 to each value.
A report characterized by groups of members that differ by at least one member across the groups. There can be a difference in the number of members or the names of members under each heading in the report. For example, a report based on Sample Basic can have three members grouped under "East" and two members grouped under "West."
A classification of a member in a dimension. You can select and group members based on their associated attributes. You can also specify an attribute when you perform calculations and use calculation functions. For example, a Product dimension can have several attributes, such as Size and Flavor. A specific member of the Product dimension can have the Size attribute, 8, and the Flavor attribute, Cola.
A relationship in a database outline whereby a member in an attribute dimension describes a characteristic of a member of its base dimension. For example, if product 100-10 has a grape flavor, the product 100-10 has the Flavor attribute association of grape. Thus, the 100-10 member of the Product dimension is associated with the Grape member of the Flavor attribute dimension.
Attribute Calculations dimension
A system-defined dimension that performs the following calculation operations on groups of members: Sum, Count, Avg, Min, and Max. The calculation is based on the attributes associated with the members. This dimension is calculated dynamically and is not visible in the database outline. For example, by using the Avg member, you can calculate the average sales value for Red products in New York in January.
A type of dimension that enables analysis based on the attributes or qualities of the members of its base dimension.
A process of defining reports that is based on the attributes of the base members in the database outline.
A text, numeric, Boolean, or date type that enables different functions for grouping, selecting, or calculating data. Although assigned at the dimension level, the attribute type applies only to level 0 members of the attribute dimension. For example, because the Ounces attribute dimension has the type numeric, you can use the number of ounces that is specified as the attribute of each product to calculate the profit per ounce for that product.
A character that terminates a series of report commands and requests information from the database. A report script must be terminated with a bang character; several bang characters may be used within a report script.
The currency in which daily business transactions are performed.
A standard dimension that is associated with one or more attribute dimensions. To classify a member of a base dimension, you associate it with a member of one or more attribute dimensions that describes the classification, such as a specific flavor. For example, assuming products have flavors, the Product dimension is the base dimension for the Flavors attribute dimension.
Any calculation on a database that is done in batch; for example, a calculation script or a full database calculation. Dynamic calculations are not considered to be batch calculations.
An operating system file that can call multiple ESSCMD scripts and run multiple sessions of ESSCMD. Batch files handle batch data loads and complex calculations and can include commands that run report scripts. You can run a batch file on the server from the operating system prompt. On Windows-based systems, batch files have .BAT file extensions. On UNIX, a batch file is written as a shell script.
A method of using ESSCMD to write a batch or script file that can be used to automate routine server maintenance and diagnostic tasks. ESSCMD script files can execute multiple commands and can be run from the operating system command line or from within operating system batch files. Batch files can be used to call multiple ESSCMD scripts or run multiple instances of ESSCMD.
The primary storage unit within Essbase. A block is a multidimensional array representing the cells of all dense dimensions.
A method used to modify database outlines. You choose a build method based on the format of data in data source files.
A buffer in memory that holds data temporarily.
An Essbase database setting that, when enabled, locks the memory used for the index cache, data file cache, and data cache into physical memory, potentially improving database performance. This setting is disabled by default.
The process of aggregating or of running a calculation script on a database.
A set of commands that define how a database is consolidated or aggregated. A calculation script may also contain commands that specify allocation and other calculation rules separate from the consolidation process.
The process of creating multiple reports for a subset of member values.
A unit of data representing the intersection of dimensions in a multidimensional database; the intersection of a row and a column in a worksheet.
A text annotation of up to 599 characters for a cell in an Essbase database. Cell notes are a type of linked reporting object.
See outline change log.
A member that has a parent above it in the database outline.
A data block is marked as clean if the database is fully calculated, if a calculation script calculates all dimensions at once, or if the SET CLEARUPDATESTATUS command is used in a calculation script.
A client interface, such as the Essbase Spreadsheet Add-in software, a custom API program, or Essbase Application Manager. A client is also a workstation that is connected to a server through a local area network.
A record of all messages, actions, and errors that are generated by a client.
A vertical display of information in a grid or table. A column can contain data from a single field, derived data from a calculation, or textual information. The terms column and field are sometimes used interchangeably. Contrast with row.
A part of a report that lists members across a page. When you define columns that report on data from more than one dimension, you produce nested column headings. A member that is listed in a column heading is an attribute of all data values in its column.
A Essbase Kernel Isolation Level setting that affects how Essbase handles transactions. Under committed access, concurrent transactions hold long-term write locks and yield predictable results.
The process of gathering data from dependent entities and aggregating the data up to parent entities. After you enter or load data into dependent child entities, you perform a consolidation to aggregate the data through the organization. As data consolidates, intercompany processing, conversion methods, equity adjustments, and minority ownerships perform calculations on the data. For example, if the dimension Year consists of the members Qtr1, Qtr2, Qtr3, and Qtr4, its consolidation is Year. The terms aggregate and roll-up also describe the consolidation process.
A type of reporting that categorizes and summarizes data in a table format. The cells within the table 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.
The monetary unit of measure associated with a balance or transaction.
A process that converts currency values in a database from one currency into another currency. For example, to convert one US dollar into the euro, the exchange rate of 0.923702 is multiplied with the dollar (1* 0.923702). After conversion, the euro amount is .92.
A dimension type that separates local currency members for a base currency, as defined in an application. A currency partition identifies currency types, such as Actual, Budget, and Forecast.
A character that represents a currency. For example, the currency symbol for the US dollar is $ and the currency symbol for the British pound is £.
Essbase calculation functions that you develop in the Java programming language and add to the standard Essbase calculation scripting language by means of MaxL. See also custom-defined macro (CDM).
Essbase macros that you write with Essbase calculator functions and special macro functions. Custom-defined macros use an internal Essbase macro language that enables you to combine calculation functions and operate on multiple input parameters. See also custom-defined function (CDF).
See block.
A buffer in memory that holds uncompressed data blocks.
See cell.
A file containing data blocks; Essbase generates the data file during a data load and stores it on disk.
A buffer in memory that holds compressed data (.PAG) files.
The process of populating an Essbase database with data. Loading data establishes actual values for the cells defined by the structural outline of the database.
See cell.
A repository of data within Essbase that contains a multidimensional data storage array. Each database consists of a storage structure definition (a database outline), data, security definitions, and optional calculation scripts, report scripts, and data loading scripts. An application contains one or more databases.
An individual who administers database servers, such as Essbase, and who may also design, maintain, and create databases.
In Essbase, the highest type of access that can be assigned globally (per database). This type of access allows complete calculate and update access and the ability to run report and calculation scripts.
A layer in the Essbase security plan that defines specific settings for database members down to the cell level.
A dimension with a high probability that data exists for every combination of dimension members.
Any member below a parent in the database outline. For example, in a dimension that includes years, quarters, and months, the members Qtr2 and April are descendants of the member Year.
A data category that is used to organize business data for retrieval and preservation of values. Each dimension usually contains a hierarchy of related members grouped within it. For example, a Year dimension often includes members for each time period, such as quarters and months. Other common business dimensions may be measures, natural accounts, products, and markets.
Specifications, similar to data load rules, that Essbase uses to modify an outline. The modification is based on data in an external data source file.
A dimension property that enables the use of predefined functionality. Dimensions that are tagged as Time have a predefined calendar functionality.
A data block containing cells that have been changed since the last calculation. Upper level blocks are marked as dirty if their child blocks are dirty (that is, have been updated).
A user name that has become inactive, meaning that the user is not able to log on to the server. Users with supervisor privilege can disable a user name for any reason. User names are disabled automatically if they exceed server-specific limitations on login attempts or the number of inactive days. Only users with supervisor privilege can enable disabled user names.
The process of retrieving progressively detailed data relative to a selected dimension by expanding a parent member to reveal its children. The expansion can reveal hierarchical relationships, such as those between a parent entity and its child entity, a parent account and a child account, and a summary time period and a base time period. For example, drilling down can reveal the hierarchical relationships between year and quarters or between quarter and months.
A pointer in the rules file to header records in a data source. Header records define data load or dimension build criteria for the fields in a data source.
A process that is used to perform dynamic period-to-date reporting for all values associated with a query.
A layer of the Essbase server that provides the foundation for a variety of functionality, including data loading, calculations, spreadsheet lock&send, partitioning, and restructuring. The Essbase kernel reads, caches, and writes data; it manages transactions; and it enforces transaction semantics to ensure data consistency and data integrity.
The name of an optional configuration file for Essbase. There is a file for the server and one for the client. Administrators may enter parameters and values in this file to customize Essbase server or client settings.
The Essbase cell retrieve function. An EssCell function is entered into a cell in Essbase Spreadsheet Add-in to retrieve a single database value that represents an intersection of specific database members.
A command-line interface that is used to perform server operations interactively or through a batch file.
A text file that contains ESSCMD commands, which Essbase executes in order to the end of the file. You can run a script file from the operating system command line or from within an operating system batch file. The default extension is .SCR.
See MaxL Shell.
A type of reporting command that handles the selection, orientation, grouping, and ordering of raw data extracted from a database. These commands begin with the less than (<) character.
A value or item in a data source file that will be loaded into an Essbase database.
One or more characters, such as commas or tabs, that separate fields in a data source.
A method for controlling access to database cells in Essbase. A filter is the most detailed level of security, allowing you to define varying access levels different users can have to individual database values.
An Essbase Spreadsheet Add-in command that restores the previous database view. This command is similar to a typical Undo command.
A combination of operators and functions as well as dimension names, member names, and numeric constants. Formulas are used to perform specific calculations on members of a database.
An option in Essbase Spreadsheet Add-in that you use to type report script commands in the worksheet to create reports.
A method of creating reports in which you type members of dimensions or report script commands in a worksheet. Free-form reporting is available in both Advanced Interpretation mode and Free-Form mode.
A predefined routine that returns a value, a range of values, a Boolean value, or a list of database members. The system provides the following categories of functions: mathematical, relationship, financial, member set, Boolean, statistical, forecasting, allocation, and date-time.
A layer in a hierarchical tree structure that defines member relationships in a database. For example, Essbase orders generations incrementally from the dimension (generation 1) down to the child members.
A unique name that describes a generation.
A layer in the Essbase security system that is used to define common access settings for applications and databases.
A command that is executed when it occurs in the report script file and that stays in effect until the end of the report file or until another global command replaces it.
A set of members that is selected by a filtering process and that may be treated as a separate aggregate group. This group behaves very much like a parent to all of its specific members, and it supports full calculation logic, including additive and non-additive calculations. For example, you can use the attribute Small to view and work with all members with the attribute Small.
One or more records at the top of a data source. Header records describe the contents of the data source.
A set of multidimensional relationships in an outline, often created in a tree formation. For example, parents, children, and generations represent a hierarchy.
The integration of a relational database with an Essbase multidimensional database so that lower-level data remains in the relational database and is mapped to higher-level data residing in the Essbase database. By eliminating the necessity of loading and storing lower-level data in the Essbase database, Hybrid Analysis allows Essbase to take advantage of the mass scalability of the relational database.
A method that Essbase uses to retrieve data. The retrieval is based on the combinations of sparse dimensions. The term index also refers to the index file.
A buffer in memory that holds index pages.
A pointer to an intersection of sparse dimensions. Each index entry points to a data block on disk and locates a particular cell within the block by means of an offset.
A file that Essbase uses to store data retrieval information. It resides on disk and contains index pages.
A subdivision of an index file containing entries that point to data blocks.
A type of data block that has at least one loaded data value.
Any data that is loaded from a data source and is not generated by calculating the database.
A calculation method that tracks which data blocks have been updated since the last calculation.
A method of using ESSCMD by entering commands in the ESSCMD window and responding to prompts if necessary. For routine server administration tasks, or for complex tasks that require many commands, consider using batch processing mode.
A situation in which a specific dimension does not intersect with other dimensions. The data is not irrelevant, but because the data in the specific dimension cannot be accessed from the other dimensions, those other dimensions are not relevant to the specific dimension.
An Essbase kernel setting that determines the lock and commit behavior of database operations. Choices are committed access and uncommitted access.
A key word that is used within Essbase Spreadsheet Add-in or within Report Writer to extract data values based on the member defined as the latest period of time.
A member that has no children.
A branch within a dimension. The levels are numbered incrementally from the leaf member (level 0) towards the root.
A data block that is created for sparse member combinations when all of the members of the sparse combination are level 0 members.
See leaf member.
A unique name that describes a level.
A term that encompasses linked partitions and linked reporting objects.
A form of shared partition that provides the ability to use a data cell to link together two different databases. When a user clicks on a linked cell in a worksheet, for example, Essbase opens a new sheet displaying the dimensions in the second database. The user can then drill down into the available dimensions in the second database.
An external file that is linked to a data cell in an Essbase database. Linked reporting objects (LROs) can be cell notes, URLs, or files that contain text, audio, video, or pictures.
A location alias is a descriptor that identifies a data source. The location alias specifies a server, application, database, username, and password. Location aliases are set by the database administrator at the database level using Application Manager, ESSCMD, or the API.
A system-maintained record of transactional data resulting from actions and commands.
A character inserted between fields of a log file to allow a program to parse and manipulate log file information.
A symbol that defines how data is calculated. A mathematical operator can be any of the standard mathematical or Boolean operators; for example, +, -, *, /, and %. Mathematical operators are used in formulas, abd outlines.
The multi-dimensional database access language for Essbase. Using statements, the MaxL language enables you to perform batch or interactive system-administrative tasks on the Essbase system. See also MaxL Shell.
A Perl module (essbase.pm) that is part of the MaxL component of Essbase. You can add essbase.pm to your Perl package to provide access to Essbase databases from Perl programs. Communication from Perl to MaxL to Essbase combines the system-administrative functionality of the Essbase MaxL language with the rich programmatic control of Perl.
A script-development environment that is part of the Essbase Administration Console interface. The MaxL Script Editor is an integrated alternative to using a text editor and the MaxL Shell for creating, opening, editing, and running MaxL scripts for Essbase system administration.
An interface for passing MaxL statements to the Essbase OLAP server. The MaxLShell executable file, located in the bin directory for Essbase, is named essmsh (UNIX) or essmsh.exe (Windows).
A discrete component within a dimension. For example, a time dimension might include such members as Jan, Feb, and Qtr1.
member filtering (member selection)
The process of selecting specific members that will be used in a query. You can apply selection criteria, such as generation names, level names, pattern match, attributes, and UDAs.
In Essbase Integration Services, the process of adding new dimensions and members (without data) to a Hyperion Essbase outline. Contrast with data load.
A feature within Essbase Spreadsheet Add-in that you use to specify members for a report.
member selection report command
A type of Report Writer command that selects ranges of members based on database 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 the member to which it is associated and executes the format command before it processes the member.
In Essbase Integration Services, a template containing the structure and rules for creating a Hyperion Essbase outline from an OLAP model.
An option group that controls the default security to all of the databases of an application, using access settings (such as Read or None) that are applied globally to the application. All users connecting to databases within the application have the access level defined as minimum database access; however, individual user privileges may be higher.
A marker indicating that data in the labeled location does not exist, contains no meaningful value, or was never entered or loaded. For example, missing data exists when an account contains data for a previous or a future period but not for the current period.
multidimensional database (MDDB)
A method of organizing, storing, and referencing data through three or more dimensions. An individual value is the intersection of a point for a set of dimensions.
Within a single program, concurrent handling of multiple, separately executable sequences of program instructions.
A network protocol stack that enables Essbase clients on Windows 95/98 to communicate with Essbase servers on Windows NT (when both operating systems use NetBEUI instead of TCP/IP).
An Essbase Spreadsheet Add-in option that you use to turn off data retrieval. This feature is most useful when a database has Dynamic Calc and Dynamic Calc And Store members.
A column heading format for report columns that displays data from more than one dimension. For example, in the Sample Basic database, a column heading that contains both Year and Scenario members is a nested column. This is scripted as follows: <COLUMN (Year, Scenario). 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.
A feature that you can use to associate a base dimension member that has a discrete numeric value with an attribute that represents a range of values. For example, to classify your customers by age, you can define an Age Group attribute dimension that contains members for the following age ranges: 0-20, 21-40, 41-60, and 61-80. You can associate each member of the Customer dimension with a particular Age Group range. You can then retrieve data based on the age ranges rather than based on individual age values.
A program component that is related to an application or database. Objects can be outlines, rules files, calculation scripts, report scripts, or data sources. They are stored within the application or database subdirectory on the server or client machine.
In Essbase Integration Services, a relational database containing metadata describing the nature, source, location, and type of data that you pull from the relational data source. Essbase Integration Server accesses the OLAP Metadata Catalog to generate the SQL statements and the information required to generate a Hyperion Essbase database outline.
In Essbase Integration Services, a logical model (star schema) that you create from tables and columns in a relational database. You can then use the OLAP model to generate the structure of a multidimensional database.
A record of actions performed by the OLAP Server (agent).
online analytical processing (OLAP)
A multidimensional, multi-user, client-server computing environment for users who need to analyze consolidated enterprise data. OLAP systems feature functionality such as drilling down, data pivoting, complex calculations, trend analyses, and modeling.
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 the outline.
A record of changes made to an Essbase database outline.
See data file.
A type of report heading that lists members that are represented on the current page of the report. All data values on the page have the members in the page heading as a common attribute. Note: when printed, a report page may occupy more than one piece of paper.
A storage scheme that makes use of spare disk space to increase the available memory.
An optional calculation setting. Essbase divides a calculation into tasks and calculates some of the tasks at the same time.
In Essbase, the concurrent execution of different stages of a single data load 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.
A member that has an aggregated branch of children below it.
A subcube within a database. A partition is composed of one or more areas. These areas are composed of cells from a particular portion of the database. For replicated and transparent partitions, the number of cells within an area must be the same for both the data source and the data target to ensure that the two partitions have the same shape. If the data source area contains 18 cells, the data target area must also contain 18 cells to accommodate the number of values.
An Essbase tool that you use to create and maintain a replicated, linked, or transparent database partition. Partition Manager includes Partition Wizard, a component that contains a series of pages that step you through the partition creation process.
The process of defining areas of data that are shared or linked between data models. Partitioning can affect the performance and scalability of Essbase applications.
A group of options in the server settings that you use to limit a user's allowed number of login attempts, number of days of inactivity, and number of days using the same password.
The ability to match a value with any or all characters of an item that is entered as a criterion. A missing character may be represented by a wild card value such as a question mark (?) or an asterisk (*). For example, "Find all instances of apple" returns apple, but "Find all instances of apple*" returns apple, applesauce, applecranberry, and so on.
An interval within the time dimension.
A level of access users and groups can have for managing data or other users and groups. Permissions can be granted to users and groups explicitly or by means of filters. Administrators can also set global minimum permissions as settings for Essbase applications and databases, so that all users can have at least access to data specified by the minimum permission setting for a particular scope. The scope of a permission refers to the area of data it encompasses. The scope of a permission can be the system, an application, or a database.
The continuance or longevity of effect for any Essbase operation or setting. For example, an Essbase administrator may limit the persistence of user-name and password validity.
A version of the Essbase OLAP Server that is designed to run on one computer.
The ability to alter the perspective of retrieved data. When Essbase first retrieves a dimension, it expands data into rows. You can then pivot or rearrange the data to obtain a different viewpoint.
The process of calculating the database prior to user retrieval.
The process of keeping user-created formulas within a worksheet while retrieving new data.
A characteristic of a member, such as two-pass calculation or shared member. Properties affect how Essbase works with the data.
An Essbase Integration Server parameter or Essbase OLAP Server configuration setting that you set to control the duration and size of the queries made to the data source.
In a database, a group of fields that make up one complete entry. For example, a record about a customer might contain fields for name, address, telephone number, and sales data.
Duplicate data blocks that Essbase retains during transactions until Essbase commits the updated blocks.
An Essbase Spreadsheet Add-in command that you use to remove only the highlighted cells within a worksheet.
A portion of a database, defined through Partition Manager, that you use to propagate an update to data that is mastered at one site to a copy of data that is stored at another site. Users are able to access the data as though it were part of their local database.
The formatted summary information that is returned from a database after a report script is run. One or more reports can be generated from a report script.
An Essbase component that retrieves report data from the Essbase database when you run a report script.
An ASCII file containing Essbase Report Writer commands that generate one or more production reports. Report scripts can be run in batch mode, through the ESSCMD command-line interface, or through Essbase Application Manager. The report script is a text file that contains data retrieval, formatting, and output instructions.
An Essbase component that displays the complete report after a report script is run. Saved reports typically have the file extension .RPT.
A query sent to Essbase by a user or by another process; for example, starting an application, or restructuring a database outline. Requests happen in the context of sessions. Only one request at a time can be processed in each session. A request can be terminated by another user with the appropriate permissions (for example, by an administrator). See also session.
An operation to reload data and structural information after a database has been damaged or destroyed. The restore operation is typically performed after you shut down and restart the database.
An operation to regenerate or rebuild the database index and, in some cases, the data files.
The highest member in a dimension branch.
A horizontal display of information in a grid or table. A row can contain data from a single field, derived data from a calculation, or textual information. The words row and record are sometimes used interchangeably. Contrast with column.
A report heading that lists members down a report page. The members are listed under their respective row names.
The area of data encompassed by any Essbase operation or setting; for example, the area of data affected by a security setting. Most commonly, scope refers to three levels of granularity, where higher levels encompass lower levels. From highest to lowest, these levels are as follows: the entire system (an Essbase OLAP server), applications on an OLAP server, or databases within Essbase applications. See also persistence.
The default calculation setting. Essbase divides a calculation pass into tasks and calculates one task at a time.
A multi-user computer that accesses data values based on the intersection of dimension members.
See server.
For Essbase, the computer on which you can enter Agent commands and see messages from the Agent. If you run Essbase in the foreground on either Windows or UNIX, you can enter Agent commands. If you run Essbase in the background, you must stop Essbase and restart as a foreground process before having access to Agent commands. On UNIX, you can use a telnet session to access Essbase remotely. On Windows, you must access Essbase only from the server console.
Any occurrence that stops the server, including a crash, a power outage, or a user pressing the Ctrl+C keys.
The time between login and logout for a user connected to Essbase. A session can be terminated by another user with the appropriate permissions (for example, an administrator). If a session is processing a request at the time that an administrator attempts to terminate it, the administrator must either terminate the request first, or use "force" to terminate the session and the request simultaneously. See also request.
A member that shares storage space with another member of the same name. The shared member has a property that designates it as shared. The use of shared members prevents duplicate calculation of members that appear more than once in an Essbase outline.
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 both children of the member, East, and siblings of each other.
See symmetric multiprocessing (SMP).
A dimension with a low probability that data exists for every combination of dimension members.
Essbase software that works with your spreadsheet. Essbase Spreadsheet Add-in is an add-in module to your spreadsheet software.
A dimension that is not an attribute dimension.
A cross-section of data. Subsetting further defines members that meet specific conditions.
A variable that acts as a global placeholder for information that changes regularly. You set the variable and a corresponding string value; the value can then be changed at any time. Substitution variables can be used in calculation scripts, report scripts, Essbase Spreadsheet Add-in, and Essbase API.
The option to exclude rows that contain missing values and to underscore characters from spreadsheet reports.
See paging.
symmetric multiprocessing (SMP)
A server architecture that enables multiprocessing and multithreading. Essbase supports multiple threads over SMP servers automatically. Thus, performance is not significantly degraded when a large number of users connect to an Essbase server simultaneously.
A person who maintains the hardware, software, disk space distribution, and configurations for running software applications such as Essbase.
See Transmission Control Protocol/Internet Protocol (TCP/IP).
A predefined format that is designed to retrieve particular data on a regular basis and in a consistent format.
A process of reporting data based on a calendar date (for example, year, quarter, month, or week).
A series of shortcut buttons providing quick access to commands. The toolbar is usually located directly below the menu bar. Not all windows have a toolbar.
Transmission Control Protocol/Internet Protocol (TCP/IP)
A standard set of communications protocols that is adapted by many companies and institutions around the world and that links computers with different operating systems and internal architectures. You use TCP/IP utilities to exchange files, send mail, and store data to various computers that are connected to local and wide area networks.
A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users.
A user-defined attribute. A UDA is a term associated with members of an outline to describe a particular characteristic of the members. Users can specify UDAs within calculation scripts and reports so that they return lists of members that have the specified UDA associated with them. UDAs can be applied to dense as well as sparse dimensions.
A group of mathematical indicators (+, -, *, /, %) that define how roll-ups take place on the database outline.
An Essbase kernel setting that affects how Essbase handles transactions. Under uncommitted access, concurrent transactions hold short-term write locks and can yield unpredictable results.
Uniform Resource Locator (URL)
An address for a resource located on the World Wide Web, such as a document, image, downloadable file, service, or electronic mailbox. URLs use a variety of naming schemes and access methods, such as HTTP, FTP, and Internet mail. An example of a URL is http://www.hyperion.com. A URL can also point to a file located on a local or network drive, such as file:///D:/essbase/docs/essdocs.htm.
See Uniform Resource Locator (URL).
A process of checking a rules file, report script, or partition definition against the outline to make sure the object being checked is valid.
A formatted style, such as a font or a color, that highlights specific types of data values. Data values may be dimension members; parent, child, or shared members; dynamic calculations; members containing a formula; read only data cells; read/write data cells; or linked objects.
An entire spreadsheet file with many worksheets.
![]() © 2002 Hyperion Solutions Corporation. All rights reserved. http://www.hyperion.com |