Table of Contents:
This document describes the new features in Oracle Essbase Release 18.104.22.168. For detailed information on these features, see the Oracle Essbase Database Administrator's Guide, Oracle Essbase Technical Reference, and Oracle Essbase API Reference.
For information about the new features in Oracle Essbase Administration Services, see the Administration Services Readme.
Similar to substitution variables, a runtime substitution variable can be included in a calculation script wherever substitution variables are allowed. Runtime substitution variables are different from substitution variables in that every runtime substitution variable used in a calculation script must be declared in the SET RUNTIMESUBVARS calculation command. In SET RUNTIMESUBVARS, the name of a runtime substitution variable is required. Specifying a default value for the runtime substitution variable is optional. At runtime, values can be provided for runtime substitution variables that do not have a default value, and default values that are specified in the SET RUNTIMESUBVARS command can be overwritten using MaxL or the Essbase API.
Runtime substitution variables are supported for block storage databases only.
A new hashtable implementation optimizes the performance of name lookup and insertion when building dimensions and editing outlines. This hashtable implementation has an increased memory footprint.
To configure the hashtable, use the ESTIMATEDHASHSIZE configuration setting. This setting specifies, in millions, the estimated number of member name and alias name strings that are loaded into memory.
The ESTIMATEDHASHSIZE configuration setting applies to block and aggregate storage applications.
In grid clients (for example, Oracle Hyperion Smart View for Office), you can reference shared members as unique from their base members by typing them with a qualified name (for example, [Parent].[Child]). Shared members can be referenced with qualified names even if you have not set the outline to enable duplicate member names.
When using the Teradata TPT-API for data load, you can customize settings that provide greater flexibility while loading data through the TPT-API. For more information, see Appendix A in the Oracle Essbase SQL Interface Guide.
@CREATEBLOCK—Creates a block for a sparse member name or a sparse member combination and sets dense values in the newly created block to #MISSING.
@INTERSECT—Returns the intersection of members that appear in two specified lists of members.
@ISMBRUDA—Returns TRUE if the specified user-defined attribute (UDA) exists for the specified member at calculation time.
@ISRANGENONEMPTY—Tests for the existence of data values to improve performance of complex dense processing. If this function returns true, values exist for the specified range. If it returns false, the range is empty.
@MEMBERAT—Returns the specified member in a list of members.
@RANGEFIRSTVAL—Returns the first value, in a range of the specified mbrList, that satisfies the criterion specified in the first function parameter.
@RANGELASTVAL—Returns the last value, in a range of the specified mbrList, that satisfies the criterion specified in the first function parameter.
The @NAME calculation function has a new, optional argument, UNIQUE, which tells @NAME to return a unique member name (using shortcut qualified name format) for mbrName, if mbrName is a duplicate name. If mbrName is not a duplicate name or if duplicate member names is not enabled, UNIQUE is ignored, and only the member name is returned.
ENABLERTSVLOGGING—Determines whether Oracle Essbase logs runtime substitution variables that are used in a calculation script.
ESTIMATEDHASHSIZE—Specifies, in millions, the estimated number of member name and alias name strings that are loaded into memory.
UNICODEENABLE—Enables Essbase Server to create Unicode-mode applications and to migrate applications to Unicode mode, without needing to set the Essbase Server to Unicode mode using Oracle Essbase Administration Services, MaxL, or the API.
The execute calculation MaxL statement has new grammar: with runtimesubvars RTSV-LIST. This grammar executes a calculation script with the specified runtime substitution variables, which are specified as a string of key/value pairs.
EssCalcFileWithRuntimeSubVars—Executes a calculation script against the active database with the specified runtime substitution variables. Runtime substitution variables can be specified in a text file (with a .rsv extension) or as a string of key/value pairs
EssCalcWithRuntimeSubVars—Executes a calculation script with the specified runtime substitution variables, which are specified as a string of key/value pairs.
EssGetRuntimeSubVars—This function is implemented as an interface to a client in which a calculation script is run. This function retrieves all of the information (name, value, and description) that is specified in the runtime substitution variable declarations in the SET RUNTIMESUBVARS calculation command for a specified calculation script.
Documentation files for Release 22.214.171.124 are now available in two mobile formats: MOBI files, available previously, and EPUB files. Oracle Enterprise Performance Management System EPUB documentation files are supported on all Apple Mobile devices (iPad, iPhone, and iPod Touch). EPUB files are supported on many mobile devices; however, they are certified only on Apple Mobile devices. Additional devices will be certified over time.
If you are coming from Release 126.96.36.199, 188.8.131.52, or 184.108.40.206, use the Cumulative Feature Overview tool to review the list of new features added between those releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here: