Dimension and Member Names in Calc Scripts, Report Scripts, Formulas, Filters, and Substitution Variables

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

The name starts with one or more numerals (for example, 100).

The name contains spaces or these characters:

&	ampersand	>	greater than sign
*	asterisk	<	less than sign
@	at sign	()	parentheses
\	backslash	%	percent sign
{ }	brackets	.	period
:	colon	+	plus sign
,	comma	;	semicolon
-	dash, hyphen, or minus	/	slash
!	exclamation point	~	tilde
=	equal sign

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

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

Enclose in quotes names that contain these characters in calc scripts, report scripts or formulas, and names that start with these characters: Spaces + - * / ( ) : , @ ; ) { } [ ] <