Naming Conventions in Calculation Scripts, Report Scripts, Formulas, Filters, and Substitution and Environment Variable Values

In substitution variable values, environment variable values, calculation scripts, report scripts, filter definitions, partition definitions, or formulas, you must enclose member names in brackets ([ ]) when used within MDX statements, and otherwise in quotation marks (" "), in these situations:

  • Name starts with one or more numerals (for example, 100).

  • Name contains spaces or any characters listed in Table B-2:

    Table B-2 Characters that Require Member Name Enclosures

    Character Description

    &

    ampersand

    *

    asterisk

    @

    at sign

    \

    backslash

    { }

    braces

    :

    colon

    ,

    comma

    -

    dash, hyphen, or minus

    !

    exclamation point

    =

    equal sign

    >

    greater than sign

    <

    less than sign

    ()

    parentheses

    %

    percent sign

    .

    period

    +

    plus sign

    ;

    semicolon

    /

    slash

    ~

    tilde

In calculation scripts and formulas, you must enclose these member names, which are also Essbase keywords, in quotation marks (" ") for block storage databases, and in brackets ([ ]) for aggregate storage databases:

BEGIN
DOUBLE 
ELSE
END
FUNCTION
GLOBAL
IF
MACRO
MEMBER
RANGE
RETURN
STRING
THEN