Databases Reference
In-Depth Information
°
DYNAMIC
: Clears and sets "#missing" to all of the data which has
been created by a Dynamic Calc and Store member.
°
EMPTY
: Removes all of the blocks which are already
"#missing" blocks.
Examples:
CLEARBLOCK ALL;
CLEARBLOCK UPPER;
•
CLEARDATA
MemberName
: Removes all of the data for the member name
specified, replacing it with "#missing". The "#missing" symbol is Essbase
speak for null values.
Example:
CLEARDATA "TOTAL REVENUE";
The functions discussed above are just some of the more widely used calculation script
functions available to you. We will discuss more functions in the coming chapters.
Conditionals
In the Essbase database calculation script, like most other programming languages,
you can test data situations with conditional statements. Without a doubt, the
IF
and
ENDIF
statements are the most common.
IF/ENDIF
Ah yes, the
IF
and
ENDIF
commands, the partners to the
FIX
and
ENDFIX
commands.
As stated earlier in this chapter, these tools have been provided to allow you to write
high performing and efficient calculation scripts and to precisely calculate your data
without stomping on other data.
If the
FIX
and
ENDFIX
commands are the gate keeper of the data, the
IF
and
ENDIF
commands are the ushers directing you (your data) to the correct seat. Just like the
IF
and
ENDIF
commands in any programming language, the
IF
and
ENDIF
commands
you use in Essbase for calculating, perform conditional checking or testing of the data
to help decide if or how it gets calculated.