Restrictions for Dimensions, Members, Aliases, and Forms

When naming dimensions, members, and aliases, follow these rules:

• For dimensions, members, or aliases, use no more than 80 characters.

  Note:

  • For Entity members, names cannot exceed 76 characters in length.
  • For all dimensions, do not use commas in member names.

• Do not use HTML tags in member names, dimension names, aliases, and descriptions.

• The following is a list of characters that are restricted and cannot be used in dimension, member, and alias names:

  Table 5-1 Restricted Characters in Dimension, Member, and Alias Names

  Character	Meaning
  "	quotation mark
  [ ]	bracket
  \	backslash
  /	slash

  Note:

  • Brackets [ ] are permitted but not recommended in block storage outlines. They cause errors when converting to aggregate storage outlines.

  • Do not use the ASCII substitute character (zero-width space character) 0x1A in member names and aliases.

• The following is a list of characters that cannot be used at the beginning of dimension, member, and alias names:

  Table 5-2 Restricted Characters at the Beginning of Dimension, Member, and Alias Names

  Character	Meaning
  @	at sign
  &	ampersand
  \	backslash
  [ ]	brackets
  ,	comma
  -	dash, hyphen, or minus sign
  =	equal sign
  <	less than sign
  ( )	parentheses
  .	period
  +	plus sign
  "	quotation mark
  /	slash
  _	underscore
  |	vertical bar

  Note:

  Member names with the preceding characters are not allowed in business process data export jobs.

• Do not place spaces at the beginning or end of names. Such spaces are ignored.

• Do not use forward slashes in member names.

• For time periods in custom calendars, do not use spaces in prefixes.

• Do not use these words as dimension or member names:

  • Calculation script commands, operators, and keywords.

  • Do not prefix an object name with any of the following: OEP_, OFS_, OCX_, OWP_, OPF_, FCCS_, TRCS_, ARCS_, OQP_, OGS_. For example, the prefix "TRCS_A" is invalid. However, you can use the acronyms within the object name, for example, A_TRCS, BTRCS, or TRCSB.

  • Function names and function arguments.

  • Names of other dimensions and members (unless the member is shared).

  • If Dynamic Time Series is enabled, do not use History, Year, Season, Period, Quarter, Month, Week, or Day.

• The following is a list of words that are restricted and cannot be used in dimension, member, and alias names:

  Table 5-3 Restricted Words in Dimension, Member, and Alias Names

  Restricted Word	Restricted Word	Restricted Word
  ALL	AND	ASSIGN
  AVERAGE	CALC	CALCMBR
  COPYFORWARD	CROSSDIM	CURMBRNAME
  DIM	DIMNAME	DIV
  DYNAMIC	EMPTYPARM	EQ
  EQOP	EXCEPT	EXP
  EXPERROR	FLOAT	FUNCTION
  GE	GEN	GENRANGE
  GROUP	GT	ID
  IDERROR	INTEGER	LE
  LEVELRANGE	LOCAL	LOOPBLOCK
  LOOPPARMS	LT	MBR
  MBRNAME	MBRONLY	MINUS
  MISSING	MUL	MULOP
  NE	NON	NONINPUT
  NOT	OR	PAREN
  PARENPARM	PERCENT	PLUS
  RELOP	SET	SKIPBOTH
  SKIPMISSING	SKIPNONE	SKIPZERO
  STATUS	TO	TOLOCALRATE
  TOP	TRAILMISSING	TRAILSUM
  TYPE	UMINUS	UPPER
  VARORXMBR	XMBRONLY	$$UNIVERSE$$
  #MISSING	#MI