Character and size limits in Analytics

There are limits to certain input ranges and user-defined parameters in Analytics. The sections below explain the limits and the results when you exceed them.

Remarks

These additional details apply to Analytics character and size limits:

• Non-Unicode versus Unicode specified limits apply to both the non-Unicode and Unicode editions of Analytics, except where noted.
• Characters and bytes Character limits apply to the single-byte character encoding used in the non-Unicode edition, and the double-byte character encoding used in the Unicode edition. In other words, a 256-character limit means 256 characters in either edition.
• Location of source data Analytics limits are the same whether the source data resides in an Analytics data file (.fil), or in an external file or a database. External data sources may impose their own limits that differ from the Analytics limits.

Analytics project limits

Parameter	Limit	Result when limit exceeded
Maximum file size of an Analytics project	1GB (tested successfully)
Maximum number of tables in an Analytics project	5,150 (tested successfully)
Maximum length of an Analytics project path and project name	259 characters Includes the file path, project name, and file extension (.acl)	Truncation to 259 characters
Maximum length of an Analytics project path and command log name	259 characters Includes the file path, command log name, and file extension (.log)	Error message
Maximum length of an Analytics project folder name	64 characters	Truncation to 64 characters
Valid characters in an Analytics project folder name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )
Maximum length of a note (table, layout, view, project)	32,765 characters	Truncation to 32,765 characters
Maximum length of a field note	4,996 characters	Truncation to 4,996 characters

Table limits

Parameter	Limit	Result when limit exceeded
Maximum number of records in a table	2,147,483,647 (tested successfully)
Maximum record length	32,767 characters (non-Unicode edition) 16,383 characters (Unicode edition)	Analytics resets to 32,767/16,383 characters
Maximum number of fields in a table	1,498 (tested successfully)
Maximum length of a table layout name	64 characters	Truncation to 64 characters
Valid characters in a table layout name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )
Maximum length of a source data file path and name	255 characters	Analytics stops working

View limits

Parameter	Limit	Result when limit exceeded
Maximum number of columns in a view	No specific limit on the number of columns Columns cannot exceed the maximum record length of 32,767 characters (non-Unicode)/16,383 characters (Unicode) Note After the initial import of data, the default view displays a maximum of 256 columns, even if a greater number of columns were imported. If required, you can manually add the additional columns to the view. For more information see Add columns to a view.	Error message
Maximum length of a view name	64 characters	Truncation to 64 characters
Valid characters in a view name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )

Field and column limits

Parameter	Limit	Result when limit exceeded
Maximum field length	32,767 characters (non-Unicode edition) 16,383 characters (Unicode edition)	Error message
Maximum length of a field name	256 characters 64 characters for ODBC imports 64 characters for exports to Microsoft Excel and Access	Truncation to 256 characters Truncation to 64 characters Error message
Valid characters in a field name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )
Maximum length of an Alternate Column Title (display name)	256 characters	Truncation to 256 characters
Maximum width of a computed field	255 characters	Error message and value resets to 1 if value entered exceeds 255 characters
Maximum width of a column in a view	255 characters	Error message and value resets to 1 if value entered exceeds 255 characters Columns can temporarily be extended beyond 255 characters by dragging the column boundary in the view, but will be reset in the Modify Columns dialog box
Maximum number of digits in a numeric field (including decimal places)	22	Truncation or error message

Filter limits

Parameter	Limit	Result when limit exceeded
Maximum length of a filter name	256 characters	Truncation to 256 characters
Valid characters in a filter name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )

Index limits

Parameter	Limit	Result when limit exceeded
Maximum length of an index name	64 characters	Truncation to 64 characters
Valid characters in an index name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )
Maximum length of index key field	247 characters	Error message
Maximum number of index key fields	246 characters total length	Error message

Quick sort limits

Parameter	Limit	Result when limit exceeded
Maximum length of quick sort field	247 characters	Quick Sort menu option disabled

Command limits

Parameter	Limit	Result when limit exceeded
Maximum number of characters in a command	32,765 characters Note In some cases, command syntax that exceeds the stated limit may work. However, there is no guarantee that subsequent versions of Analytics will continue to support exceeding the limit.	Truncation to 32,765 characters and an associated error message

Expression limits

Parameter	Limit	Result when limit exceeded
Maximum number of characters in an expression	8188 characters	Error message
Maximum number of characters in an IF or WHILE condition	4094 characters	Error message
Maximum number of characters in an individual Condition or Value	4094 characters	Error message and resets to 2 KB
Maximum number of characters in the conditions contained in a conditional computed field	32,000 characters	Error message

Variable limits

Parameter	Limit	Result when limit exceeded
Maximum length of a variable name	31 characters	Error message
Valid characters in a variable name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ ), or error message

Script limits

Parameter	Limit	Result when limit exceeded
Maximum length of a script name	64 characters	Truncation to 64 characters
Valid characters in a script name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )

Workspace limits

Parameter	Limit	Result when limit exceeded
Maximum length of a workspace name	64 characters	Truncation to 64 characters
Valid characters in a workspace name	Alphanumeric characters, and the underscore character ( _ ) The name cannot contain any special characters or spaces, or start with a number	Replacement of an invalid character with an underscore character ( _ )

Date limits

Parameter	Limit	Result when limit exceeded
Range of supported dates	1 Jan 1900 to 31 Dec 9999 (inclusive)	Error message

Dialog Builder limits

Parameter	Limit	Result when limit exceeded
Maximum number of Drop-down list options	32 list items	Will not accept additional text beyond 32 items in the Label List
Maximum size of a single Drop-down Item Label	256 characters	Truncated to 256 characters

Option dialog box limits

Parameter	Limit	Result when limit exceeded
Maximum Buffer Size	255 KB	Error message