Naming Restrictions for Dimensions, Members, and Aliases

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

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

  • Don't use dimension names that are the same name as a member property or a column header in the metadata load file (for example, Data Type).

  • Don't use HTML tags in member names, dimension names, aliases, and descriptions.

  • These special characters or keys aren't permitted in dimension, member, and alias names:

    • quotation mark ( " )

    • bracket ( [ ] )

    • backslash ( \ )

    • slash ( / )

    • tab

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

  • Don't use these special characters to begin dimension or member names:

    • at sign ( @ )

    • backslash ( \ )

    • bracket ( [ ] )

    • comma ( , )

    • dash, hyphen, or minus sign ( - )

    • equal sign ( = )

    • less than sign ( < )

    • parentheses ( )

    • period ( . )

    • plus sign ( + )

    • quotation mark ( " )

    • slash ( / )

    • underscore ( _ )

    • vertical bar ( | )

    Also, member names with the above special characters are not allowed in Planning data export jobs.

  • Don't place spaces at the beginning or end of names.

  • For time periods in custom calendars, don't use spaces in prefixes.

  • Shared members must have the same names as their base member. Also, base and shared member names are case-sensitive.

  • Don't use these words as dimension or member names:

    • Calculation script commands, operators, and keywords.

    • Function names and function arguments.

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

    • If Dynamic Time Series is enabled, don't use History, Year, Season, Period, Quarter, Month, Week, or Day.

    • In unique member outlines that contain an attribute dimension, don't use Sum, Count, Min, Max, and Avg as member or dimension names. Using these names causes duplicate name conflicts.

      Note:

      The members that are created in the attribute calculations dimension (Sum, Count, Min, Max, and Avg) are not considered reserved words because you can change these names in the attribute calculations dimension and then use the standard name in an attribute or standard dimension.

      If the outline is tagged as a unique member outline, avoid using Sum, Count, Min, Max, and Avg as member names. For example, if you use Max in a standard dimension and then create an attribute dimension, in which the Max member in the attribute calculations dimension are created, a duplicate name is detected and the following error message is returned:

      "Analytic Server Error(1060115): Attribute Calculations dimension/member name already used." 

      If the outline is tagged as a duplicate member outline, and an attribute dimension (and, therefore, the attribute calculations dimension) exists before you use Sum, Count, Min, Max, and Avg as a base member, the duplicate name is allowed. However, if, you use Sum, Count, Min, Max, and Avg as a base member before creating an attribute dimension, the duplicate name isn't allowed.

    • These words:

      • 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

      • REQUEST

      • SET

      • SKIPBOTH

      • SKIPMISSING

      • SKIPNONE

      • SKIPZERO

      • STATUS

      • TO

      • TOLOCALRATE

      • TRAILMISSING

      • TRAILSUM

      • TYPE

      • UMINUS

      • UPPER

      • VARORXMBR

      • XMBRONLY

      • $$UNIVERSE$$

      • #MISSING

      • #MI