Databases Reference
In-Depth Information
Notice how the
EXCLUDE
command has an area to list dimensions. Within the
parenthesis you can list dimension names separated by commas, member names,
or a list of member functions that return member names. There are also functions
that return members at specific levels in the outline. You can even use basic
structuring similar to a mathematical formula with
AND
/
OR
statements bracketed by
extra parenthesis.
In the example immediately above, notice how we are calculating the value for
Gross Stock
for all markets except
Canada
.
There has not been a tremendous amount of feedback regarding the
use and performance of
EXCLUDE
and
ENDEXCLUDE
as they are new in
version 9.x. We can only assume that the
EXCLUDE
and
ENDEXCLUDE
commands function exactly like the
FIX
and
ENDFIX
commands, except
to exclude the referenced data instead of including the referenced data.
Aren't
EXCLUDE
and
ENDEXCLUDE
commands the greatest as well?
Functional
In Essbase database calculation scripts, you may be required to perform certain
functional commands like
Set
functions,
Cleardata
functions, or the
Datacopy
function that is used to copy data from one member to another member, all before
you start the execution of your database calculation.
SET command functions
SET
command functions are used to tune the calculation and database factors
that affect calculation performance and are initially coded at the beginning of a
calculation script.
SET
commands stay in effect for the duration of the calc script
unless coded again mid-script.
Let's take a look at some of the widely used
SET
command functions:
•
SET AGGMISSING ON/OFF
: This command specifies if Essbase should turn
the consolidation of the # missing values
ON
or
OFF
. This is only applicable
to Sparse dimensions.
Example:
SET AGGMISSING ON;
SET AGGMISSING OFF;