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

When Essbase member names contain special characters, and you cite these member names in variable values, scripts, filters, partitions, or formulas, you need to use the appropriate enclosures to quote the member names. Which enclosure you need depends on whether the database is block storage or aggregate storage.

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 (or aggregate storage outline formulas), 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 the table below:

  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